The equivalent of a recordset in .NET is a dataset, not a datareader.

If you use a dataset, there is a Select method in the datatable object that does what you are looking for. Here is the syntax for the Select method.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdatadatatableclassselecttopic.asp



>Hi Cathi,
>As far as I know, in VB6 application, we can use find method in the recordset to find a record .. so is that mean that it is unavailble in
>VB.NET ?
>
>example:
>
>mSQL= "Select * from Student Order by StudentCode"
>
>rs.open msql,myconn,.. blah blah
>
>rs.find "studentcode = ' "& mycode & " ' "
>
>please advise .. thanks a lot in advance
>
>regards
>Winanjaya