Skip to Main Content

Breadcrumb

Overview: Traditional Paging (Total Rows)

The only difference between this example and the previous one is that Show Total Row Count is set to Yes. When the total number of rows is known extra capabilities are available. The range of rows includes the total number of rows (For example 1 - 50 of 5000) and in addition to Next and Previous buttons there are buttons to go to the first and last page. By default there is a sliding list of links to go to specific pages. Advanced configuration can be used to control some of the pagination controls as shown in the next two examples.

In general it is a good idea to define a primary key (or keys) even for a read only Interactive Grid. One thing that it helps with is making sure that duplicate rows are not added to the model when more data is fetched due to pagination. Without a primary key defined duplicates can show up in the Interactive Grid when the set of records on the server changes (for example new records are inserted) because rows are fetched using an offset into the result set.

Traditional Paging (Total Rows)