Searching through datasets

[TeaAddictedGeek]

Is it possible to query a database, return a dataset, and instead of making an additional call be able to search within the recordset multiple times to obtain a subset of data?

I'm attempting to solve a nested datagrid issue where the main datagrid has individual rows with a datagrid representation of data for each row, and don't want to make multiple queries for n number of records.


Thanks!



"The computer programmer is a creator of universes for which he alone is responsible. Universes of virtually unlimited complexity can be created in the form of computer programs."
-Joseph Weizenbaum

 

[phinoppix]

By dataset / recordset you mean a collection of rows fetched from the database? Or the ones already cached (in a DataSet or DataTable object/s)?

If you can explain a bit more specific on what you are trying to do, maybe others can then offer their suggestions.

Nested/recursive searching by itself is possible. But the complexity or simplicity of the searching algo depends basically on the requirements and data schema.

My 2cents