DataTables and Multiple Data Sources

[Erik Lautier]

I'm creating a pack slip generator in ASP.NET/VB. It pulls order
information from two SQL Server tables: the first contains the order
ID and customer's shipping info; the second contains the items
ordered. For example:

Table 1
OrderID, Name, Address, City, State, Zip

Table 2
Order ID, ItemCode, ItemDescription, Quantity

I'm generating a Word Doc from a DataAdapter on the aspx page, but the
problem I'm having is in getting the Name and Address for the OrderID
to show up at the top and then the multiple items corresponding to
that OrderID to show up underneath. I think I need two DataTables
populating the SqlDataAdapter, each pulling data from each SQL Server
table, but I can't seem to get this working. Anyone have any ideas?
Thanks.