When I navigate through records in a DataGridView, it should change the records in another DataGridView, but it doesn't. Help!

Question

I have been going through the example Walkthrough: Connecting to Data in a SQL Server Express Database (Windows Forms), and I can scroll up and down the Customers table (the parent table) in a DataGridView and that automatically finds the relevant records in the Orders table (the child table) that have the same CustomerID and it displays them on my second DataGridView component, and everything works OK. But now I want to do the opposite of that: I want to be able to scroll through the Orders (child) table and it will show me in the Customers (parent) table the CompanyName, the ContactName, the ContactTitle, etc. for that order. How do I do this? I tried adding the Orders datasource to my form, and then adding the Customers datasource, but the two DataGridView are not connected (scrolling through Orders doesn't change Customers). What am I doing wrong?

Answer 1

Hi Dwigt,

How do you add Orders table as the datasource? Like drag Orders table from the Data Sources  Windows?

To create data-bound controls on the form

• Drag the main Customers node from the Data Sources window onto Form1.

  A DataGridView and a tool strip (BindingNavigator) for navigating records appear on the form. A SampleDatabaseDataSet, CustomersTableAdapter, BindingSource, and BindingNavigator appear in the component tray.

---

Helen Zhou [MSFT]
MSDN Community Support | Feedback to us

Answer 2

Yes that is exactly what I do.

Answer 3

I am still struggling with this. If I put just the Orders table on the form, I can scroll through it and see every one of the 830 records just fine. Each of these order records has an EmployeeID, which is linked to the Employee table. Now all I want to do is be able to see those other fields in the Employee table that correspond to that EmployeeID as I'm scrolling through records in the Orders table. How do I do this?