// get the OrderDetails data public static List <OrderDetail> GetOrderDetails() { // list of order details for viewing i the list box List <OrderDetail> orderDetails = new List <OrderDetail>(); // empty list OrderDetail orderDetail; using (SqlConnection connection = GetConnection()) { string query = "SELECT OrderID, ProductID, UnitPrice, Quantity, Discount " + "FROM [Order Details] ORDER BY OrderID"; using (SqlCommand cmd = new SqlCommand(query, connection)) { connection.Open(); SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (reader.Read()) { orderDetail = new OrderDetail(); orderDetail.OrderID = (int)reader["OrderID"]; // datatype int orderDetail.ProductID = (int)reader["ProductID"]; // datatype int orderDetail.UnitPrice = (decimal)reader["UnitPrice"]; // datatype money orderDetail.Quantity = (short)reader["Quantity"]; // datatype smllint orderDetail.Discount = (Single)(reader["Discount"]); // datatype real orderDetail.CalculateOrderTotal(); // total amount of the order orderDetails.Add(orderDetail); } } // cmd recycled } // connection recycled return(orderDetails); }