public OrderDetailCollection GetAllOrderDetails() { string str = @"select OrderID, ProductID, UnitPrice, Quantity, Discount from [Order Details]" ; SqlCommand cmd = new SqlCommand(str, new SqlConnection(_strCnn)); OrderDetailCollection cc = new OrderDetailCollection(); DataRead.RunQuery(cmd, new DataRead.ProcessRow(OrderDetailProc), cc); cc.AcceptChanges(); return(cc); }
public OrderDetailCollection GetOrderDetailsByOrderId(int OrderId) { string str = @"select OrderID, ProductID, UnitPrice, Quantity, Discount from [Order Details] where OrderId = @OrderId" ; SqlCommand cmd = new SqlCommand(str, new SqlConnection(_strCnn)); cmd.Parameters.Add("@OrderId", SqlDbType.Int, 0, "OrderId"); cmd.Parameters[0].Value = OrderId; OrderDetailCollection cc = new OrderDetailCollection(); DataRead.RunQuery(cmd, new DataRead.ProcessRow(OrderDetailProc), cc); cc.AcceptChanges(); return(cc); }