connection string .NET

Question

Hi friends I want to know how to make connection string .NET. Thank you.

Satyapriya Nayak · Answer

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

Vulpes · Answer

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/