public void ComboBox1_SelectedIndexChanged(object sender, EventArgs e) { if (comboBox1.Text != "") { CrearConsulta cons = new CrearConsulta(); if (cons.resultquery1cond("tipos_veh", "Form_Asociado", "Tipo", comboBox1.Text) == "Moto") { this.Hide(); FormMotos f = new FormMotos(this.comboBox1.Text.ToString()); f.Show(); } if (cons.resultquery1cond("tipos_veh", "Form_Asociado", "Tipo", comboBox1.Text) == "Carro") { this.Hide(); FormVehiculos f = new FormVehiculos(this.comboBox1.Text.ToString()); f.Show(); this.Hide(); } } }
public void updatequery(string tipo, int inventario, DateTime fechasal, DateTime horasal) { string query; CrearConsulta cons = new CrearConsulta(); if (cons.resultquery1cond("tipos_veh", "Form_Asociado", "Tipo", tipo) == "Moto") { query = "UPDATE `invent_motos` SET `Fecha_Salida`='" + fechasal.ToString("yyyy-MM-dd") + "', `Hora_Salida`='" + horasal.ToString("H:mm:ss") + "' WHERE (`Inventario`='" + inventario + "' AND `Tipo Vehiculo`='" + tipo + "')"; } else { query = "UPDATE `invent_carros` SET `Fecha_Salida`='" + fechasal.ToString("yyyy-MM-dd") + "', `Hora_Salida`='" + horasal.ToString("H:mm:ss") + "' WHERE (`Inventario`='" + inventario + "' AND `Tipo Vehiculo`='" + tipo + "')"; } string MySqlConnectionString = "datasource=127.0.0.1;port=3306;username=root;password=;Database=patiosd1c"; MySqlConnection databaseConnection = new MySqlConnection(MySqlConnectionString); MySqlCommand commandDatabase = databaseConnection.CreateCommand(); commandDatabase.CommandText = query; databaseConnection.Open(); commandDatabase.ExecuteNonQuery(); databaseConnection.Close(); /* * try * { * databaseConnection.Open(); * * * }catch(Exception e) * { * MessageBox.Show("Query Error: " + e.Message); * } * MySqlDataReader reader = commandDatabase.ExecuteReader();*/ }