A newer version of this page is available.

DevExtreme jQuery/JS - Paging

Paging is used to load data in portions, which improves the widget's performance on large datasets. Paging is enabled by default. You can control it with the paging object. Use this object's pageIndex and pageSize options of to specify the initial page and the number of rows on a page.

jQuery

JavaScript

$(function () {
    $("#dataGridContainer").dxDataGrid({  
        // ...
        paging: {
            pageSize: 15,
            pageIndex: 1    // Shows the second page
        }
    });
});

Angular

HTML

TypeScript

<dx-data-grid>
    <dxo-paging 
        [pageSize]="15"
        [pageIndex]="1"> <!-- Shows the second page -->
    </dxo-paging>
</dx-data-grid>

import { DxDataGridModule } from "devextreme-angular";
// ...
export class AppComponent {
    // ...
}
@NgModule({
    imports: [
        // ...
        DxDataGridModule
    ],
    // ...
})

Vue

App.vue

<template>
    <DxDataGrid ... >
        <DxPaging
            :page-size="15"
            :page-index="1" /> <!-- Shows the second page -->
    </DxDataGrid>
</template>

<script>
import 'devextreme/dist/css/dx.common.css';
import 'devextreme/dist/css/dx.light.css';

import DxDataGrid, {
    DxPaging
} from 'devextreme-vue/data-grid';

export default {
    components: {
        DxDataGrid,
        DxPaging
    }
}
</script>

React

App.js

import React from 'react';

import 'devextreme/dist/css/dx.common.css';
import 'devextreme/dist/css/dx.light.css';

import DataGrid, {
    Paging
} from 'devextreme-react/data-grid';

class App extends React.Component {
    render() {
        return (
            <DataGrid ... >
                <Paging
                    defaultPageSize={15}
                    defaultPageIndex={1} /> {/* Shows the second page */}
            </DataGrid>
        );
    }
}
export default App;

When working with small datasets, you can disable paging by setting the paging.enabled option to false.

jQuery

JavaScript

$(function () {
    $("#dataGridContainer").dxDataGrid({
        // ...
        paging: { enabled: false }
    });
});

Angular

HTML

TypeScript

<dx-data-grid ... >
    <dxo-paging [enabled]="false"></dxo-paging>
</dx-data-grid>

import { DxDataGridModule } from "devextreme-angular";
// ...
export class AppComponent {
    // ...
}
@NgModule({
    imports: [
        // ...
        DxDataGridModule
    ],
    // ...
})

Vue

App.vue

<template>
    <DxDataGrid ... >
        <DxPaging :enabled="false" />
    </DxDataGrid>
</template>

<script>
import 'devextreme/dist/css/dx.common.css';
import 'devextreme/dist/css/dx.light.css';

import DxDataGrid, {
    DxPaging
} from 'devextreme-vue/data-grid';

export default {
    components: {
        DxDataGrid,
        DxPaging
    }
}
</script>

React

App.js

import React from 'react';

import 'devextreme/dist/css/dx.common.css';
import 'devextreme/dist/css/dx.light.css';

import DataGrid, {
    Paging
} from 'devextreme-react/data-grid';

class App extends React.Component {
    render() {
        return (
            <DataGrid ... >
                <Paging enabled={false} />
            </DataGrid>
        );
    }
}
export default App;

User Interaction

This section describes how to configure the pager, a component that allows users to navigate through pages and change their size at runtime. The pager consists of the page navigator and several optional elements: the page size selector, navigation buttons, and page information.

DevExtreme HTML5 JavaScript jQuery Angular Knockout Widget DataGrid Pager

Set the showNavigationButtons and the showPageSizeSelector options to true to show the navigation buttons and the page size selector. The set of available page sizes depends on how large the data source is. You can change it using the allowedPageSizes option.

jQuery

JavaScript

$(function () {
    $("#dataGridContainer").dxDataGrid({
        // ...
        pager: {
            showPageSizeSelector: true,
            allowedPageSizes: [10, 20, 50],
            showNavigationButtons: true
        }
    });
});

Angular

HTML

TypeScript

<dx-data-grid ... >
    <dxo-pager
        [showPageSizeSelector]="true"
        [allowedPageSizes]="[10, 20, 50]"
        [showNavigationButtons]="true">
    </dxo-pager>
</dx-data-grid>

