SqlDataReader 出现问题

2025-04-14 19:53:50
推荐回答(3个)
回答1:

ArrayList userids = new ArrayList();
while(MyReader.Read())
userids.add(MyReader.GetInt32(0));
MyReader.Close();
for(int i = 0;i < userid.Count; i++)
{
int userid = userids[i];
string sqlQueryUser = "select userid,username,truename,unitname,telnumber,email from res_user where userid='" + userid + " '";
comm = new SqlCommand(sqlQueryUser, conn);
SqlDataAdapter da = new SqlDataAdapter(comm);
da.Fill(dset,"maintainusers");
}

回答2:

把MyReader.Close();
放到da.Fill(dset,"maintainusers"); 后面啦..!!

回答3:

comm = new SqlCommand(sqlQueryUser, conn);
SqlDataAdapter da = new SqlDataAdapter(comm);
da.Fill(dset,"maintainusers");

调用da.Fill的时候会conn.open()此时因为之前已经打开了,所以报错!