Binding many-to-many tables in two DataGridView

1
votes

There are three classic tables from the database Northwind:

Products, OrderDetails, Orders

There are two DataGridView: DgProducts and DgOrders.

as deduced from the data in table Orders(DgOrders), which are connected with the data in table Products (DgProducts), using the relationship many-to-many.

txn!!!

1
c#winformslinq-to-sql
What is the problem are you having? - Chris Walton
how to bind table to DataGridView - mrbrooks
You mean you have a master-detail style view on the form? I guess the question is missing something. - Tengiz
I was referring to master / detail DataGridView and many to many relationships in LINQ-to-SQL tables binding to them. - mrbrooks

1 Answers

0
votes

Have you tried doing an SQL Statement where you can get all the datas you want to display on the two DataGridView?..If so, then store the result of it in a DataAdapter and then to a DataSet. Where you can use the DataSet as a DataSource for your DataGridView.