Object reference not set to an instance of an object

Question

0.00/5 (No votes)

See more:

App.Config

XML

<configuration>
  <connectionStrings>
    <add name="connString" 
     connectionString="metadata=res://*/Model1.csdl|res://*/Model1.ssdl|res://*/Model1.msl;provider=System.Data.SqlClient;provider connection string="data source=.\SQLEXPRESS;attachdbfilename=|DataDirectory|\databasename.mdf;integrated security=True;connect timeout=30;user instance=True;multipleactiveresultsets=True;App=EntityFramework"" providerName="System.Data.EntityClient" />
  </connectionStrings>

Class.cs file

C#

string conString = ConfigurationManager.ConnectionStrings["connString"].ConnectionString;

Now why am I Geting this error:"Object reference not set to an instance of an object". in my ConfigurationManager line?

Posted 18-Aug-12 11:21am

Anele Ngqandu

Add a Solution

Comments

Kenneth Haugland 18-Aug-12 18:20pm

Forgot a new block in your code?

2 solutions

Add a Solution

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

_Amy · Answer 1 · 2012-08-18T17:52:00

This exception will obviously come when you'll try to point an object which is null.
Try this:

HTML

<connectionstrings>
    <add name="ConnStringDb1" connectionstring="Data Source=localhost;Initial Catalog=YourDataBaseName;Integrated Security=True;" providername="System.Data.SqlClient" />
</connectionstrings>

To read the connection string into your code, use the ConfigurationSettings class.

C#

if(ConfigurationManager.ConnectionStrings["myConnectionString"] != null){
    string connStr = ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString;
}

--Amit

Kuthuparakkal · Answer 2 · 2012-08-18T17:06:00

Solution 1

C#

string conString = ConfigurationManager.ConnectionStrings["connString"].ToString();

is sufficient. Plz try...

Posted 18-Aug-12 17:06pm

Kuthuparakkal

Updated 18-Aug-12 22:37pm

v2

Object reference not set to an instance of an object

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Object reference not set to an instance of an object

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us