How to load data in jqGrid pagewise

Question

0.00/5 (No votes)

See more:

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.

Thanks in advance Ankit

Posted 14-May-13 0:23am

ANKIT_JHA

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Diya khan · Accepted Answer · 2013-05-14T01:04:00

Solution 1

Here is the sample code for paging implementation in jqGrid.
http://trirand.com/blog/jqgrid/jqgrid.html

Posted 14-May-13 1:04am

Diya khan

Comments

ANKIT_JHA 14-May-13 8:10am

Diya, I have that link. And following it. But the problem is, grid gets loaded with all the data at once which is making my application slow.

Diya khan 14-May-13 8:23am

If you use loadonce:true jqGrid change the datatype parameters to 'local' after the first load of data from the grid. All next grid reloading (sorting, paging, filtering) works local. If you want refresh the grid data from the server one you should set loadonce:false and datatype to its original value ('json' or 'xml'). For example:

$("#list").setGridParam({datatype:'json', page:1}).trigger('reloadGrid');

So in case of loadonce:false or no loadonce parameter your server is responsible for sorting and paging of the data. If it is not work you have to verify your server code.

ANKIT_JHA 15-May-13 1:55am

Hi Diya,

I am doing client side programming. Here is a piece of sample code.

$.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);
}

});

ANKIT_JHA 15-May-13 1:57am

Any expert out there. Please help me out.

ANKIT_JHA 15-May-13 2:20am

Here I am getting all the records (near about 50000)at a time being loaded in back-end of jqGrid. What I want to do is, getting 500 records in each page of grid so that performance increases as it is getting time to load the jqGrid.

Diya khan 16-May-13 3:24am

First, if you want to get records from server according to your page-size then you have to implement that logic on server-end. If server is returning all records at once then performance cannot be increased at client side.

Second, you have set datatype parameter to local which means that all paging,sorting and filters should work with local data (that have been stored at a first time load).

ANKIT_JHA 16-May-13 5:25am

I am using wcf dataservice. which has been hosted on pro-db1. the url is url: "http://pro-db1:8090/SimulatorUIService/SimulatorDataService.svc/CISLOCATIONDATAs". CISLOCATIONDATAs is the table which is having records. I want to load only 500 records from this url. but this url is returning all the records(300000).

Dalgacu 25-Jan-16 15:15pm

Hey there!

I know that have been past 2 years since you ask this question, i am having the same trouble, and i see the post... I was wondering if you really solved your problem, and if you can share how you did it.

I can get on a hashmap, depending the value of the rowNumbers, the amount of data in a key, in other , the number of the total records. But the grid only shows 100 records and dont show me that found 194 i.e., and i dont know where can put the key with my total records to make the pagination...

Sorry for my english, hope someone can help.
Thanks in advance, Daniel.