I wanted to point out one thing from the .net code


Sub LoadMemberData(ByVal Memberid As Integer)
Me.FormEditMode = enuFormMode.EditMode

Dim oMember As DataRow() = Me.oMemberData.Tables("members").Select("memberid = " + Memberid.ToString)
If oMember.Length > 0 Then
Me.txtMemberID.Text = CStr(oMember(0).Item("memberid"))
Me.txtMemberName.Text = oMember(0).Item("membername")
Me.ddlCountry.SelectedValue = oMember(0).Item("countryid")
Me.txtNotes.Text = oMember(0).Item("MemberNote")
End If
End Sub

This code selects the member data from the local data store. The .Select() function gives devlopers the ability to subselect records from a datatable.
This is how I have implemented the equiv of seek. Even the bruteforce way of iterating through the records would be just as fast.