PS:我已经忘记了n遍了
class DBHelper
{
//连接数据库
public static string connstring = @"Data Source=DESKTOP-8HPQ7CU;Initial Catalog=ChaoShiGuanLi;Integrated Security=True";
public static SqlConnection conn = null;
//初始化数据库
public static void lnitconnection()
{
if (conn==null)
{
//对象不存在创建连接
conn = new SqlConnection(connstring);
}
if (conn.State==ConnectionState.Closed)
{
//对象关闭打开连接
conn.Open();
}
if (conn.State==ConnectionState.Broken)
{
//对象中断重新连接
conn.Close();
conn.Open();
}
}
//查询获取datareader
public static SqlDataReader GetdataReader(string sqlstr)
{
lnitconnection();
SqlComm