Start Building Professional
Web Apps Today

50,000 records in grid with paging

Hello All,

I was wondering if i could have a paging concept in my dhtmlxgrid.Iam retrieving about 2000 records from sql database and i want to give my user a functionality of viewing 15 records on one instance and navigating to other by previous and next option or 1,2,3,4..page number.is it possible in dhtmlxgrid..if yes, then wat code i have to apply for dat and where.
Thank you

To enable paging in the dhtmlxGrid you can use method enablePaging(mode,pageSize,pagesInGrp,pagingControlsContainer,showRecInfo,pagingStateContainer). Parameters here are:
mode - true|false - enable|disable mode
pageSize - count of rows per page
pagesInGrp - count of visible page selectors
pagingControlsContainer - ID or container which will be used for showing paging controls
showRecInfo - true|false - enable|disable showing of additional info about paging state
pagingStateContainer - ID or container which will be used for showing paging state
 mygrid.enablePaging(true,10,5,"pagingArea",true,"recinfoArea");

To use this functionality you should include dhtmlxgrid_pgn.js file to your page. Note paging functionality is available in PRO version only.
Please find example here http://dhtmlx.com/docs/products/dhtmlxGrid/samples/loading_big_datasets/pro_paging.html