Using connection string from web.config

Question

I try to connect to my database and I can do that using following code:

using (SqlConnection conn =
    new SqlConnection("Data Source=.\\SQLEXPRESS; Initial Catalog=DocumentManager; Persist Security Info=True; Integrated Security=True")) 
{ ... }

But, when I try this:

string connectionString = ConfigurationManager.ConnectionStrings["DatabaseConnection"].ConnectionString;
using (SqlConnection conn = new SqlConnection(connectionString)) { ... }

it doesn't work anymore. My Connection String looks like this:

<add name="DatabaseConnection" connectionString="Data Source=.\\SQLEXPRESS; Initial Catalog=DocumentManager; Persist Security Info=True; Integrated Security=True" />

And, I can read the connectionString variable and it looks exactly like the string in the first case.

There is no error. I try to display data from database and there is no data. — user3482724
– user3482724, Commented Apr 7, 2014 at 18:59

Khan · Accepted Answer · 2014-04-07 19:04:14Z

2

Your in-code connection string has an escaped "\" in it.

Try changing your web.config to:

<add name="DatabaseConnection" connectionString="Data Source=.\SQLEXPRESS; Initial Catalog=DocumentManager; Persist Security Info=True; Integrated Security=True" />

The "\" does not need to be escaped in your web.config.

This is an example of escaping the backslash.

edited Apr 7, 2014 at 19:04

answered Apr 7, 2014 at 18:58

Khan

18.2k5 gold badges52 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

display name · Accepted Answer · 2014-04-07 19:00:48Z

0

Try this

string connectionString = System.Configuration.ConfigurationManager.AppSettings("DatabaseConnection");

answered Apr 7, 2014 at 19:00

display name

4,1952 gold badges32 silver badges55 bronze badges

Collectives™ on Stack Overflow

Using connection string from web.config

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related