By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,417 Members | 1,088 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,417 IT Pros & Developers. It's quick & easy.

Q: Searching and removing

P: n/a
Hi guys

I'd be grateful if you could help me with the following question:

I have a DataSet in which I'm using a SQL search string to find rows which
satisfy a criteria. I'd then like to perform another search, using a
different search criteria, and I know that the rows selected first won't
satisfy the second criteria. What is the most efficient way of doing the
second search? That is, using the "Select" member of the table in the
dataset, won't all the rows be checked again. My idea is to somehow "remove"
the rows from the first search because I know they won't be applicable. As
there would be fewer rows to check, the second search may be quicker (for
the same type of search)

However, the problem is that during each search, the rows found have a value
written to a field which I want to update to the database source at the end
of the calculations. If I'm "deleting" the rows after each search i.e. to
improve the speed of subsequent searches, then I've lost the rows to update.
Hence, the problem! However, I'm sure there must be some way round it.

If my ramblings make sense, I'd be most grateful for any feedback;
especially some example code.

Many thanks in advance

Geoff
Nov 20 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.