Row Filter Visibility

17 Jul 2006 11:45 AM

mfleet1973@yahoo.ca

Hi Gang.

I have set up a row filter on my dataview. I now want to loop through
the records of this dataview. However, even though the datagrid shows
the correct amount of rows, the dataview still has all rows in the
table. How can I set up the loop to only process the visible rows? My
code is as follows:

For iRowCnt = 0 To DataView1.Table.Rows.Count
....
Next

Many Thanks.

Mike.

17 Jul 2006 1:18 PM

Cor Ligthert [MVP]

Mike,

You are using the (Data)Table from the dataview instead of the dataview

For each drv as datarowview in DataView1
drv(index) ....................
Next

I hope this helps,

Cor

<mfleet1***@yahoo.ca> schreef in bericht
Show quoteHide quote

news:1153136732.615509.124120@p79g2000cwp.googlegroups.com...
> Hi Gang.
>
> I have set up a row filter on my dataview. I now want to loop through
> the records of this dataview. However, even though the datagrid shows
> the correct amount of rows, the dataview still has all rows in the
> table. How can I set up the loop to only process the visible rows? My
> code is as follows:
>
> For iRowCnt = 0 To DataView1.Table.Rows.Count
> ...
> Next
>
> Many Thanks.
>
> Mike.
>