We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

Autocomplete related question

Thread ID:

Created:

Platform:

Replies:

25691 Mar 3,2005 03:00 PM Windows Forms 0
loading
Tags: Tools
Tom Affholter
Asked On March 3, 2005 03:00 PM

Hi Folks, I have a autocomplete control I am using that returns a primary key I call intPK. I want to be able to locate the contactIDPK in my dataset dsContacts based on my intPK such that once there, a user can click ''next'' and ''previous'' and continue to manipulate thru the dataset. Perhaps a better description is to be able to locate the first ''Smith'' then be able to advance the pointer backwards or forwards past all “Smith”s to ''Smothers'', for example. I have tried a variety of techniques. I have no problem finding the record in the dataset either using a dataview or table.select(). But once I find the record I can’t locate a method for moving the pointer to the record in dsContacts and displaying the record on the screen. A row object returned by the dataview or select(), best I can tell, do not divulge the position in the dataset where it was located. It appears that all search/find methods of ADO are more geared to finding and editing a single record. I sure would appreciate any ideas you might have short of looping thru every record in the massive dataset. Thanks. Tom

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;