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();
}
