Forum



10:48

15/05/2013

Hi experts,
How to load data in jqGrid pagewise? For example if I have 100000 json records which I need to load in the jqGrid but not all at once because it takes a lot of time. So, I want to load first 500 records at first load of page. And then next 500..next 500 and so on. Could you please give a sample code.Here is the code I am using
$.ajax({ type: "GET", url: "http://pro-db1:8090/SimulatorUIService/SimulatorDataService.svc/CISLOCATIONDATAs", dataType: "json", data: {}, processdata: true, crossDomain: true, async: true, success: function (result) { $("#jqGrid").jqGrid( { datatype: 'local', data: result.d, page: 1, colNames: colNames, colModel: colModel, onSelectRow: function (id) { rowselectdata(id); }, pager: '#pager', viewrecords: true, caption: gridCaption, gridview: false, loadui: "enable", rowNum: pageSize, loadonce: false }); jQuery("#jqGrid").jqGrid('navGrid', '#pager', { edit: false, add: false, del: false }); jQuery("#jqGrid").jqGrid('filterToolbar'); jQuery("#jqGrid").setGridParam().trigger('reloadGrid'); }, error: function (a, b, c) { alert(a); } });
Thanks in advance
Ankit
Most Users Ever Online: 715
Currently Online:
42 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
OlegK: 1255
markw65: 179
kobruleht: 144
phicarre: 132
YamilBracho: 124
Renso: 118
Member Stats:
Guest Posters: 447
Members: 11373
Moderators: 2
Admins: 1
Forum Stats:
Groups: 1
Forums: 8
Topics: 10592
Posts: 31289
Newest Members:
, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.comModerators: tony: 7721, Rumen[Trirand]: 81
Administrators: admin: 66