Datagridview showing data from related table
Posted on 2013-01-18
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?