Paging in ADO.net 2.0 - row count in filtered dataset

[Guest]

I am usign paging in a gird with a Dataset as the DataSource for a grid. I
also apply a Filter expression to the dataset but when I dispaly the Rowcound
or check "AffectedRows" I get the original Row count before I apply the
filter.

How can I get the actual rowcount of the filtered dataset.

I could set up a temp data set to clone against the filtered initial dataset
to get the new row count but that seems like a hack?
Is there a better way to get the filtered row count.

Jawahar

 

[Cor Ligthert [MVP]]

Jawahar,

What kind of grid, there are so much of those,

Cor

 

[Guest]

Cor
I am using a GridView in .net 2.0

Jawahar,

What kind of grid, there are so much of those,

Cor

 

[Cor Ligthert [MVP]]

Jawahar,

Why are you than not using the build in paging instead of doing it yourself.

http://msdn2.microsoft.com/en-us/library/5aw1xfh3.aspx

I hope this helps,

Cor