How can we retrieve connection string information from web.config file? I am unable to write the code for it.
-
See stackoverflow.com/a/13043569/453277 and many other questions. Your question is likely to be closed unless you show some research effort and you show how those existing answers do not address your question.Tim M.– Tim M.2016-04-20 18:55:20 +00:00Commented Apr 20, 2016 at 18:55
Add a comment
|
5 Answers
Import System.Configuration into your project.
then
var connectionString = ConfigurationManager.ConnectionStrings["NameOfString"];
Comments
You can have a method of a string and call the string in your web.config file
private string Get_ConnectionString
{
return System.Configuration.ConfigurationManager.ConnectionStrings["NAME OF STRING"].ConnectionString;
}
Comments
Using ConfigurationManager class you can read settings in web.config and app.config.
This class have a property called ConnectionStrings which gets the ConnectionStringsSection data for the current application's default configuration.
Comments
Since you have mentioned Web.config, i assumed its for a web project. You need to add reference to System.Configuration namespace to your web project
static internal string connString = System.Configuration.ConfigurationManager.ConnectionStrings["YourConnection"].ConnectionString;
Comments
You need to add System.Configuration as a reference:
System.Configuration.ConfigurationManager.ConnectionStrings["XYZ"].ConnectionString
