不能循环更新符合条件的纪录
「已注销」 2005-09-29 03:08:55 不能循环更新符合条件的纪录
SqlCommand myCommand = new SqlCommand("SELECT UserID FROM [myMember] WHERE UserAge > 22", myConnection);
myCommand.Connection.Open();
SqlDataReader dr = myCommand.ExecuteReader();
while (dr.Read())
{
strUserID = dr["UserID"].ToString();
//出错
myCommand.CommandText = "UPDATE [myMember] SET UserScore = 0 WHERE UserID = '"+strUserID+"'", myConnection);
myCommand.ExecuteNonQuery();
}
dr.Close();
myCommand.Connection.Close();
分数不够了,只能给这点了。