In C# , how can I read a connection string stored in my web.config file connection string?

Question

In C# class library, how can I read a connection string stored in my web.config file connection string tag? As in:

<connectionStrings>
 <add name="CLessConStringLocal" connectionString="server=localhost;database=myDb;uid=sa;pwd=mypassword;"/>
</connectionStrings>

Canavar · Accepted Answer · 2009-11-27 20:13:20Z

21

Use ConfigurationManager.ConnectionStrings collection to access the connection stings that stored in your configuration files.

For example :

string myConnectionString = ConfigurationManager
          .ConnectionStrings["CLessConStringLocal"].ConnectionString;

Note : Do not forget to reference to System.Configuration assembly.

answered Nov 15, 2009 at 12:15

Canavar

48.1k17 gold badges94 silver badges126 bronze badges

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

1 Answer 1