2 datagrids and 3 labels to read database info

[blueeyes53]

Hi there,

I have 2 datagrids which one is for Customers, and the other one is for Suppliers. I have filled the 2 datagrids with their right tbl information. Which is the Customer Datagrid with its info. and the Suppliers Datagrid with its. I have 3 labels which is for the factory tbl, which is showing Factory ID, Factory Name, and Factory Address. When I click on the navigate first, next, last, etc. Only the data in the 3 factory labels changes, but the other data in the datagrids do not follow the changes.

Could you please how do I cynchronize so the 3 tbls work together.
Need help I have been trying for a long time and I just can't make them search the data the 3 of them together.

Thanks

 

[jwh]

try re-databinding them, e.g.

datagrid2.databind()
datagrid3.databind()

That should make them re-query their data source.