SqlDataReader dr1 = cmd1.ExecuteReader()问题
string sql = string.Format("select FromUserId from Messages where ToUserId={0} and MessageTypeId=2 and MessageState=0 group by FromUserId", UserHelper.loginId);
SqlCommand cmd = new SqlCommand(sql, DBHelper.connection);
DBHelper.connection.Open();
SqlDataReader dr = cmd.ExecuteReader();
for (int i = 0; i < 200; i++)
{
while (dr.Read())
{
FromUserIDArray[i] = (int)dr["FromUserId"];
待高手插入的地方!
toolStripButton3.Image = imageList1.Images[102];
}
}
dr.Close();
把这边的代码写到上面去!请高手请教怎么写~并把代码写好!谢谢! 问题是如果有2个 while(dr.read())的话!等到下一个读取的时候上一个就关闭了~救命呀!
for (int i = 0; i < 200; i++)
{
string sql1 = string.Format("select NickName,id,FaceId From Users where id={0}", FromUserIDArray[i]);
SqlCommand cmd1 = new SqlCommand(sql1, DBHelper.connection);
SqlDataReader dr1 = cmd1.ExecuteReader();
if (dr1.Read())
{
tranNickName = (string)dr1["NickName"];
tranId = (int)dr1["id"];
tranFaceId = (int)dr1["FaceId"];
} dr1.Close();
}
DBHelper.connection.Close();
我想把下面的SQL语句插入到上面的语句里面去怎么插~就是用以条SQL语句来插~就用一个SqlDataReader