conexion.Open();
MySqlCommand insertar2
= new MySqlCommand
("INSERT INTO proveedores (nom_proveedor, raz_soc_proveedor, rfc_proveedor, direcc_proveedor, tel_proveedor, horario_proveedor, codigo_proveedor,fecha_alta_proveedor) VALUES ('" + txt_nom
.Text + "','" + txt_rsocial
.Text + "','" + txt_rfc
.Text + "','" + txt_dir
.Text + "','" + txt_tel
.Text + "','" + txt_horario
.Text + "','" + txt_cod
.Text + "','" + fecha
+ "')", conexion
); insertar2.ExecuteNonQuery();
MySqlCommand seleccionar
= new MySqlCommand
("SELECT last_insert_id()",conexion
); MySqlDataReader lector = null;
lector = seleccionar.ExecuteReader();
lector.Read();
int id = lector.GetInt32(0);
lector.Close();
MySqlCommand insertar
= new MySqlCommand
("INSERT INTO contactos(nom_contacto, apat_contacto, amat_contacto, email_contacto, celular, id_proveedores) VALUES ('" + txt_nom
.Text + "','" + txt_apat
.Text + "','" + txt_amat
.Text + "','" + txt_mail
.Text + "','" + txt_cel
.Text + "'," + id
+ ")", conexion
); insertar.ExecuteNonQuery();
c = 1;