C# mySQL There is already an open DataReader

[liu_dashi]

异常提示：There is already an open DataReader associated with this Connection which must be closed first
using (MySqlConnection mySqlconnection = new MySqlConnection(mySqlconnectionString))
{
MySqlCommand mySqlcmd = new MySqlCommand(SQLString,mySqlconnection);
using (MySqlDataAdapter mySqlda = new MySqlDataAdapter(mySqlcmd))
{
DataSet ds = new DataSet();
try
{
mySqlda.Fill(ds);
mySqlcmd.Parameters.Clear();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return ds;
}
}

[liu_dashi]

一天了 咋没人回应尼

[木子木啊]

你这个DataReader 在别的地方开了一个， 没有关闭、、、

[zhujiazhi]

检查使用datareader的地方，用完之后要记得 reader.Close(); reader.Dispose();

[liu_dashi]

找到原因了 原来是查询语句where条件中的条件不符导致！

[liu_dashi]

与datereader 一毛钱关系没有啊