Rows limit in the Grid

[SRKParticipant]

Hi,

I am using Json result as a source for the grid. i could able to see the grid data if rows length is around 5700 records, but if it crosses the 5700 records grid is showing emptry rows. Is there any limit for displaying the no of records in the jqxgrid…

i have referred one of your demo code , binding 30000 records of array list to grid. that is working fine.

could you please let me know where i am doing wrong in the below code…

var source = {
datatype: “json”,
datafields: [{ name: ‘Column1’ }, { name: ‘Column2’ }, { name: ‘Column3’ }],
url: ‘../SavedPreference/Preferences’
};

var dataAdapter = new $.jqx.dataAdapter(source);

var addfilter = function () {
// apply the filters.
$(“#jqxgrid”).jqxGrid(‘applyfilters’);
}

$(“#jqxgrid”).jqxGrid(
{
source: dataAdapter,
editable: true,
theme: theme,
width: 1140,
selectionmode: ‘multiplerows’,
filterable: true,
columnsresize: true,
sortable: true,
ready: function () {
addfilter();
},
autoshowfiltericon: true,
columns: [
{ text: ‘CheckBox’, datafield: ‘available’, columntype: ‘checkbox’, width: 40 },
{ text: ‘Column1’, editable: false, datafield: ‘Column1’, width: 90 },
{ text: ‘Column2’, editable: false, datafield: ‘Column2’, width: 300 },
{ text: ‘Column3’, editable: false, datafield: ‘Column3’, width: 40 },
]
});

$(“#jqxgrid”).bind(“filter”, function (event) {
$(“#events”).jqxPanel(‘clearcontent’);
var filterinfo = $(“#jqxgrid”).jqxGrid(‘getfilterinformation’);
var eventData = “Triggered ‘filter’ event”;
for (i = 0; i < filterinfo.length; i++) {
var eventData = "Filter Column: " + filterinfo[i].filtercolumntext;
$('#events').jqxPanel('prepend', '

‘ + eventData + ‘

‘);
}
});

[Peter StoevKeymaster]

Hi SRK,

There’s no limit on how many rows can be displayed in the Grid. It displays as many rows as the data source has or a custom number of rows in virtual mode. However, there could be an issue with the JSON data or something else. If you are using ASP .NET MVC, you might also consider using a custom JsonResult Class because the ASP.Net MVC’s built-in JsonResult class has restrictions in the length of the JSON. If your scenario is different, you can send us a sample which demonstrates the issue to support@jqwidgets.com.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[Author]

Posts