private void MARCA1() { conexion_marca con = new conexion_marca(); con.Modelo.Open(); txt_Marca.DataSource = null; txt_Marca.Items.Clear(); string SELECT = "SELECT * FROM marca ;"; try { MySqlCommand select1 = new MySqlCommand(SELECT, con.Modelo); MySqlDataAdapter reader11 = new MySqlDataAdapter(select1); DataTable tabla11 = new DataTable(); DataRow fila = tabla11.NewRow(); reader11.Fill(tabla11); fila["MARCA"] = "Selecione la marca"; tabla11.Rows.InsertAt(fila, 0); txt_Marca.ValueMember = "id"; txt_Marca.DisplayMember = "marca"; txt_Marca.DataSource = tabla11; } catch (Exception ex) { MessageBox.Show("Exite un error de tipo: " + ex); } con.Modelo.Close(); }
private void Modelo(string iD_MARCA) { conexion_marca con = new conexion_marca(); con.Modelo.Open(); string select = "select*from modelo where id_marca='" + iD_MARCA + "';"; txt_Modelo.DataSource = null; txt_Modelo.Items.Clear(); try { MySqlCommand select_mod = new MySqlCommand(select, con.Modelo); MySqlDataAdapter reader_mod = new MySqlDataAdapter(select_mod); DataTable tabla_mod = new DataTable(); DataRow fila = tabla_mod.NewRow(); reader_mod.Fill(tabla_mod); fila["Modelo"] = "Selecione el modelo"; tabla_mod.Rows.InsertAt(fila, 0); txt_Modelo.ValueMember = "id"; txt_Modelo.DisplayMember = "modelo"; txt_Modelo.DataSource = tabla_mod; } catch (MySqlException ex) { MessageBox.Show("ocuurrio algo"); MessageBox.Show("" + ex); } con.Modelo.Close(); }