public static void updateAvion(Avion a) { connection.Open(); string query = "UPDATE avions SET modele=\"" + a.ModelAvionProperty + "\",motorisation=\"" + a.MotorisationProperty + "\",capacite=\"" + a.CapaciteProperty + "\",nb_place_premium=\"" + a.NbrPremiumProperty + "\",nb_place_business=\"" + a.NbrBusinessProperty + "\",nb_place_eco=\"" + a.NbrEcoProperty + "\",etat=\"" + a.EtatAvionProperty + "\",type=\"" + a.TypeProperty + "\" WHERE idAvion=" + a.idProperty + ""; MySqlCommand cmd = new MySqlCommand(query, connection); //MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd); cmd.ExecuteNonQuery(); connection.Close(); }
public void SelectAvion(ObservableCollection <Avion> l) { connection.Close(); connection.Open(); string query = "SELECT * FROM avions"; MySqlCommand cmd = new MySqlCommand(query, connection); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Avion a = new Avion(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetInt32(3), reader.GetInt32(4), reader.GetInt32(5), reader.GetInt32(6), reader.GetInt32(7), reader.GetInt32(8)); l.Add(a); } reader.Close(); connection.Close(); }