DataGridView with columns from multiple tables
With some guidance from DeborahK on MSDN Forums I have managed to configure a TableAdapter to Use SQL joins by following this tutorial: http://www.asp.net/learn/data-access...ial-69-vb.aspx
I had originally tried creating joins in the TableAdapter SQL, but this resulted in a TableAdapter which was not updatable (no insert, update, delete methods). The trick is to use...
msgjunkie
Last Activity: Feb 8 '26, 11:19 PM
Joined: Jun 10 '09
Location:
-
DataGridView with columns from multiple tables
I have 3 related tables in a DataSet - Customers, Products and Orders.
I am trying to create an "editable" DataGridView which, ideally, will contain columns from all the tables. I have tried creating the joins in the TableAdapter SQL, but this results in a read-only data grid.
Customers and Orders are joined in a 1:M relationship by CUSTID.
Products and Orders are joined in a 1:M relationship by...
No activity results to display
Leave a comment: