How to compare 2 gridviews which bind to a same table in C#?

For example if the table name is employees, i need to bind to two grids - Grid1 and Grid2.

The Employees tables reside in two different Access databases.

Grid1- Connects to Database1 - Binds Employee table and Grid2- Connects to Database2 - Binds Employee table

If i have 3 rows in Grid1 and if i have 2 rows in Grid2, then 3rd row of Grid1- Connects to Database1 - Binds Employee should be shown in red color and when i click an update button outside the grid, the 3rd row should be updated in Grid2.

If the rows are equal and if the column values are different then i need to show that column(s) alone in red colour and then i can overwrite on some update button click. Please advice. Thanks

Comparing and Syncing.

Please give some help on this.

Thanks in advance.

Do you have a primary unique key that can be used for the comparison? Or do you have to compare each value in each row to determine if they are the same?

---

www.insteptech.com ; msmvps.com/blogs/deborahk
We are volunteers and ask only that if we are able to help you, that you mark our reply as your answer. THANKS!

We are changing the issue type to “General Discussion�because you have not followed up with the necessary information. If you have more time to look at the issue and provide more information, please feel free to change the issue type back to “Question�by opening the Options list at the top of the post editor window, and changing the type. If the issue is resolved, we will appreciate it if you can share the solution so that the answer can be found and used by other community members having similar questions.

---

Please mark the replies as answers if they help and unmark if they don't.