Not able to find Connection string from web.config

Question

0.00/5 (No votes)

See more:

Hi,

when I am trying to use connection string from Web.Config , it is showing null...

I used

C#

string conStr = WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

and

C#

string conStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

Please Help

Thank You

Posted 18-Aug-14 21:22pm

Member 3567411

Updated 19-Aug-14 21:29pm

Herman<T>.Instance

v2

Add a Solution

Comments

Hemant Singh Rautela 19-Aug-14 3:42am

And your webcofing section code..??

Is it same as :

<connectionstrings>
<add name="ConnectionString" connectionstring="Server=database_server_ip;Initial Catalog=databasename;User ID=username;Password=yourpassword">
</add>
</connectionstrings>

Or anything else....??

Anup kumar(MCA) 21-Aug-14 7:32am

are you using multiple applications in your solution?

5 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sharmanuj · Answer 1 · 2014-08-19T21:44:00

Check whether you have mentioned the details under ConnectionString Tag or AppSettings Tag in your web.config file.

If connection string is in ConnectionString Tag then use this

C#

string conStr = ConfigurationManager.ConnectionStrings["ConnectionStringName"].ConnectionString.ToString();

If connection string is in AppSettings Tag then use this

C#

string conStr = ConfigurationManager.AppSettings["ConnectionStringName"].ToString();

NowYouSeeMe · Answer 2 · 2014-08-18T21:26:00

Solution 1

C#

System.Configuration.ConfigurationManager.
    ConnectionStrings["connectionStringName"].ConnectionString;

note:"connectionStringName" must be same as in webconfig

Posted 18-Aug-14 21:26pm

NowYouSeeMe

Comments

Member 3567411 19-Aug-14 3:39am

Hi,
I have used the same name as per the web.config file ...
System.Configuration.ConfigurationManager.
ConnectionStrings["connectionStringName"].ConnectionString;
above code is not working...

NowYouSeeMe 19-Aug-14 3:57am

post your connection string from web config here

Sanchayeeta 20-Aug-14 2:36am

Please post your connection string from web.config and the code where you have used it.

Gihan Liyanage · Answer 3 · 2014-08-19T20:21:00

Solution 2

Check if the web.config is at its right location?
Do you have any web.config (which overrides main web.config) in the same folder as that of your page?

Posted 19-Aug-14 20:21pm

Gihan Liyanage

Comments

Gihan Liyanage 15-Sep-14 6:17am

Did you got a solution from my support, I can see you have not accepted any answer.If you are ok with this answer plz accept it. Then any user having same problem can identified it has solved the problem..

Jitendra Ku. Sahoo · Answer 4 · 2014-08-20T02:37:00

Solution 4

I think you may have multiple web.config files. So your needed file may be overridden by other.

Posted 20-Aug-14 2:37am

Jitendra Ku. Sahoo

Er. Rahul Nagar · Answer 5 · 2014-08-20T03:24:00

Solution 5

hi
you can use alternative solution for this type of problem. You also use appsetting-
just like that-:
System.Configuration.ConfigurationSettings.AppSettings["MySetting"]

Posted 20-Aug-14 3:24am

Er. Rahul Nagar

Not able to find Connection string from web.config

5 solutions

Solution 3

Solution 1

Solution 2

Solution 4

Solution 5

Add your solution here

Preview 0

Existing Members

...or Join us