void UpdateUsers() { if (!QSMain.TestConnection()) { return; } QSMain.CheckConnectionAlive(); logger.Info("Получаем таблицу пользователей..."); string sql = "SELECT * FROM users "; if (!chkShowInactive.Active) { sql += " WHERE deactivated = 0"; } MySqlCommand cmd = new MySqlCommand(sql, QSMain.connectionDB); MySqlDataReader rdr = cmd.ExecuteReader(); UsersListStore.Clear(); while (rdr.Read()) { bool deactivated = false; try { deactivated = DBWorks.GetBoolean(rdr, "deactivated", false); } catch { logger.Warn("В базе отсутствует поле deactivated!"); } UsersListStore.AppendValues(int.Parse(rdr ["id"].ToString()), rdr ["login"].ToString(), rdr ["name"].ToString(), (bool)rdr ["admin"], deactivated, deactivated ? "grey" : "black"); } rdr.Close(); logger.Info("Ok"); OnTreeviewUsersCursorChanged(null, null); }