ASP.net declaring a SQL connection across multiple pages/ascx files

Almost always the dll's but i have 2 projects at the moment im uploading the code behinds instead. Once those projects are more completed and require less updating ill start uploading the dll's.

I have my own dedicated server so i don't mind uploading the code behinds.

 

as in, in your office?

 

It's in Canada? I have 2 Dedicated Servers if you want to include my work one.

 

bringing this one back from the dead, I'm trying to do what was advised but can't work it out:

Web.config:

PHP:

    <connectionStrings>
    <add name="Infobase" connectionString="Server=SERVER;Database=infobase;User ID=name;Password=pw" providerName="System.Data.SqlClient" />
    </connectionStrings>


App_Code/ibcon.cs

PHP:

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;


/// <summary>
/// SQL Query
/// </summary>
public class ibcon
{
    public ibcon() { }
        public static SqlConnection ReturnConnection() {

        string _connString = ConfigurationManager.AppSettings["Infobase"];
        SqlConnection _ibcon = new SqlConnection(_connString);

        return _ibcon;
    }
}


SQLTesdt.aspx.cs

PHP:

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class SQLtest : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        using (SqlConnection _ibcon = ibcon.ReturnConnection())
        {

            try
            {

                _ibcon.Open();

 SqlCommand InfobaseCommand = new SqlCommand("SELECT * FROM Staff Where CurrentEmploy = 1", _ibcon);
 SqlDataReader ResultsReader = InfobaseCommand.ExecuteReader();
 while (ResultsReader.Read())
 {

     String name = ResultsReader["FirstName"].ToString();

     Response.Write(name);

}
              
            }
            catch (Exception ex)
            {
                Response.Write("didnt work : " + ex);
            }

        }

    }
}


Throws this:

help?

 

When you put the connection string in the ConnectionStrings config section it isn't available from the AppSettings collection.

Have a look at Effekt26's earlier code or http://msdn2.microsoft.com/en-us/library/ms178411.aspx

Chris.

 

string _connString = ConfigurationManager.ConnectionStrings["Connection1"];

is what effekt suggested - that spits out an error, something about not being able to convert it to a string

I'll have a look at that website when I get home, cheers.

 

Yeah because what you get back from that isn't a string, it's a "ConnectionString" object that has a property on it that is the connection string as a string, but from memory you can use it directly as well.

I'm on my mac here which doesn't seem to like loading MSDN pages too quickly so I can't confirm it right now.

 

<appSettings>
<add key="Infobase" value="Server=SERVER;Database=infobase;User ID=name;Password=pw" providerName="System.Data.SqlClient" />
</appSettings>

 

That won't work because the appSettings element doesn't allow "providerName" attribute. But without that his previous appSettings code would work, but it's not really the standard since they added the ConfigurationStrings section.

 

Oh i didn't even see provider name.

But i would just have something like...

Code:

        public SqlConnection Connection()
        {
            _connection = new SqlConnection();

            _connection.ConnectionString = ConfigurationManager.AppSettings["Infobase"];
            _connection.Open();

            return _connection;
        }

<appSettings>
<add key="Infobase" value="server=ip;database=dbname;User id=user;Password=pw"/>
</appSettings>