public static Boolean SupprimerDevis(string id) { foreach (Devis item in BDDExterne.GetAllDevis()) { if (item.devId.ToString() == id) { NpgsqlConnection conn; conn = new NpgsqlConnection(chaineConnection); conn.Open(); NpgsqlCommand MyCmd = null; // id, nom ,tel,numrue,codepostal,ville,pays,mail,nom rue string query = @"DELETE FROM devis CASCADE WHERE id = '" + id + "'"; Debug.WriteLine(query); MyCmd = new NpgsqlCommand(query, conn); MyCmd.ExecuteNonQuery(); //Exécution conn.Close(); return(true); } } return(false); }