Unable to connect to SQL Server Database (ASP.NET C#)

Question

When I attempt to establish a connection in ASP.NET (C#) to a SQL server database I get the following error:

The ConnectionString property has not been initialized.

Web.config

<connectionStrings>
   <add name="ConnectionString" 
        connectionString="Data Source=SERVER\SQLEXPRESS;Initial Catalog=FIRE;Integrated Security=SSPI;User ID=firedba;Password=firedba;"/>

C# Code

SqlConnection myConnection = new SqlConnection();
System.Configuration.Configuration rootWebConfig = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration(Request.ApplicationPath);
System.Configuration.ConnectionStringSettings connString;

if (rootWebConfig.ConnectionStrings.ConnectionStrings.Count > 0)
{
        connString = rootWebConfig.ConnectionStrings.ConnectionStrings["ConnectionString"];

        if (connString != null)
            myConnection.Open();
}

I am running the database in SQL Server (locally). The test application is in Visual Studio 2008.

Please can you help me?

estebane97 · Accepted Answer · 2013-07-07 22:06:53Z

2

You need to set the ConnectionString in your SqlConnection Object.

Use :

if (connString != null){
        myConnection.ConnectionString=connString;
        myConnection.Open();
}

Or just create the SqlConnection object after get the Connection String:

            SqlConnection myConnection = new SqlConnection(connString);
            myConnection.Open();

answered Jul 7, 2013 at 22:06

estebane97

1,1482 gold badges7 silver badges25 bronze badges

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

Comments

Steve · Accepted Answer · 2013-07-07 23:06:21Z

1

You should inform the SqlConnection object which is the connection string to use when you try to open the link to the database

System.Configuration.Configuration rootWebConfig = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration(Request.ApplicationPath);
System.Configuration.ConnectionStringSettings connString;
if (rootWebConfig.ConnectionStrings.ConnectionStrings.Count > 0)
{
    connString = rootWebConfig.ConnectionStrings.ConnectionStrings["ConnectionString"];

    if (connString != null)
    {
        // Create the connection, open, use and destroy releasing the resources used
        using(SqlConnection myConnection = new SqlConnection(connString))
        {
             myConnection.Open();

             .... other database code here
        } 

   }
}

edited Jul 7, 2013 at 23:06

answered Jul 7, 2013 at 22:07

Steve

217k22 gold badges242 silver badges296 bronze badges

Collectives™ on Stack Overflow

Unable to connect to SQL Server Database (ASP.NET C#)

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