|
web
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Searching within search results (Database)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 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
What's the most performant? Fat our smart client?
Postmessage API Can't get true random numbers CHRW .Net Mail and hotmail question Controls do not show correctly at runtime. What are they? output data from the result of storedprocedure into excel format 2 small questions RE: Communicate between 2 applications on the same machine |
|||||||||||||||||||||||