import { DxDataGridModule } from "devextreme-angular";
// ...
export class AppComponent {
    // ...
}
@NgModule({
    imports: [
        // ...
        DxDataGridModule
    ],
    // ...
})

Vue

App.vue

<template>
    <DxDataGrid ... >
        <DxPager
            :show-page-size-selector="true"
            :allowed-page-sizes="[10, 20, 50]"
            :show-navigation-buttons="true"
        />
    </DxDataGrid>
</template>

<script>
import 'devextreme/dist/css/dx.common.css';
import 'devextreme/dist/css/dx.light.css';

import DxDataGrid, {
    DxPager
} from 'devextreme-vue/data-grid';

export default {
    components: {
        DxDataGrid,
        DxPager
    }
}
</script>

React

App.js

import React from 'react';

import 'devextreme/dist/css/dx.common.css';
import 'devextreme/dist/css/dx.light.css';

import DataGrid, {
    Pager
} from 'devextreme-react/data-grid';

const allowedPageSizes = [10, 20, 50];

class App extends React.Component {
    render() {
        return (
            <DataGrid ... >
                <Pager
                    showPageSizeSelector={true}
                    allowedPageSizes={allowedPageSizes}
                    showNavigationButtons={true}
                />
            </DataGrid>
        );
    }
}
export default App;

Assign true to the showInfo option to show the page information. You can change the default text by specifiyng the infoText.

jQuery

JavaScript

$(function () {
    $("#dataGridContainer").dxDataGrid({
        // ...
        pager: {
            showInfo: true,
            infoText: "Page #{0}. Total: {1} ({2} items)" 
        }
    });
});

Angular

HTML

TypeScript

<dx-data-grid>
    <dxo-pager
        [showInfo]="true"
        infoText="Page #{0}. Total: {1} ({2} items)">
    </dxo-pager>
</dx-data-grid>

import { DxDataGridModule } from "devextreme-angular";
// ...
export class AppComponent {
    // ...
}
@NgModule({
    imports: [
        // ...
        DxDataGridModule
    ],
    // ...
})

Vue

App.vue

<template>
    <DxDataGrid ... >
        <DxPager
            :show-info="true"
            info-text="Page #{0}. Total: {1} ({2} items)"
        />
    </DxDataGrid>
</template>

<script>
import 'devextreme/dist/css/dx.common.css';
import 'devextreme/dist/css/dx.light.css';

import DxDataGrid, {
    DxPager
} from 'devextreme-vue/data-grid';

export default {
    components: {
        DxDataGrid,
        DxPager
    }
}
</script>

React

App.js

import React from 'react';

import 'devextreme/dist/css/dx.common.css';
import 'devextreme/dist/css/dx.light.css';

import DataGrid, {
    Pager
} from 'devextreme-react/data-grid';

class App extends React.Component {
    render() {
        return (
            <DataGrid ... >
                <Pager
                    showInfo={true}
                    infoText="Page #{0}. Total: {1} ({2} items)"
                />
            </DataGrid>
        );
    }
}
export default App;

View Demo

API

Call the pageCount() method to get the total page count.

jQuery

JavaScript

var totalPageCount = $("#dataGridContainer").dxDataGrid("instance").pageCount();

Angular

TypeScript

import { ..., ViewChild } from "@angular/core";
import { DxDataGridModule, DxDataGridComponent } from "devextreme-angular";
// ...
export class AppComponent {
    @ViewChild(DxDataGridComponent, { static: false }) dataGrid: DxDataGridComponent;
    // Prior to Angular 8
    // @ViewChild(DxDataGridComponent) dataGrid: DxDataGridComponent;
    getTotalPageCount () {
        this.dataGrid.instance.pageCount();
    }
}
@NgModule({
    imports: [
        // ...
        DxDataGridModule
    ],
    // ...
})

Vue

App.vue

<template>
    <DxDataGrid ...
        ref="myDataGrid">
    </DxDataGrid>
</template>

<script>
import 'devextreme/dist/css/dx.common.css';
import 'devextreme/dist/css/dx.light.css';

import DxDataGrid from 'devextreme-vue/data-grid';

export default {
    components: {
        DxDataGrid
    },
    methods: {
        getTotalPageCount() {
            return this.$refs['myDataGrid'].instance.pageCount();
        }
    }
}
</script>

