7. Paginated Controls
* QDataGrid Pagination
<< * QDataGrid Sorting   |   Back to Main   |   * Enabling AJAX on the QDataGrid >>

View Source
will open in a new window
Adding Pagination to Your QDataGrid
Now, we will add pagination to our datagrid.

In order to enable pagination, we need to define a QPaginator object and assign it to the QDataGrid. Because the QPaginator will be rendered by the QDataGrid (instead of being rendered on the form via a $this->objPaginator->Render() call), we will set the QDataGrid as the QPaginator's parent in the QPaginator constructor call.

In the locally defined dtgPersons_Bind method, in addition to setting the datagrid's DataSource, we also give the datagrid the TotalItemCount (via a Person::CountAll call). And finally, when we make the Person::LoadAll call, we make sure to pass in the datagrid's LimitClause, which will pass the paging information into our LoadAll call to only retrieve the items on the page we are currently viewing.
Previous|1|Next Results: Viewing items 1-19 of 19.
Person ID First Name Last Name Sorted
16 45 455
5 Alex 5456
9 Linda Brady
11 Brett Carlisle
1 joe Doe
18 John Doe
13 Jane Doe
14 Hugh Grant
19 hh hh
4 Mike Ho
8 Samantha Jones
12 Jacob Pratt
2 Kendall Public
3 Ben Robinson
17 Bob Smith
10 Jennifer Smith
6 Wendy Smith
15 Tom Williams
7 Karen Wolfe