connection string .NET

Hi Vipendra,


Connection string in .NET 2.0 config file

In the appSettings location, add a key named whatever you like to reference your connection string to.





To read the connection string from code, use the ConfigurationSettings class.

string connStr = ConfigurationSettings.AppSettings("myConnectionString");

Now you have the connection string loaded from web.config into your string variable in code.


Connection string in .NET 3.5 (and above) config file

Do not use appsettings in web.config. Instead use the connectionStrings section in web.config.





To read the connection string into your code, use the ConfigurationSettings class.

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



Thanks

It depends, of course, on which database you're using but I've always found the following site to be a reliable reference for connection strings to all popular databases:

http://www.connectionstrings.com/