React

App.js

import React from 'react';

import 'devextreme/dist/css/dx.common.css';
import 'devextreme/dist/css/dx.light.css';

import DataGrid from 'devextreme-react/data-grid';

class App extends React.Component {
    constructor(props) {
        super(props);
        this.dataGridRef = React.createRef();

        this.getTotalPageCount = () => {
            return this.dataGridRef.current.instance.pageCount();
        }
    }

    render() {
        return (
            <DataGrid ...
                ref={this.dataGridRef}>
            </DataGrid>
        );
    }
}
export default App;

The DataGrid also provides the pageIndex(newIndex) and pageSize(value) methods that switch the grid to a specific page and change the page size. They can also be called without arguments, in which case, they return the index and size of the current page.

jQuery

JavaScript

$("#dataGridContainer").dxDataGrid("instance").pageSize(8);

JavaScript

var goToLastPage = function (dataGridInstance) {
    dataGridInstance.pageIndex(dataGridInstance.pageCount() - 1);
}

Angular

TypeScript

import { ..., ViewChild } from "@angular/core";
import { DxDataGridModule, DxDataGridComponent } from "devextreme-angular";
// ...
export class AppComponent {
    @ViewChild(DxDataGridComponent, { static: false }) dataGrid: DxDataGridComponent;
    // Prior to Angular 8
    // @ViewChild(DxDataGridComponent) dataGrid: DxDataGridComponent;
    changePageSize () {
        this.dataGrid.instance.pageSize(8);
    }
    goToLastPage () {
        this.dataGrid.instance.pageIndex(this.dataGrid.instance.pageCount() - 1);
    }
}
@NgModule({
    imports: [
        // ...
        DxDataGridModule
    ],
    // ...
})

Vue

App.vue

<template>
    <DxDataGrid ...
        ref="myDataGrid">
        <DxPaging
            :page-size.sync="pageSize"
            :page-index.sync="pageIndex"
        />
    </DxDataGrid>
</template>

<script>
import 'devextreme/dist/css/dx.common.css';
import 'devextreme/dist/css/dx.light.css';

import DxDataGrid, {
    DxPaging
} from 'devextreme-vue/data-grid';

export default {
    components: {
        DxDataGrid,
        DxPaging
    },
    data() {
        return {
            pageSize: 20,
            pageIndex: 0
        }
    },
    methods: {
        changePageSize(value) {
            this.pageSize = value;
        },
        goToLastPage() {
            const pageCount = this.$refs['myDataGrid'].instance.pageCount();
            this.pageIndex = pageCount - 1;
        }
    }
}
</script>

React

App.js

import React from 'react';

import 'devextreme/dist/css/dx.common.css';
import 'devextreme/dist/css/dx.light.css';

import DataGrid, {
    Paging
} from 'devextreme-react/data-grid';

class App extends React.Component {
    constructor(props) {
        super(props);
        this.dataGridRef = React.createRef();
        this.state = {
            pageSize: 20,
            pageIndex: 0
        };

        this.changePageSize = this.changePageSize.bind(this);
        this.goToLastPage = this.goToLastPage.bind(this);
        this.handleOptionChange = this.handleOptionChange.bind(this);
    }

    changePageSize(value) {
        this.setState({
            pageSize: value
        });
    }

    goToLastPage() {
        const pageCount = this.dataGridRef.current.instance.pageCount();
        this.setState({
            pageIndex: pageCount - 1
        });
    }

    handleOptionChange(e) {
        if(e.fullName === 'paging.pageSize') {
            this.setState({
                pageSize: e.value 
            });
        }
        if(e.fullName === 'paging.pageIndex') {
            this.setState({
                pageIndex: e.value 
            });
        }
    }

    render() {
        return (
            <DataGrid ...
                ref={this.dataGridRef}
                onOptionChanged={this.handleOptionChange}>
                <Paging
                    pageSize={this.state.pageSize}
                    pageIndex={this.state.pageIndex}
                />
            </DataGrid>
        );
    }
}
export default App;

DevExtreme jQuery/JS - Paging

jQuery

Angular

Vue

React

jQuery

Angular

Vue

React

User Interaction

jQuery

Angular

Vue

React

jQuery

Angular

Vue

React

See Also

API

jQuery

Angular

Vue

React

jQuery

Angular

Vue

React

See Also