别忘了close
class WinClass
{
private SqlCommand myCmd;
public WinClass()
{
myCmd = new SqlCommand();
myCmd.CommandText = "select xm,xb,id from tbl ";
myCmd.Connection = sqlConnection1;
} private void SetInfo(string strId) //--1
{
myCmd.CommandText = "select xm from tbl where id = @id";
myCmd.Parameters.Add("@id",strId);
myCmd.Connection.Open();
SqlDataReader dr = myCmd.ExecuteReader(); //--2
...
dr.Close(); //这里是关键
}}
class WinClass
{
private SqlCommand myCmd;
public WinClass()
{
myCmd = new SqlCommand();
myCmd.CommandText = "select xm,xb,id from tbl ";
myCmd.Connection = sqlConnection1;
} private void SetInfo(string strId) //--1
{
myCmd.CommandText = "select xm from tbl where id = @id";
myCmd.Parameters.Add("@id",strId);
myCmd.Connection.Open();
SqlDataReader dr = myCmd.ExecuteReader(); //--2
...
dr.Close(); //这里是关键
}}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货