sql connection is making exception in asp.net

Question

I have this code

SqlConnection sqlConnection = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["TestStoredProcedure"].ConnectionString);

This is my web.config

<add name="=TestStoredProcedure" connectionString="Data Source=.;Initial     Catalog=testSqlServer;Integrated Security=True"/>

I got this exception:

Object reference not set to an instance of an object.

on the connection string line.

Bob Horn · Accepted Answer · 2014-03-30 14:54:57Z

4

You're referencing ConnectionString on something that doesn't exist:

ConnectionStrings["TestStoredProcedure"].ConnectionString

Your config file has =TestStoredProcedure as the name. That doesn't match your code. Remove the =.

answered Mar 30, 2014 at 14:54

Bob Horn

34.5k36 gold badges122 silver badges238 bronze badges

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

Comments

RGS · Accepted Answer · 2014-03-30 14:55:24Z

0

Include following namespace line in your header of the page.

using System.Configuration;

 SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["TestStoredProcedure"].ConnectionString);

Web.Confiq:

<connectionStrings>
    <add name="TestStoredProcedure" connectionString="Data Source=.;Initial     Catalog=testSqlServer;Integrated Security=True"/>
    </connectionStrings>

Also remove '=' from the name of the connection string.

answered Mar 30, 2014 at 14:55

RGS

5,2217 gold badges44 silver badges69 bronze badges

Collectives™ on Stack Overflow

sql connection is making exception in asp.net

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