: System.InvalidOperationException: 已有打开的与此连接相关联的 DataReader,必须首先将它关闭。
qxkls 2008-12-12 10:35:44 sqlConn = new SqlConnection(BP.DataAccess.Constants.ConnectString); string sql = "select count(name)as c,name from get_movie where datediff(dd,datet,getdate()) <7 and serialno = '"+name+"' group by name";
string sql1 = "insert into get_movie values('"+name+"','"+this.TextBox1.Text+"','"+DateTime.Now.ToString()+"','"+url+"','"+0+"','"+des+"')";
string sql2 = "select counts from hardinfo where serianlo = '"+name+"'";
cmd = new SqlCommand(sql,sqlConn);
cmd1 = new SqlCommand(sql1,sqlConn);
cmd2 = new SqlCommand(sql2,sqlConn);
SqlDataReader read = null;
SqlDataReader read2 = null;
sqlConn.Open();
read = cmd.ExecuteReader();
read2 = cmd2.ExecuteReader();
while(read.Read() && read2.Read())
{
int count = Convert.ToInt32(Convert.ToString(read.GetValue(0)));
int hard_info_count = Convert.ToInt32(read2.GetValue(0));
string names = Convert.ToString(read.GetValue(1));
if(count>hard_info_count)
{
Response.Write("<script>alert('请求失败,一周之内只能请求'"+hard_info_count+"'部影片!')</script>");
p =true;
return;
}
if(names == this.TextBox1.Text)
{
Response.Write("<script>alert('您已请求过此影片,请不要重复求片!')</script>");
p =true;
return;
}
}
sqlConn.Close();
if(p == false)
{
sqlConn.Open();
cmd1.ExecuteNonQuery();
sqlConn.Close();
Response.Write("<script>alert('影片信息已发出请等候!')</script>");
}
--------------
行 73: sqlConn.Open();
行 74: read = cmd.ExecuteReader();
行 75: read2 = cmd2.ExecuteReader();
行 76: while(read.Read() && read2.Read())
行 77: {