Server Error in '/' Application. Object reference not set to an instance of an object.

Question

2.59/5 (3 votes)

See more:

My application is not able to pick connection string from web.config file.

Quote:
Server Error in '/' Application.

Object reference not set to an instance of an object.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.

XML

<connectionStrings>
      <add name="myConnectionString" connectionString="server=XYZ;database=nDatabase;uid=sa;password=sa1234;" />
  </connectionStrings>

Please help

Posted 9-May-14 21:12pm

praveen_07

Updated 29-May-22 0:00am

v3

Add a Solution

Comments

[no name] 10-May-14 3:16am

show your code where it is throwing error

[no name] 10-May-14 3:22am

Hi Sankarsan,

I would be pleased if you can please help me in resolving this issue.

Code : dbManager.ConnectionString = ConfigurationManager.ConnectionStrings["myConnectionString"].ToString();

If I hard code my connection String in DataaccessLayer its working fine, but if I try to pick connection string from web.config file its throwing the above exception

Regards,
Praveen N

[no name] 10-May-14 3:25am

You are missing ConnectionString after ConnectionString"myConnectionString"] keyword

Vibhui Thakur 13-Jun-23 6:24am

Open ku nhi ho rhi h I'd

[no name] 18-Sep-22 13:08pm

Air full haque

[no name] 18-Sep-22 13:09pm

Airfare begam

Vibhui Thakur 13-Jun-23 15:36pm

Y eror ku AA rha h

Limbani Nidhish 29-Jun-23 10:53am

Gssy risult

4 solutions

Solution 4

In Web.Config

C#

<connectionstrings>
         <add name="MyConnectionString" connectionstring="Data Source=MyPc-PC;Initial Catalog=MyDb;Persist Security Info=True;User ID=sa;Password=12345" providername="System.Data.SqlClient" />
</connectionstrings>

And you can access using

C#

string constr = WebConfigurationManager.ConnectionStrings["webshopConnectionString"].ConnectionString;

Posted 9-May-14 22:48pm

Vi(ky

Updated 9-May-14 23:07pm

v2

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)

DamithSL · Accepted Answer · 2014-05-09T22:02:00

For web site or web application default configuration file is web.config file. When you call ConfigurationManager.ConnectionStrings it will get the connection strings from your default configuration file, that means web.config. if you haven't define myConnectionString in web.config, add it and check your site.

sankarsan parida · Accepted Answer · 2014-05-09T21:23:00

Solution 1

Put your connection string

dbManager.ConnectionString = ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString.ToString();

Posted 9-May-14 21:23pm

sankarsan parida

Comments

[no name] 10-May-14 3:25am

No Still the same exception exists :(

[no name] 10-May-14 3:27am

show your web.config connection string

[no name] 10-May-14 3:27am

Server Error in '/' Application.

Object reference not set to an instance of an object.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.

Source Error:

Line 16: {
Line 17: IDBManager dbManager = new DBManager(DataProvider.SqlServer);
Line 18: dbManager.ConnectionString = ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString.ToString();

[no name] 10-May-14 3:29am

no!, What have you written in web.config file for connectionstring

[no name] 10-May-14 3:34am

When I try to debug the compiler is not looking into web.config of DAL layer its straight a way jumping to UI layer web.config bit surprising .

praveen_07 · Accepted Answer · 2014-05-09T23:32:00

Solution 5

Got to know web.config file present in application file or presentation layer overrides the web.config file present in DAL layer.

Hence resolved

Special thanks to DamithSL :)

Thanks all for your help :)

Regards,
Praveen N

Posted 9-May-14 23:32pm

praveen_07

Comments

[no name] 18-Sep-22 12:57pm

Air full haque

Server Error in '/' Application. Object reference not set to an instance of an object.

4 solutions

Solution 3

Solution 1

Solution 4

Solution 5

Add your solution here

Preview 0

Existing Members

...or Join us