Get database name from connectionstring

[Luigi]

Hi all,
how can I obtain the dabase name from a connectionString retrieved from a
ConfigurationManager.ConnectionStrings["MyConnectionString"]?

I need this to set the text value of a label.

Thanks in advance.

Luigi

 

[Morten Wennevik [C# MVP]]

Hi Luigi,

I haven't tested this, but if you create an SqlConnection it has a Database
property that might hold the value you need. If the connection string is in
a specific format, you could also just parse the string, but connection
strings can come in many flavours (see www.connectionstrings.com).

 

[Luigi]

Hi Luigi,

I haven't tested this, but if you create an SqlConnection it has a Database
property that might hold the value you need. If the connection string is in
a specific format, you could also just parse the string, but connection
strings can come in many flavours (see www.connectionstrings.com).

Hi Morten,
yes, finally I've made like this:

string connString =
ConfigurationManager.ConnectionStrings["PrideConnectionString"].ToString();

SqlConnection connection = new SqlConnection(connString);
string database = connection.DataSource.ToString();

if (database == "MILDBBP2S")
this.lblCurrentEnviroment.Text = "Produzione";

else if (database == "MILDBBP2STEST")
this.lblCurrentEnviroment.Text = "Test";

else
this.lblCurrentEnviroment.Text = "Server unknown";

Thanks so much.

Luigi

 

[Nicholas Paldino [.NET/C# MVP]]

You can also use the SqlConnectionString class, which will give you more
detailed information about the individual properties of the connection
string. It inherits from the DbConnectionStringBuilder, which most
providers should provide an implementation of to help with encapsulating the
logic of constructing (and parsing) connection strings.


--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

Hi Luigi,

I haven't tested this, but if you create an SqlConnection it has a
Database
property that might hold the value you need. If the connection string is
in
a specific format, you could also just parse the string, but connection
strings can come in many flavours (see www.connectionstrings.com).

Hi Morten,
yes, finally I've made like this:

string connString =
ConfigurationManager.ConnectionStrings["PrideConnectionString"].ToString();

SqlConnection connection = new SqlConnection(connString);
string database = connection.DataSource.ToString();

if (database == "MILDBBP2S")
this.lblCurrentEnviroment.Text = "Produzione";

else if (database == "MILDBBP2STEST")
this.lblCurrentEnviroment.Text = "Test";

else
this.lblCurrentEnviroment.Text = "Server unknown";

Thanks so much.

Luigi