Datagridview showing data from related table

Hello,

I have a datagridview showing information from a dataset table.  

The table the datagrid relates to is related to another table in my dataset.  Please could someone explain how I can show column data from the related row in the other table.

In my example I have a table OrderItems ( which is the current source of the datagrid ).  This is related to the table Orders where OrderItems.OrderID is linked to Orders.ID.

I need the datagridview to include the ability for some of the columns in the OrderItems table to be editable.

From what I can see the dataset wizard can only configure the INSERT, UPDATE and DELETE commands for a single table.  Is this correct?  

Thanks
LVL 1
Petermcg001Asked:
Who is Participating?
 
Petermcg001Author Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.