public static void updateNbEspece(DAONbEspece p) { string query = "UPDATE nbespece set nombre=\"" + p.nbEspece + "\", idEspece=\"" + p.idEspece + "\" where idNbEspece=" + p.idNbEspece + ";"; MySqlCommand cmd = new MySqlCommand(query, connection); MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd); cmd.ExecuteNonQuery(); }
public static void insertNbEspece(DAONbEspece p) { string query = "INSERT INTO nbespece (`nombre`, `idEspece`) VALUES (\"" + p.nombreDAOEtudeEspece + "\",\"" + p.idEspeceDAOEtudeEspece + "\");"; MySqlCommand cmd2 = new MySqlCommand(query, connection); MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd2); cmd2.ExecuteNonQuery(); }
public static ObservableCollection <DAONbEspece> listeNbEspece() { ObservableCollection <DAONbEspece> l = new ObservableCollection <DAONbEspece>(); string query = "SELECT * FROM nbespece;"; MySqlCommand cmd = new MySqlCommand(query, connection); cmd.ExecuteNonQuery(); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { DAONbEspece p = new DAONbEspece(reader.GetInt32(0), reader.GetInt32(1), reader.GetInt32(2)); l.Add(p); } reader.Close(); return(l); }