filtering the data collected in DataReader

[Doug Zody]

I am populating the data into a datareader.

After populating the data, can I filter the data through code, just like
applying WHERE criteria TO THE QUERY.

I am using .Net Framework 1.1

Thanks,

Douz

 

[W.G. Ryan eMVP]

DataReaders can only be used Forward only with an open and available
connection - so you can filter with if() statements but that's about it -
the datatable though - you can use .Select - Computer - or use the other
methods associated w/ a DataView which hava very similar syntax.

 

[Sahil Malik]

You could use a trick like this
http://dotnetjunkies.com/WebLog/sahilmalik/posts/36078.aspx to create your
own kind of collection and implement the filtering on your own collection -
but that isn't worth all the pain, I'd personally much rather use a
datatable.select or dataview instead.

- Sahil Malik
http://dotnetjunkies.com/weblog/sahilmalik