About Repeater & CollectionPager Query Index Logic

See more:

ASP.NET

SQL

SQL-Server

Hi,
I have a logical problem. Assume I have a table that includes 1000 rows. When I want to display the data in a repeater, I first bind CollectionPager 1000 rows, so CollectionPager knows how many pages there will be, and after that, CollectionPager will be my repeaters datasource.

If I index my table using Row_Number() property and select 10 records per time, and multiply it with my page_number, since its selecting 10 records only, its performance will be good. But at this time my pager does not know how many total records are there and so It does not make paging.

In the other hand I do not want to select all 1000 rows?

What do you offer me?

Thank you.