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.
Rod Paddock
Editor in Chief CoDe Magazine
President Dash Point Software, Inc.
VP Red Matrix Technologies,Inc.