Grid paging, sorting from XML datasource

[Gopre400Participant]

Hi I create a SQL query and user .ajax call to WebService which returns data in XML format. However the grid with paging does not sort in the same order as the query. Is this the behavior I should expect? Is there a work-around to sort a grid with paging?

here is source of Grid…
datafields: [
{ name: ‘SignID’ },
{ name: ‘District’, type: ‘int’ },
{ name: ‘ActivityCode’, type: ‘int’ },
{ name: ‘SignQuantity’, type: ‘int’},
{ name: ‘SignText’, type: ‘string’ },
{ name: ‘SignNote’ },
{ name: ‘SignSize’ },
{ name: ‘RequestedBy’ },
{ name: ‘RequestedDate2’ },
{ name: ‘RequestID’ },
{ name: ‘RFI’ },
],
async: false,
record: ‘Table’,
url: ‘SRQWebService.asmx/GetSRQViewStreetPlatesGrid’,
sortcolumn: ‘RFI’,
sortdirection: ‘dsc’,
pagesize: 20

And here is grid…
$(“#jqxgrid”).jqxGrid(
{
width: ‘100%’,
source: dataAdapter,
theme: ‘darkblue’,
autoheight: true,
sortable: true,
altrows: true,
enabletooltips: true,
pageable: true,
showstatusbar: true,
editable: true,
groupsrenderer: groupsrenderer,
groupable: true,
groupsexpandedbydefault: true,
closeablegroups: false,
editmode: ‘click’,
selectionmode: ‘singlerow’,
ready: function () {
$(“#jqxgrid”).jqxGrid(‘expandallgroups’);
$(‘#jqxgrid’).jqxGrid(‘gotopage’, gridpagenum);
},

[Author]

Posts