Record searching

mza1979m

Member
Joined
Feb 20, 2003
Messages
13
Location
London, Ontario
I have a VB.NET program that connects to an external database (MS Access). In this database are 2 tables: "Business" and "Personal". In each table there are numerous fields.
Now, programatically, how do I perform a search for a specific record using a specific field? For instance, I want to search for the first record with the value of "Joe" in the "fldFirstName" field. Id also like to find all subsequent matches.
How is that done in VB.NET?

In other words, Id like to translate the following line of VB6 code to VB.NET code:

datNavigate.Recordset.FindFirst("fldFirstName = " & "" & "Joe" & "")
 
Last edited by a moderator:
Back
Top