private void Eliminar_Load(object sender, EventArgs e) { DataGridEliminarP.DataSource = TU.VerPlacas(); try { CBEliminar.DropDownStyle = ComboBoxStyle.DropDownList; CBEliminar.Items.Clear(); conectar1.conectar(); conectar1.abrirConexion(); MySqlCommand comando = new MySqlCommand("SELECT placa FROM carro", conectar1.getconexion()); MySqlDataReader lector = comando.ExecuteReader(); while (lector.Read()) { CBEliminar.Refresh(); CBEliminar.Items.Add(lector.GetValue(0).ToString()); } conectar1.cerrarConexion(); } catch (MySqlException f) { MessageBox.Show(f.Message); } }
public EliminarAd() { InitializeComponent(); DataGridEliminarP.DataSource = u.MostrarAdm(); try { CBEliminar.DropDownStyle = ComboBoxStyle.DropDownList; CBEliminar.Items.Clear(); conectar1.conectar(); conectar1.abrirConexion(); MySqlCommand comando = new MySqlCommand("SELECT usuario FROM encargado", conectar1.getconexion()); MySqlDataReader lector = comando.ExecuteReader(); while (lector.Read()) { CBEliminar.Refresh(); CBEliminar.Items.Add(lector.GetValue(0).ToString()); } conectar1.cerrarConexion(); } catch (MySqlException r) { MessageBox.Show(r.Message); } }