How to set the pointer to the current row in the Datagridview in C#

I have a datagridview on th开发者_高级运维e Windows Form in c#. I am updating and filling the table adapter on the cell event. The problem is that When I go to lower half of the datagrid which is not visible until I scroll down, as I click any cell, the table adapter is filled and updated and the pointerpoints to the very first row. Any suggestion on how to fix it. I have a ideas to record the top row of the datagridview that is visible and set the pointer to that row. But how to do it?

---

Before the fill happens, save the current cell:

 DataGridViewCell selectedCell = dgv.CurrentCell;

Then after the fill, set it back:

 dgv.CurrentCell = selectedCell;

If you don't care which cell was selected but just want to scroll the view back to where it was before the fill, you can use the FirstDisplayedCell property instead.

I believe these will work but I haven't used them in your exact scenario (which sounds kinda funky).

Incidentally, there a lot of events on the DataGridView, which gives great flexibility, but you have to read the docs carefully to understand all your options.