Home All Groups Group Topic Archive Search About

Searching within search results (Database)

Author
23 May 2006 7:53 PM
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

Author
24 May 2006 12:21 AM
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
---------------
Show quoteHide quote
"Materialised" <materiali***@privacy.net> wrote in message
news:4dh7hdF1a7ag7U1@individual.net...
> 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