Hi,
Having made very good use of the ADO recordset Field indexes created by
setting the Optimize property, I am thrashing through ADO.Net literature to
identify the same functionality. Being unable to find it I assume I am
missing something basic like indexes are always built on datasets. Is that
so or if not how does one implement one?
I am doing repeated searches of a two field 60,000 record table where
both fields are almost always 7 digit numeric characters in text fields. I
have a kluge working where I read the data in to parallel arrays, the key
field of which I convert to integer. I use the integer array for searching
with the BinarySearch method and use the index to read from the text string
array. It works but there are some non-numeric characters in certain
records and carefully selecting against those has proven
complicated...occasional unmanageable records sneaking through. With each
error I improve the record selection conditions. The nice thing would be
either a BinarySearch for string arrays or alternatively the Optimize
equivalent for searching the dataset.
Any suggestions? Thanks. Tom Paquette