Hi,
I'm using a Datagrid connected to an ADODC control. All data needed from the database is displayed and works just fine. My question is: How can I search the data displayed in the datagrid for a value to, when found, select. I want to do this without having the data in the datagrid scroll so the user can see it. The actuall scroll and row select should not be displayed for the user until I found the row I'm looking for.

Right now I'm using:
Adodc1.Recordset.MoveFirst
Do While Not Adodc1.Recordset.EOF
If Adodc1.Recordset.Fields(0).Value = "Test" Then
'Here goes everything that needs to be done
Exit Do
End If
Adodc1.Recordset.MoveNext
Loop

This piece of code works, but the user can see how I'm looping through all rows, and that's where I need your help to find a way to search without the user seeing it.