C# (CSharp) DataHandling SQL_CRUD_Methods.SQLDelete Examples

Example #1

File: OrderLineSQLQuery.cs Project: callmebackdraft/DistriFest

        public void RemoveOrderLineFromOrder(int _prodID, int _orderID)
        {
            string query = "DELETE FROM[Order_Product] WHERE ProductID = @ProductID AND OrderID = @OrderID";
            List <KeyValuePair <string, object> > parameterlist = new List <KeyValuePair <string, object> >
            {
                new KeyValuePair <string, object>("@OrderID", _orderID),
                new KeyValuePair <string, object>("@ProductID", _prodID),
            };

            SQL_CRUD_Methods.SQLDelete(query, parameterlist);
        }