Based on the code:
Is there a way to search the records stored in myDataReader?VB Code:
Dim myConnection As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=myDatabase.mdb") Dim myCommand As New OleDb.OleDbCommand("SELECT * FROM myTable WHERE Name='Alvaro'") Dim myDataReader As OleDb.OleDbDataReader myConnection.Open() myDataReader = myCommand.ExecuteReader
Like:
Thanks.VB Code:
myDataReader.Select("LastName='F1'") If myDataReader.NoMatch Then MsgBox("Found.") Else MsgBox("Not found.") End If




Reply With Quote