alternative of “Findfirst” in ADO

[r_amin]

I use VB5/vb6, Access Database, ADO.
I want an alternative way for ADO as “Findfirst” of DAO.
(Actually I need to know this data is in the database or not)

For Example
-------------------
DAO Code was:

dim rstUser as recordset
rstUser.FindFirst ("UsedID=" & cmbBankBr.Text )

--------------------
but this code cannot work with ADO.

any one please help me.

[si_the_geek]

The exact equivalent of that is rather simple to find, it's like this:

rstUser.MoveFirst
rstUser.Find "UsedID=" & cmbBankBr.Text

What would probably be better tho (if appropriate) is to only load the relevant data into the recordset in the first place, using an SQL statement like this:

Dim strSQL as String
  strSQL = "SELECT [i]fields[/i] FROM [i]tablename[/i] WHERE UsedID=" & cmbBankBr.Text
  'use strSQL to open the recordset

[mabbas110]

Please look at the help of "filter" property of ADO , u will easily get ur answer.

[r_amin]

thanx to you all

The exact equivalent of that is rather simple to find, it's like this:

rstUser.MoveFirst
rstUser.Find "UsedID=" & cmbBankBr.Text

What would probably be better tho (if appropriate) is to only load the relevant data into the recordset in the first place, using an SQL statement like this:

Dim strSQL as String
  strSQL = "SELECT [i]fields[/i] FROM [i]tablename[/i] WHERE UsedID=" & cmbBankBr.Text
  'use strSQL to open the recordset

i want to select that record, then view it and update it. ok I'll try.