CODEWITHSUNDEEP
c#web-configconnection-string
Shyju
Shyju

Reputation: 218702

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

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>

Upvotes: 10

Views: 1901

Answers (1)

Canavar
Canavar

Reputation: 48088

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.

Upvotes: 21

Related Questions