'----------------------数据访问类
public class ClsDbo
{
//---数据库连接
public static SqlConnection CreateConn()
{
string ConnString = System.Configuration.ConfigurationManager.AppSettings["ConnStringText"].ToString();// 连接字符串
SqlConnection DbCon = new SqlConnection(ConnString);// 创建SqlConnection对象
return DbCon;
}
//************************************************************得到一个列表
public static SqlDataReader GetList(string Sql)
{ SqlConnection Conn = CreateConn();
Conn.Open();
SqlCommand Cmd = new SqlCommand(Sql, Conn);
Cmd.CommandTimeout = 300;
SqlDataReader result = Cmd.ExecuteReader(CommandBehavior.CloseConnection);
return result;
}
}
//===============================页面访问
private string GetOfTable(string InSql)
{
string OfTemp = "";
SqlDataReader oSdr = ClsDbo.GetList(InSql);
while (oSdr.Read())
{
......省略
}
oSdr.Close(); //这个地方关闭了 数据库连接应该就关闭了!
oSdr.Dispose();
return OfTemp;
}
//=============================
public class ClsDbo
{
//---数据库连接
public static SqlConnection CreateConn()
{
string ConnString = System.Configuration.ConfigurationManager.AppSettings["ConnStringText"].ToString();// 连接字符串
SqlConnection DbCon = new SqlConnection(ConnString);// 创建SqlConnection对象
return DbCon;
}
//************************************************************得到一个列表
public static SqlDataReader GetList(string Sql)
{ SqlConnection Conn = CreateConn();
Conn.Open();
SqlCommand Cmd = new SqlCommand(Sql, Conn);
Cmd.CommandTimeout = 300;
SqlDataReader result = Cmd.ExecuteReader(CommandBehavior.CloseConnection);
return result;
}
}
//===============================页面访问
private string GetOfTable(string InSql)
{
string OfTemp = "";
SqlDataReader oSdr = ClsDbo.GetList(InSql);
while (oSdr.Read())
{
......省略
}
oSdr.Close(); //这个地方关闭了 数据库连接应该就关闭了!
oSdr.Dispose();
return OfTemp;
}
//=============================
{
conn.Open();
......
conn.Close();
}//页面调用:
private string XXX()
{
DataTableReader reader=dbo.GetTable(sql).CreateDataTableReader();
......
}