const string QueryOrders = @"
SELECT OrderID, OrderDate, Freight, ShipName,
		ShipAddress, ShipCity, ShipCountry
FROM Orders
WHERE CustomerID = @CustomerID

SELECT od.OrderID, od.UnitPrice, od.Quantity, od.Discount,
			p.[ProductName]
FROM [Order Details] od
INNER JOIN Orders o
		ON o.[OrderID] = od.[OrderID]
LEFT JOIN Products p
		ON p.[ProductID] = od.[ProductID]
WHERE o.CustomerID = @CustomerID";

DataSet ds = new DataSet("CustomerOrders");
SqlDataAdapter da = new SqlDataAdapter(QueryOrders, ConnectionString);
da.SelectCommand.Parameters.AddWithValue("@CustomerID", "QUICK");
da.TableMappings.Add("Table", "Orders");
da.TableMappings.Add("Table1", "OrderDetails");
da.Fill(ds);
