Hello all,

How can I allow a user to type a letter on the keyboard and have a DataGridView (DGV) change current row to the first occurrence of the letter within a non-Primary Key column.

For example, LastName is a column in a DGV. Typing ‘S’ should change the current row of the DGV to the first Lastname that starts with an ‘S’. Note: LastName is not the primary key of the bound table.

I am using a DataGridView bound to a DataSet.Table[] without a binding source.

Here is a code snippet I tried, but it returns -1:
ds.Tables["Students"].DefaultView.Sort = "LastName";
int intRow = ds.Tables["Students"].DefaultView.Find("S%");

I have also tried this, but it returns zero rows:
ds.Tables["Students"].DefaultView.Sort = "LastName";
DataRowView[] drv = ds.Tables["Students"].DefaultView.FindRows("LastName LIKE 'S'");

Thanks in advance,
KCI

hi,
do you know how to program in java?

cus i need help in an urgent homework.....

could u plz see my question?

thanks

-"what goes around, comes around"

Hello Pedro

Yes, I know Java. I learned it taking a class just like you. I would suggest you learn the basics and not ask someone to do your homework for you. I'm sure your teacher would be disappointed to hear you are soliciting help from random people on the internet.

Regards,
KCI