How to select the last inserted row of the datagrid?

[sharon]

Hi!

I have a datagrid connected to dataset.

I am inserting row with:

oRow = Me.m_DataSet1.Tables(0).NewRow()
...
Me.m_DataSet1.Tables(0).Rows.Add(oRow)

now,
I want that the datagrid will select the new row.

How do i do it?

 

[jmcilhinney]

myDataGrid.CurrentRowIndex = Me.m_DataSet1.Tables(0).Rows.Count - 1

 

[korgano]

That would be the trivial case of an unsorted datagrid.

What about a datagrid, that has been sorted by the user before, the new row would be inserted at an undetermined index. How can I retrieve this index?