[RESOLVED] Selecting a Row in a Datagrid

[Quasar6]

Hi everyone.

I have a datagridview, which is bound to a Microsoft Access table.

To update parts of the database, I have been changing a the data-bound Text property of a text box, and then calling the following three lines:

BindingSource.EndEdit();
TableAdapter.Update(DataSet);

TableAdapter.Fill(DataSet.Table);

This works fine, but I have encountered a problem: everytime I call these lines, the currently selected row (only one row may be selected at a time) resets to the first item in the table.

I was planning to store the current row's index in a temp variable, call those lines, then call a method which will re-select the row at that index.

I haven't been able to find a method to achieve this. Dioes someone know how can I select a specific row in a data-bound datagridview?

If there's a better way to do this, by all means let me know.

Thanks,
Qu.

EDIT: Sorry, nearly forgot: I'm using MS Access 2003, Visual C# Express and an OleDb Connection.