Hi all,

I've got a Typed DataSet containing two DataTables. OrderLine and Item.

The orderline table contains an orderlineid, an orderid and a itemid.
The item table contains an itemid and an itemname.
The tables have a relationship between them (itemId).

Now I want a gridview to show the following fields: OrderId and ItemName.

I'm at a loss on how to do this, how can I tell the columns in the datagridview to take their data from a particular DataTable?

I would prefer to solve this without using a DataTable with ALL the information already joined, instead of a DataSet containing two DataTables.

I'd appreciate a shove in the right direction, I don't need a complete working example. Thanks in advance.