private void SetComboBoxes() { try { NpgsqlDataReader dataReader = PgSql.SelectFrom("name", "nationality"); while (dataReader.Read()) { cbNationality.Items.Add(dataReader[0].ToString()); } dataReader = PgSql.SelectFrom("color", "Eyecolor"); while (dataReader.Read()) { cbEyeColor.Items.Add(dataReader[0].ToString()); } dataReader = PgSql.SelectFrom("color", "Haircolor"); while (dataReader.Read()) { cbHairColor.Items.Add(dataReader[0].ToString()); } foreach (Control c in pnlControls.Controls) { if (c.GetType().Equals(cbEyeColor.GetType())) { ((ComboBox)(c)).SelectedIndex = 0; } } } catch (Exception ex) { MessageBox.Show(ex.Message); this.Close(); } }
private void SetComboBoxes() { try { NpgsqlDataReader dataReader = PgSql.SelectFrom("name", "placetype"); cbPlaceTheme.Items.Clear(); cbPlaceType.Items.Clear(); while (dataReader.Read()) { String s = dataReader[0].ToString(); cbPlaceType.Items.Add(s); //MessageBox.Show(dataReader[0].ToString()); } dataReader.Close(); dataReader = PgSql.SelectFrom("name", "placetheme"); while (dataReader.Read()) { this.cbPlaceTheme.Items.Add(dataReader[0].ToString()); //MessageBox.Show(dataReader[0].ToString()); } dataReader.Close(); foreach (Control c in this.Controls.OfType <ComboBox>()) { ((ComboBox)(c)).SelectedIndex = 0; } } catch (Exception ex) { MessageBox.Show(ex.Message); this.Close(); } }
private void SetComboBoxes() { try { NpgsqlDataReader dataReader = PgSql.SelectFrom("name", "nationality"); while (dataReader.Read()) { cbNationality.Items.Add(dataReader[0].ToString()); } dataReader.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); this.DialogResult = DialogResult.Cancel; this.Close(); } }
private void SetComboBoxes() { try { NpgsqlDataReader dataReader = PgSql.SelectFrom("name", "WorkPosition"); while (dataReader.Read()) { cbPosition.Items.Add(dataReader[0].ToString()); } dataReader.Close(); cbPosition.SelectedIndex = 0; } catch (Exception ex) { MessageBox.Show(ex.Message); this.Close(); } }
private void ShowAllUsers() { y = 10; ClearUserButtons(); try { PgSql.ConnectToUsersDB(role, role_pass); NpgsqlDataReader dataReader = PgSql.SelectFrom("login,role", "users"); while (dataReader.Read()) { CreateUsersButtons(dataReader[0].ToString(), dataReader[1].ToString()); } dataReader.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); lblNoUsers.Visible = true; btnRegistrate.Enabled = false; } }