"Brian W" <no-spam@flywga.org> wrote in message
news:OqQmVx0bEHA.3788@TK2MSFTNGP10.phx.gbl...
> I have found that when I create and populate a dataview, then set the
> rowfilter property, that the rowfilter doesn't effect anything unless I
bind
> it to a control, if I iterate through the rows, the rowfilter doesn't
filter
> anything.
>
> For example, I have a dataset, I push a table from the dataset to the
> dataview, then set the rowfilter. I want to be able somehow to iterate
> through the filtered rows ONLY, but if I iterate through, I get all rows
> regardless of the rowfilter. Is there a better way to take a table from a
> dataset and iterate through only the rows that I desire? I like the idea
if
> using a rowfilter to do it, it seems like a very simple way to do it, it
> just isn't working as I would like it to. My desire would be to do this as
> easily as setting the rowfilter property or something close to it.
>
> Thanks for any help you can give me.
>
> Brian W.
>
>

"Jay B. Harlow [MVP - Outlook]" <Jay_Harlow_MVP@msn.com> wrote in message
news:OULG$8%23bEHA.3460@TK2MSFTNGP10.phx.gbl...
> Brian,
> Can you post a 10 to 20 lines of your code to demonstrate you problem?
>
> I suspect you are iterating over the Table, you need to iterate over the
> view itself.
>
> When you iterate over a view, you see DataRowView objects, not DataRow
> objects.
>
> Something like:
>
> Dim table As DataTable
> Dim view As New DataView(table)
> view.RowFilter = "id = 1"
> For Each row As DataRowView in view
> ' only rows with id =1 found
> Next
>
> Hope this helps
> Jay
>
> "Brian W" <no-spam@flywga.org> wrote in message
> news:OqQmVx0bEHA.3788@TK2MSFTNGP10.phx.gbl...
> > I have found that when I create and populate a dataview, then set the
> > rowfilter property, that the rowfilter doesn't effect anything unless I
> bind
> > it to a control, if I iterate through the rows, the rowfilter doesn't
> filter
> > anything.
> >
> > For example, I have a dataset, I push a table from the dataset to the
> > dataview, then set the rowfilter. I want to be able somehow to iterate
> > through the filtered rows ONLY, but if I iterate through, I get all rows
> > regardless of the rowfilter. Is there a better way to take a table from
a
> > dataset and iterate through only the rows that I desire? I like the idea
> if
> > using a rowfilter to do it, it seems like a very simple way to do it, it
> > just isn't working as I would like it to. My desire would be to do this
as
> > easily as setting the rowfilter property or something close to it.
> >
> > Thanks for any help you can give me.
> >
> > Brian W.
> >
> >
>
>