private string strConn = "data source=localhost;initial catalog=Northwind;user id=sa;password=sa";
SqlConnection Conn;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//调用LoadGridView方法以填充和显示数据
LoadGridView();
}
}
private void ConnectionDB()
{
if (Conn == null)
{
//如果SqlConnection对象不存在新建该对象
Conn = new SqlConnection(strConn);
}
if (Conn.State == ConnectionState.Closed)
{
//如果Connection对象的State状态为关闭Closed就将其打开
Conn.Open();
}
}
SqlConnection Conn;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//调用LoadGridView方法以填充和显示数据
LoadGridView();
}
}
private void ConnectionDB()
{
if (Conn == null)
{
//如果SqlConnection对象不存在新建该对象
Conn = new SqlConnection(strConn);
}
if (Conn.State == ConnectionState.Closed)
{
//如果Connection对象的State状态为关闭Closed就将其打开
Conn.Open();
}
}