在web.config文件中的<appSettings>節點下，添加如下內容：
<add key="ConnKey" value="Data Source=KO\MSSQLSERVER005;Initial Catalog=Web; User Id=sa;Password=sa;" />
下面是數據庫連接文件，先定義公共變量SqlConn和ConnKeyStr ，請注意引號內“ConnKey”與web.config設定值需一致。
public SqlConnection SqlConn;
public static string ConnKeyStr = ConfigurationManager.AppSettings["ConnKey"].ToString();

下面兩個函數，一個是打開數據連接，另一個是關閉數據連接。
//打開連接
public void SqlConnOpen()
{
if (SqlConn == null)
{
SqlConn = new SqlConnection(ConnKeyStr);
if (SqlConn.State != ConnectionState.Open)
{
try
{
SqlConn.Open();
}
catch
{
throw new Exception("打開數據庫失??！");
}
}
}
else if(SqlConn.State!=ConnectionState.Open)
{
try
{
SqlConn.Open();
}
catch
{
throw new Exception("打開數據庫失??！");
}
}
}

//關閉連接
public void SqlConnClose()
{
if (SqlConn.State != ConnectionState.Closed)
{
SqlConn.Close();
}
}

using System.Data.SqlClient;

SqlConnection cn = new SqlConnection("data source=(local);initial catalog=database_breakfast;user=sa;pwd=");
SqlCommand cmd = new SqlCommand(" select * from t_product_sort ", cn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds, "prosort");
this.GridView1.DataSource = ds.Tables[0].DefaultView;
this.DataBind();