Guriddo » Topic: jqgrid json object paging & searching not working

jqgrid json object paging & searching not working

Guriddo
jqgrid json object paging & searching not working

This topic has 6 replies, 3 voices, and was last updated 12 years, 7 months ago by cfexpert.

Creator

Topic

September 12, 2013 at 3:53 pm #81246

Participant

Hi i&#39;m using jqgrid and json object.i&#39;m getting the data but paging and search not working..means when i click on next page same data is appearing and in search too..plzzz help me.

1	Hi i'm using jqgrid and json object.i'm getting the data but paging and search not working..means when i click on next page same data is appearing and in search too..plzzz help me.

<br />

<pre class="default prettyprint prettyprinted"><div class="sfcode">my entire jqGrid, for reference:</div>

1	<pre class="default prettyprint prettyprinted"><div class="sfcode">my entire jqGrid, for reference:</div>

<br />

<div class="sfcode">$(document).ready(function () {<br />
var numberTemplate = { formatter: &#39;number&#39;, align: &#39;center&#39;, sorttype: &#39;number&#39; };<br />
jQuery("#UsersGrid").jqGrid({<br />
url: &#39;Jqg.aspx/GetDataTable&#39;,<br />
datatype: &#39;json&#39;,<br />
mtype: &#39;GET&#39;,<br />
ajaxGridOptions: { contentType: "application/json",<br />
success: function (data, textStatus) {<br />
if (textStatus == "success") {<br />
var thegrid = $("#UsersGrid")[0];<br />
thegrid.addJSONData(data.d);<br />
thegrid.grid.hDiv.loading = false; alert(&#39;success&#39;);<br />
switch (thegrid.p.loadui) {<br />
case "disable":<br />
break;<br />
case "enable":<br />
$("#load_" + thegrid.p.id).hide();<br />
break;<br />
case "block":<br />
$("#lui_" + thegrid.p.id).hide();<br />
$("#load_" + thegrid.p.id).hide();<br />
break;<br />
}<br />
}<br />
},<br />
error: alert(&#39;failed&#39;)<br />
},<br />
<br />
postData: {<br />
FilePath: function () {<br />
return $("#FilePath").text();<br />
},<br />
Filter: function () {<br />
return $("#Filter").text();<br />
},<br />
submenu: function () {<br />
return $("#lblSubmenu").text();<br />
}<br />
},<br />
mtype: &#39;POST&#39;,<br />
colNames: [&#39;Sr_No&#39;, &#39;Errors&#39;, &#39;File Name&#39;, &#39;Date&#39;, &#39;action&#39;],<br />
colModel: [{ name: &#39;Sr_No&#39;, index: &#39;Sr_No&#39;, key: true, width: 100, align: &#39;center&#39;, sortable: true, sorttype: &#39;integer&#39;, searchtype: "integer", searchrules: { "required": true, "number": true, "maxValue": 13} },<br />
{ name: &#39;Errors&#39;, index: &#39;Errors&#39;, width: 100, align: &#39;center&#39;, search: true, sorttype: "int", sortable: true },<br />
{ name: &#39;File Name&#39;, index: &#39;files&#39;, search: true, stype: &#39;text&#39;, width: 500, sorttype: "string", align: &#39;center&#39;, sortable: true },<br />
{ name: &#39;Date&#39;, index: &#39;Date&#39;, width: 100, search: true, sortable: true, sorttype: "date", align: &#39;center&#39;, sorttype: &#39;date&#39;,<br />
formatter: &#39;date&#39;, formatoptions: { newformat: &#39;M-d-Y&#39; }, datefmt: &#39;M-d-Y&#39;<br />
},<br />
{ name: &#39;action&#39;, index: &#39;action&#39;, align: &#39;center&#39;, sortable: false, search: false, formatter: displayButtons}],<br />
pager: &#39;#UsersGridPager&#39;,<br />
viewrecords: true,<br />
imgpath: &#39;Images/jqgrid&#39;,<br />
rowNum: 5,<br />
rowList: [5, 10, 20],<br />
gridview: true,<br />
loadonce: false,<br />
rownumbers: false,<br />
sortname: &#39;Sr_No&#39;,<br />
sortorder: &#39;desc&#39;,<br />
localReader: { id: &#39;Sr_No&#39; },<br />
editurl: &#39;clientArray&#39;,<br />
clickOnPagination : function() { $(this).jqGrid("clearGridData"); $(this).setGridParam({datatype: &#39;json&#39;}).triggerHandler("reloadGrid"); },<br />
cmTemplate: {<br />
searchoptions: {<br />
sopt: [&#39;cn&#39;, &#39;eq&#39;, &#39;ne&#39;]//comment out this out tp resolve error<br />
},<br />
searchrules: {<br />
required: true<br />
}<br />
},<br />
height: &#39;100%&#39;,<br />
serializeGridData: function (postData) {<br />
var propertyName, propertyValue, dataToSend = {};<br />
for (propertyName in postData) {<br />
if (postData.hasOwnProperty(propertyName)) {<br />
propertyValue = postData[propertyName];<br />
if ($.isFunction(propertyValue)) {<br />
dataToSend[propertyName] = propertyValue();<br />
} else {<br />
dataToSend[propertyName] = propertyValue<br />
}<br />
}<br />
}<br />
<br />
return JSON.stringify(dataToSend);<br />
}<br />
});<br />
jQuery("#UsersGrid").navGrid(&#39;#UsersGridPager&#39;,<br />
{ add: false, edit: false, del: false, refresh: false },<br />
{},<br />
{},<br />
{},<br />
{ multipleSearch: true, multipleGroup: true, afterRedraw: function () {<br />
$(this).find(".input-elm").triggerHandler(&#39;change&#39;, [true]);<br />
}<br />
});<br />
function displayButtons(cellvalue, options, rowObject) {<br />
var View = "<a href="#" target="_blank" rel="nofollow">View</a>";<br />
var Download = "<a href="/Download/" target="_blank" rel="nofollow">Download</a>";<br />
return View + Download;<br />
}<br />
});</div>

100

101

<div class="sfcode">$(document).ready(function () {

var numberTemplate = { formatter: 'number', align: 'center', sorttype: 'number' };

jQuery("#UsersGrid").jqGrid({

url: 'Jqg.aspx/GetDataTable',

datatype: 'json',

mtype: 'GET',

ajaxGridOptions: { contentType: "application/json",

success: function (data, textStatus) {

if (textStatus == "success") {

var thegrid = $("#UsersGrid")[0];

thegrid.addJSONData(data.d);

thegrid.grid.hDiv.loading = false; alert('success');

switch (thegrid.p.loadui) {

case "disable":

break;

case "enable":

$("#load_" + thegrid.p.id).hide();

break;

case "block":

$("#lui_" + thegrid.p.id).hide();

$("#load_" + thegrid.p.id).hide();

break;

}

},

error: alert('failed')

},

postData: {

FilePath: function () {

return $("#FilePath").text();

},

Filter: function () {

return $("#Filter").text();

},

submenu: function () {

return $("#lblSubmenu").text();

}

},

mtype: 'POST',

colNames: ['Sr_No', 'Errors', 'File Name', 'Date', 'action'],

colModel: [{ name: 'Sr_No', index: 'Sr_No', key: true, width: 100, align: 'center', sortable: true, sorttype: 'integer', searchtype: "integer", searchrules: { "required": true, "number": true, "maxValue": 13} },

{ name: 'Errors', index: 'Errors', width: 100, align: 'center', search: true, sorttype: "int", sortable: true },

{ name: 'File Name', index: 'files', search: true, stype: 'text', width: 500, sorttype: "string", align: 'center', sortable: true },

{ name: 'Date', index: 'Date', width: 100, search: true, sortable: true, sorttype: "date", align: 'center', sorttype: 'date',

formatter: 'date', formatoptions: { newformat: 'M-d-Y' }, datefmt: 'M-d-Y'

},

{ name: 'action', index: 'action', align: 'center', sortable: false, search: false, formatter: displayButtons}],

pager: '#UsersGridPager',

viewrecords: true,

imgpath: 'Images/jqgrid',

rowNum: 5,

rowList: [5, 10, 20],

gridview: true,

loadonce: false,

rownumbers: false,

sortname: 'Sr_No',

sortorder: 'desc',

localReader: { id: 'Sr_No' },

editurl: 'clientArray',

clickOnPagination : function() { $(this).jqGrid("clearGridData"); $(this).setGridParam({datatype: 'json'}).triggerHandler("reloadGrid"); },

cmTemplate: {

searchoptions: {

sopt: ['cn', 'eq', 'ne']//comment out this out tp resolve error

},

searchrules: {

required: true

}

},

height: '100%',

serializeGridData: function (postData) {

var propertyName, propertyValue, dataToSend = {};

for (propertyName in postData) {

if (postData.hasOwnProperty(propertyName)) {

propertyValue = postData[propertyName];

if ($.isFunction(propertyValue)) {

dataToSend[propertyName] = propertyValue();

} else {

dataToSend[propertyName] = propertyValue

}

return JSON.stringify(dataToSend);

}

});

jQuery("#UsersGrid").navGrid('#UsersGridPager',

{ add: false, edit: false, del: false, refresh: false },

{},

{ multipleSearch: true, multipleGroup: true, afterRedraw: function () {

$(this).find(".input-elm").triggerHandler('change', [true]);

}

});

function displayButtons(cellvalue, options, rowObject) {

var View = "<a href="#" target="_blank" rel="nofollow">View</a>";

var Download = "<a href="/Download/" target="_blank" rel="nofollow">Download</a>";

return View + Download;

}

});</div>

Creator

Topic

Viewing 6 replies - 1 through 6 (of 6 total)

Author

Replies

September 13, 2013 at 11:44 am #101341

tony

Keymaster

Hello,

Try first not to ovrewrite the default jqGrid ajax succes function.

The pagging, sorting and serching in your case is a server side job, so I recommend you to lookat your server side code.

Regards

September 13, 2013 at 2:06 pm #101344

sarvani

Participant

tony said:

Hello,

Try first not to ovrewrite the default jqGrid ajax succes function.

The pagging, sorting and serching in your case is a server side job, so I recommend you to lookat your server side code.

Regards

Thank you tony

Here is my server code

public static s_GridResult GetDataTable(string _search, string nd, int rows, int page, string sidx,

1	public static s_GridResult GetDataTable(string _search, string nd, int rows, int page, string sidx,

<div class="sfcode">string sord, string FilePath, string Filter, string submenu)<br />
{<br />
<br />
int startindex = (page - 1);<br />
int endindex = page;<br />
DataTable dt = xxxxxxxx;//returns datatable<br />
s_GridResult result = new s_GridResult();<br />
List<s> rowsadded = new List</s><s>();<br />
int idx = 1;<br />
foreach (DataRow row in dt.Rows)<br />
{<br />
s_RowData newrow = new s_RowData();<br />
newrow.id = idx++;<br />
newrow.cell = new string[4];  //total number of columns<br />
newrow.cell[0] = row[0].ToString();<br />
newrow.cell[1] = row[1].ToString();<br />
newrow.cell[2] = row[2].ToString();<br />
newrow.cell[3] = row[4].ToString();<br />
rowsadded.Add(newrow);<br />
}<br />
result.rows = rowsadded.ToArray();<br />
result.page = page;<br />
result.total = dt.Rows.Count;<br />
result.record = rowsadded.Count;<br />
return result;<br />
}</s></div>

<div class="sfcode">string sord, string FilePath, string Filter, string submenu)

{

int startindex = (page - 1);

int endindex = page;

DataTable dt = xxxxxxxx;//returns datatable

s_GridResult result = new s_GridResult();

List<s> rowsadded = new List</s><s>();

int idx = 1;

foreach (DataRow row in dt.Rows)

{

s_RowData newrow = new s_RowData();

newrow.id = idx++;

newrow.cell = new string[4]; //total number of columns

newrow.cell[0] = row[0].ToString();

newrow.cell[1] = row[1].ToString();

newrow.cell[2] = row[2].ToString();

newrow.cell[3] = row[4].ToString();

rowsadded.Add(newrow);

}

result.rows = rowsadded.ToArray();

result.page = page;

result.total = dt.Rows.Count;

result.record = rowsadded.Count;

return result;

}</s></div>

<br />

<br />

Plzz Help me <img decoding="async" title="Frown" src="/blog/wp-content/forum-smileys/sf-frown.gif" alt="Frown" />

1	Plzz Help me <img decoding="async" title="Frown" src="/blog/wp-content/forum-smileys/sf-frown.gif" alt="Frown" />

September 13, 2013 at 2:07 pm #101345

sarvani

Participant

sarvani said:

tony said:

Hello,

Try first not to ovrewrite the default jqGrid ajax succes function.

The pagging, sorting and serching in your case is a server side job, so I recommend you to lookat your server side code.

Regards

Thank you tony

Here is my server code

public static s_GridResult GetDataTable(string _search, string nd, int rows, int page, string sidx,

1

public static s_GridResult GetDataTable(string _search, string nd, int rows, int page, string sidx,

<div class="sfcode">string sord, string FilePath, string Filter, string submenu) { int startindex = (page - 1); int endindex = page; DataTable dt = xxxxxxxx;//returns datatable s_GridResult result = new s_GridResult(); List<s> rowsadded = new List</s><s>(); int idx = 1; foreach (DataRow row in dt.Rows) { s_RowData newrow = new s_RowData(); newrow.id = idx++; newrow.cell = new string[4]; //total number of columns newrow.cell[0] = row[0].ToString(); newrow.cell[1] = row[1].ToString(); newrow.cell[2] = row[2].ToString(); newrow.cell[3] = row[4].ToString(); rowsadded.Add(newrow); } result.rows = rowsadded.ToArray(); result.page = page; result.total = dt.Rows.Count; result.record = rowsadded.Count; return result; }</s></div>

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26

<div class="sfcode">string sord, string FilePath, string Filter, string submenu) 
{ 
 
int startindex = (page - 1); 
int endindex = page; 
DataTable dt = xxxxxxxx;//returns datatable 
s_GridResult result = new s_GridResult(); 
List<s> rowsadded = new List</s><s>(); 
int idx = 1; 
foreach (DataRow row in dt.Rows) 
{ 
s_RowData newrow = new s_RowData(); 
newrow.id = idx++; 
newrow.cell = new string[4]; //total number of columns 
newrow.cell[0] = row[0].ToString(); 
newrow.cell[1] = row[1].ToString(); 
newrow.cell[2] = row[2].ToString(); 
newrow.cell[3] = row[4].ToString(); 
rowsadded.Add(newrow); 
} 
result.rows = rowsadded.ToArray(); 
result.page = page; 
result.total = dt.Rows.Count; 
result.record = rowsadded.Count; 
return result; 
}</s></div>

1

1

Plzz Help me <img decoding="async" title="Frown" src="/blog/wp-content/forum-smileys/sf-frown.gif" alt="Frown" /></code><code>i'm new to jqgrid...:(

1

Plzz Help me <img decoding="async" title="Frown" src="/blog/wp-content/forum-smileys/sf-frown.gif" alt="Frown" /></code><code>i'm new to jqgrid...:(

September 18, 2013 at 8:24 pm #101366

sarvani

Participant

help me

September 19, 2013 at 11:48 am #101369

tony

Keymaster

Hello,

It seems to me you do not read my post carfully.

Please read it again. TRY TO USE A VERY SIMPLE JQGRID SETUP AS FROM THE DEMOS.

Regards

November 29, 2013 at 11:09 am #101588

cfexpert

Participant

Tony,

I am also getting same problem. Search and paging are not working for the JSON.

I am using simple grid.

Please see the following code.

}); $(“##list”).jqGrid('navGrid','##pager',{add:false,edit:false,del:false}); }); } id: “id” cell: “”, total: “TOTAL”, page: “PAGE”, root: “ROWS”, jsonReader: { caption: “#rc.grid#”, viewrecords: true, sortorder: “desc”, rowList:[10,20,30], rowNum:10, }, $(“##”+subgrid_table_id).jqGrid('navGrid',”##”+pager_id,{edit:false,add:false,del:false}) }); jsonReader: { repeatitems : false, root:”attribute” } width: '100%',

Author

Replies

Viewing 6 replies - 1 through 6 (of 6 total)

You must be logged in to reply to this topic.

Stay connected with us in your favorite flavor!

jqgrid json object paging & searching not working

Search Forum

Recent Replies

Forum Statistics

UserOnline