Linking two datagridviews (keep on same row)

[bjswift]

I have two datagridviews, one represents existing data which is read only, the other shows another table, with the same structure, but allows the user to change the values. Starting out, the grids will be exactly the same, and the first grid only acts as a reference to what the data was like before the uesr changes it, allowing the user to change values on the second grid, while referencing the first grid if needed.

Now, the grid is more vertical than horizontal, so they will have a vertical scroll bar on both grids. How can I link the grids, so that if the user moves to the 5th row of one of the grids, the other grid moves down to that row? Also, when the user scrolls one grid, I want the other grid to scroll exactly the same. Get my drift?

Thanks,

Brandon

[bjswift]

Wow, I found a solution right after I decided to post this question...

in the scroll event of the grids, I set the other grid's .firstDisplayedScrollingRowIndex = to the value of the grid being scrolling's .firstDisplayedScrollingRowIndex

It works like a charm

[cjard]

You could also consider using a DataRelation so that grid 2 only shows the relation of the currently highlighted row in grid 1

[bjswift]

The two grids always have the same rows, it is just they most likely will have a scroll bar attached to them, so that if there are 50 rows, and you want to scroll down to the 35th row, the other grid will scroll along with it, so basically each row on both grids will always be int he same position.

I am now having the problem of selecting the same row when the user clicks a row on one of the grids. Lets say you select the 5th row on the left grid, the 5th row on the right grid should select.

I used the selectionChanged event, but am getting index out of range because it seems like this event fires when both grids aren't fully populated. I am trying to write a workaround, but basically I have this now, which isn't working..

private sub grid1_selectionChanged
grid2.Rows(grid1.SelectedRows(0).Index).Selected = True
end sub

How can I not allow this from running, until basically all of the rows are populated?