public static int[] getAllMemberId(Room room)
{
int[] uid = new int[room.CurrentNum];
string sql = "SELECT * FROM room_member WHERE rid = " + room.Rid;
MySqlCommand command = new MySqlCommand(sql, connection);
MySqlDataReader sqlDataReader = command.ExecuteReader();
for (int i = 0; sqlDataReader.Read(); i++)
{
uid[i] = sqlDataReader.GetInt32("uid");
}
sqlDataReader.Close(); //这行代码一定要写,否则connection无法关闭报错
return uid;
}
C# There is already an open DataReader associated with this Connection which must be closed first.
于 2021-12-26 03:25:56 首次发布