C#连接未关闭

显示全部楼层 · 2008-11-30 13:22:47

private void MainForm_Load(object sender, EventArgs e)

{

string sqlstr = "";

SqlCommand cmd;

SqlDataReader dr;

try

{

this.Text = UserHelper.LoginId.ToString();

sqlstr = string.Format("select faceid,nickname from users where id = {0}", UserHelper.LoginId);

DBHelper.conn.Open();

cmd = new SqlCommand(sqlstr, DBHelper.conn);

dr = cmd.ExecuteReader();

dr.Read();

int faceid = Convert.ToInt32(dr[0]);

this.picFace.Image = this.imageList1.Images[faceid];

this.lblInfo.Text = dr[1].ToString() + "(" + UserHelper.LoginId + ")";

dr.Close();

}

catch (Exception ex)

{

Console.WriteLine(ex.Message);

}

finally

{

DBHelper.conn.Close();

}
请高手们看看到底是哪里出现的错误，老是报“连接未关闭，当前连接状态为已打开！” 谢谢了

千问 · 2008-11-30 13:22:47

在DBHelper类中你创建的conn实例，在创建实例时把创建实例的语句放在using里这样写 using( SqlConnection conn = 方法名（连接数据库字符串）)using 是负责关闭连接的...

千问 · 2008-11-30 13:22:47

你这里的程序没有问题，看看你其他的地方是不是将数据库打开了?...