Dataset/Datareader and filter

[Bart Schelkens]

Hi,

when we worked with recordsets in VB6 we had the possibility to filter our
recordset.
Does this option still exist in a dataset or a datareader?
If not, how can we have the same effect ?

Thanks.

 

[Miha Markic [MVP C#]]

Hi Bart,

But of course.
You might take a look at DataView and its RowFilter property.
Or, you can just select rows out of DataTable using DataTable.Select
statement.
(DataReader is just a reader - if you want to filter it, adjust its sql
select statement)