How can I put my connectionString from the Web.Config file into my SqlConnection();

[bencoding]

Wow, I've spent about 3 hrs now trying to figure this one out, none of the articles online were able to help me and some were using system libraries that were obsolete......anyways,

I am able to read my connection string from my web.config file withing a Response.Write(); but when I put it in my SqlConnection([here]) it won't display, I don't get why

Can someone PLEASE I'm begging for a simple solution for this, please help!


This works fine:

        string connectionInfo = ConfigurationManager.AppSettings["connectionString"];
        Response.Write(connectionInfo);

But when I put it in my SqlConnection it won't load :(

        SqlConnection myConn = new SqlConnection(connectionInfo );

[Curtis Rutland]

What do you mean, won't display? It's not supposed to display anything.

First of all, you're either putting it in the wrong place, or loading it wrong.
You should put it in the "ConnectionStrings" section:

<configuration>
  <connectionStrings>
    <add name="connStringName" connectionString="Data Source=datasource;Initial Catalog=db;Persist Security Info=True;User ID=sa;Password=yeahRight" providerName="System.Data.SqlClient" />
  </connectionStrings>
  .....
  .....
  .....
</configuration>
 

And retrieve the value like this:

string connStr = ConfigurationManager.ConnectionStrings["connStringName"].ConnectionString;
SqlConnection conn = new SqlConnection(connStr);
 

[bencoding]

yes I understand, I did put it there, I have tried this and I get "InvalidOperationException was unhandled by user code" and it points to:

conn.Open();

Using this code:

   <connectionStrings>
    <add name="DatabaseConnectionString" connectionString="Data Source=[myDB];Integrated Security=True"
     providerName="System.Data.SqlClient" />
  </connectionStrings>

    string connStr = ConfigurationManager.ConnectionStrings["connStringName"].ConnectionString;
    SqlConnection myConn = new SqlConnection(connStr);

...this was what I was getting before, still not working.

[Curtis Rutland]

Ok, do this:

try
{
     conn.Open();
}
catch (Exception ex)
{
     Response.Write("Exception! :: " + ex.Message);
      Response.End();
}
 

And let us know what the message is.

yes I understand, I did put it there, I have tried this and I get "InvalidOperationException was unhandled by user code" and it points to:

conn.Open();

Using this code:

   <connectionStrings>
    <add name="DatabaseConnectionString" connectionString="Data Source=[myDB];Integrated Security=True"
     providerName="System.Data.SqlClient" />
  </connectionStrings>

    string connStr = ConfigurationManager.ConnectionStrings["connStringName"].ConnectionString;
    SqlConnection myConn = new SqlConnection(connStr);

...this was what I was getting before, still not working.