field evaluation in dataset

[JBDev]

help
The user interface prompts for 2 values. The first value is used as the parameter to lookup a particular record in the dataset. Once the correct record is found, I need to compare the second user value entered to another field in the dataset. Here is an example:

Dim strFld1 As String = TextBox1.Text
Dim strFld2 As String = TextBox2.Text
OleDbDataAdapter1.SelectCommand.Parameters("field1&quot.Value = strFld1
DsGetData1.Clear()
OleDbDataAdapter1.Fill(DsGetData1)
If Me.BindingContext(DsGetData1, "myTable&quot.Count = 0 Then
MsgBox("Rec not found. Please try again", MsgBoxStyle.Exclamation, Me.Text)
Else
'now check to see if strFld2 = field2 (from database)
' how to do this?

 

[JBDev]

I found the answer to this problem. The first step was to get a better book on ADO.NET. Once I positioned the CurrencyManager to the correct row the rest was simple:

ie: Dim fld2 as string = DsGetData1.myTable(0).Field2