Searching within search results (Database)

[Materialised]

Hi everyone,

I'm not exactly sure what I am talking about here so please bear with me.

I am developing a database driven application (access), which will query
a database and return matching products. To do this I am simply using a
OleDBDataReader and SQL statements to get results from the database.

What I want to do now, is search within the results returned by the
DataReader. I am unsure of how to proceed. I would assume I would need
to make a copy of the results returned from my query and execute some
sort of SQL Query on those results, but I am unsure of what type of
container to use to do this.

If anyone knows how I can achieve what I want I would be most thankful,
and if I am way off the ball here, I would welcome any suggestions on
how to acomplish what I want.

Thanks in advance
Materialised

 

[Ken Tucker [MVP]]

Hi,

It is currently not possible to query data loaded in with a data reader.
The LINQ project is a preview of the next version of visual studio which
adds functions to query classes and data in memory.
http://msdn.microsoft.com/data/ref/linq/


Ken