代码事例:c#
就是想请问一下,这样写好么,好像SqlConnection对象没有关闭
private SqlConnection conn;
public static SqlConnection Conn
{
get
{
string connectionString =
"server=.\\sqlexpress;uid=sa;pwd=sa;database=pubs";
if(conn == null)
{
Sqlconnection conn = new SqlConnection(connectionString);
conn.open();
}
else if(conn.state == ConnectionState.close)
{
conn.open();
}
else if(conn.state == ConnectionState.brook)//brook单词可能打错了
{
conn.close();
conn.open();
}
return conn;
}
}//调用的事例
public bool loginUser()
{
SqlCommand cmd = new SqlCommand("sql语句",Conn);//Conn就是调用get访问 器
cmd.exec();//单词记不住了
}
就是想请问一下,这样写好么,好像SqlConnection对象没有关闭
private SqlConnection conn;
public static SqlConnection Conn
{
get
{
string connectionString =
"server=.\\sqlexpress;uid=sa;pwd=sa;database=pubs";
if(conn == null)
{
Sqlconnection conn = new SqlConnection(connectionString);
conn.open();
}
else if(conn.state == ConnectionState.close)
{
conn.open();
}
else if(conn.state == ConnectionState.brook)//brook单词可能打错了
{
conn.close();
conn.open();
}
return conn;
}
}//调用的事例
public bool loginUser()
{
SqlCommand cmd = new SqlCommand("sql语句",Conn);//Conn就是调用get访问 器
cmd.exec();//单词记不住了
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货