I’m trying to have two related tables appear in one datagridview with the ability to update/insert/delete. Here is a simplified version of what the table structure looks like:

Table1 Table2

Table1_ID Table2_ID

Order_No Part_No

Table1_ID

I want the datagridview to show: Order_No, and Part_No

Upon trying to create this in the Designer, I was able to make a dataset that included fields from both tables (with an inner join). The automatically created Fill works fine, however, I’m unable to have the wizard create the update/insert/delete. Since I’m a novice, I’m not really sure how to implement them myself (with concurrency).

What would be the easiest way for me to implement this? I’m using C# and Visual Studio 2005. Any guidance would be greatly appreciated!