Datagrid row position

By default, if you've selected a row programmatically, the datagrid control displays it as the last row in the grid by default. How do you display it as the first instead?

Example: The user has typed in "smith," and the program's retreived the database and selected the first record where lname = "smith." I want the first record displayed to be that selection, and then the datagrid to display all the other "smith" rows below it so the user doesn't have to scroll down.

Seems like it should be easy, but I can't figure it out. All ideas appreciated.

Hi,

Have you solved this?

Marivic

It was suggested to select the last row first, then the row you want, which works fine.