public void supprimerProduitRevendeur(int id, string nom) { // Create Instance of Connection and Command Object SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]); SqlCommand modif = new SqlCommand("WAT_SupprimerProduitRevendeur", myConnection); // Mark the Command as a SPROC modif.CommandType = CommandType.StoredProcedure; // Add Parameters to SPROC SqlParameter parametreidProd = new SqlParameter("@id_client", SqlDbType.Int, 4); parametreidProd.Value = id; modif.Parameters.Add(parametreidProd); SqlParameter parametreNom = new SqlParameter("@nom_produit", SqlDbType.NVarChar, 50); parametreNom.Value = nom; modif.Parameters.Add(parametreNom); myConnection.Open(); modif.ExecuteNonQuery(); myConnection.Close(); }