这是怎么回事?!

[inshine]

为什么数据已经INSERT到数据库了,但是还是报错:已有打开的与此连接相关联的 DataReader，必须首先将它关闭。
我也检查过了,DataReader都已经关闭了,并且在INSERT之前也没有打开过DataReader.

[sjzwinfor]

仔细查一下吧，没有代码无从知道

[coffeewar]

代码贴出来.
可能重复插入数据了.

[cyy1981]

说具体点嘛

[inshine]

代码如下:
private void btnSave_Click(object sender, System.EventArgs e)
{
if(Page.IsValid)
{
//INSERT SQL语句
strSQL = "INSERT INTO userinfo(u_name,u_account,u_pwd,u_sex,u_bth,u_regdate,u_tel1,u_tel2,u_tel3,u_addr,u_zip,u_email,u_job,u_qq,u_grp)";
strSQL += " VALUES('";
strSQL += txtName.Text.ToString() + "','";
strSQL += txtUser.Text.ToString() + "','";
strSQL += txtPwd.Text.ToString() + "','";
strSQL += rltSex.SelectedItem.Text.ToString() + "','";
strSQL += ddlYear.SelectedItem.Text.ToString() + "-" +
ddlMonth.SelectedItem.Text.ToString() + "-" +
ddlDay.SelectedItem.Text.ToString() + "','";
strSQL += DateTime.Now.ToString() + "','";
strSQL += txtComCall.Text.ToString() + "','";
strSQL += txtComCall.Text.ToString() + "','";
strSQL += txtCellCall.Text.ToString() + "','";
strSQL += txtAddress.Text.ToString() + "','";
strSQL += txtZIP.Text.ToString() + "','";
strSQL += txtEmail.Text.ToString() + "','";
strSQL += txtCompany.Text.ToString() + "','";
strSQL += txtQQ.Text.ToString() + "',1)";

//数据库相关定义
strConn = "server=localhost;database=txl;uid=sa;pwd=sa";
cn = new SqlConnection(strConn);
cmd = new SqlCommand(strSQL,cn);
cn.Open();
cmd.ExecuteReader();

//SQL语句
strSQL = "SELECT u_id FROM userinfo WHERE u_account='"+txtUser.Text.ToString()+"'";
cmd = new SqlCommand(strSQL,cn);
dr = cmd.ExecuteReader();

//读数据
while(dr.Read())
{
//赋值SESSION
Session["uid"] = dr["u_id"];
}

//关闭
dr.Close();
cn.Close();

//页面转向
Page.Response.Redirect("Welcome.aspx");
}
}

[lxcc]

但是还是报错

//啥错误？

[lxcc]

INSERT操作用

cmd.ExecuteNonQuery();

[coffeewar]

cmd.ExecuteReader();
dr = cmd.ExecuteReader();
已有打开的与此连接相关联的 DataReader，必须首先将它关闭。]
很显明的错误.

[morality]

INSERT操作用

cmd.ExecuteNonQuery();

改一下再试试

[vzxq]

加上try catch finally

[hebookboy]

使用cmd.ExecuteNonQuery();