Get Connection String from Method returning Connection error Object Refrence not Set to the instance of object ??? Asp.net

Question

i am trying to get connection string from method resulting error object reference not set to the instance object my method is,

this method return connection,

namespace InspectionServices.Services
{
    public class ConfigManager
    {
        public static string GetConnectionString()
        {
            return ConfigurationManager.ConnectionStrings["***"].ConnectionString;
        }
    }
}

and here i am getting connection by calling method mentioned above,

 string connectionString = InspectionServices.Services.ConfigManager.GetConnectionString();

hopes for your suggestion

Thanks in Advance

EDITED:

Appconfig,

 <connectionStrings> 
    <add name="Inspection" connectionString="Data Source=***;Database=***;Integrated Security=SSPI; Persist Security Info=false; Trusted_Connection=Yes;" providerName="System.Data.SqlClient"/>
  </connectionStrings>

Please also show us your web.config file! Do you have a <connectionStrings> section in there? Does the connection string you want to load even exist in that section?? — marc_s
– marc_s, Commented Apr 29, 2013 at 4:52

Community · Accepted Answer · 2017-05-23 11:57:19Z

1

You mush have web.config entries like this

<connectionStrings>
     <add name="name" connectionString="***" />
</connectionStrings>

Only then you can use it in your class.

Some useful links
C# Configuration Manager . ConnectionStrings
http://www.connectionstrings.com/Articles/Show/store-connection-string-in-web-config

edited May 23, 2017 at 11:57

CommunityBot

11 silver badge

answered Apr 29, 2013 at 4:53

शेखर

17.6k14 gold badges64 silver badges123 bronze badges

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

5 Comments

tester Joe Over a year ago

i am getting error on object refrence not set to instance of object on the methos from where i am returning connection string

शेखर Over a year ago

at which line is it in return ConfigurationManager.ConnectionStrings["***"].ConnectionString; line?

शेखर Over a year ago

are you putting *** or Inspection in the above line?

tester Joe Over a year ago

@ one thing i noticed that as i gave it index in place of name "inspection " it successfully get connection string then what would be the reason ???

शेखर Over a year ago

It is case sensitive so be careful. You might be using inspection in place of Inspection

Veer · Accepted Answer · 2013-04-29 05:54:15Z

1

namespace InspectionServices.Services
{
    public class ConfigManager
    {
        public static string GetConnectionString()
        {
            return ConfigurationManager.ConnectionStrings["Inspection"].ConnectionString;
        }
    }
}

answered Apr 29, 2013 at 5:54

Veer

1,6033 gold badges19 silver badges42 bronze badges

Collectives™ on Stack Overflow

Get Connection String from Method returning Connection error Object Refrence not Set to the instance of object ??? Asp.net

2 Answers 2

5 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related