Read Connection String Parameters

Question

Curious to know if there is a way to read in some parameters of the connectionstring within the web.config file? For example, if I had a Settings page on my website for administrators only, and one of the views within there was to show the name, providerName, and connectionString... could I do this?

<add 
name="DbConnectionString" 
providerName="System.Data.SqlClient" 
connectionString="Data Source=yourservernamehere.net 
/>

ConfigurationManager.ConnectionStrings["DbConnectionString"] returns an object with those properties. — madreflection
– madreflection, Commented Jan 13, 2020 at 4:24
Thanks madrefiection! I thought I was going crazy here, because i had tried this and it didn't work. Another member just let me know that the using system.configuration may not have been declared, which it wasn't. I'll mark this as resolved now. — Stephen85
– Stephen85, Commented Jan 13, 2020 at 4:28
Also if you use app settings, you can use stackoverflow.com/questions/10766654/… — dimmits
– dimmits, Commented Jan 13, 2020 at 9:33

Nguyen Van Thanh · Accepted Answer · 2020-01-13 06:41:18Z

4

Curious to know if there is a way to read in some parameters of the connectionstring within the web.config file?

Yes.

For example, if I had a Settings page on my website for administrators only, and one of the views within there was to show the name, providerName, and connectionString... could I do this?

Yes. You can do the same:

using System.Configuration;
string yourConnectionString = ConfigurationManager.ConnectionStrings["yourConnectionStringNameInYourConfigFile"].ConnectionString;

edited Jan 13, 2020 at 6:41

answered Jan 13, 2020 at 4:40

Nguyen Van Thanh

82511 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Shahid Manzoor Bhat · Accepted Answer · 2020-01-13 04:40:42Z

0

First step was to ensure using System.Configuration is declared.

SqlConnection dbConn = new SqlConnection(ConfigurationManager.ConnectionStrings["DbConnectionString"].ToString());

lblDBConnName.Text = dbConn.DataSource.ToString();

edited Jan 13, 2020 at 4:40

Shahid Manzoor Bhat

1,3331 gold badge15 silver badges32 bronze badges

answered Jan 13, 2020 at 4:29

Stephen85

2702 silver badges16 bronze badges

1 Comment

madreflection Over a year ago

Don't use ToString() to get the connection string. Use the ConnectionString property. It's reasonable that the implementation of ToString may change, even if only subtly, but the ConnectionString property won't because that's its exact purpose.

Collectives™ on Stack Overflow

Read Connection String Parameters

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related