Paging and Filtering

The Paging function available in the Grid Grouping Control comes in handy when the grid rows exceed the limits of a single page. The default setting pulls all rows and columns irrespective of the data displayed. The Paging function can be used to limit the dimensions of the displayed data. Filters in the Grid Grouping Control, enable users to select and display a subset of records based on user-defined criteria. The criteria can be set using a Filter Bar at runtime as well as in Design Time.

Built-in Paging support in the grid lets you specify the number of records per page to be displayed takes care of the appropriate UI rendering. Optionally, you can also display a user-friendly Pager Bar with slider to scroll through the pages.

Paging is ideal for displaying datasources with large number of records. Performance and usability enhancements can be achieved through the Paging feature.

The grid lets you filter the records that get displayed. This is very useful when dealing with large datasets.

For example, in the 'Country' field, you could filter by a specific country. As another example, in the 'Sales' field, you can filter records whose values are "< 100".

Filters can be defined in the program ss well as during runtime. During runtime, the user can use the built-in Filter Bar which displays a Combo box with all possible filter criteria.

Clicking the Custom option on the Filter drop-down menu pops up the Filter Condition dialog box that lets you set advanced filter conditions.

Custom Filter

The Custom Filter feature can be used to customize the paging logic. Alphabetical paging, which is an example of customized paging, can be implemented using this feature and is illustrated below.