How to retrieve a connection string from web.config?

Question

How can we retrieve connection string information from web.config file? I am unable to write the code for it.

See http://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., Apr 20 '16 at 18:55

score 2 · Answer 1 · answered Apr 20 '16 at 18:54

2

Import System.Configuration into your project.

then

var connectionString = ConfigurationManager.ConnectionStrings["NameOfString"];

answered Apr 20 '16 at 18:54

Jared Lovin

543
9
24

score 0 · Answer 2 · answered Apr 20 '16 at 18:55

0

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;
}

answered Apr 20 '16 at 18:55

walangala

231
1
4
15

score 0 · Answer 3 · answered Apr 20 '16 at 18:56

0

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.

answered Apr 20 '16 at 18:56

Arturo Menchaca

15,783
1
29
53

score 0 · Answer 4 · edited Feb 17 '17 at 10:14

0

You need to add System.Configuration as a reference:

System.Configuration.ConfigurationManager.ConnectionStrings["XYZ"].ConnectionString

edited Feb 17 '17 at 10:14

Oskar

1,996
1
22
39

answered Apr 20 '16 at 18:57

Saad Abdullah

21
6

score 0 · Answer 5 · answered Apr 20 '16 at 18:57

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;

How to retrieve a connection string from web.config?

5 Answers5