jQuery Grid Plugin - jqGridForum

Forum

November 2nd, 2014

A A A

Topic RSS

Related Topics sp_TopicIcon

asp.net grid errors

Tags: asp.net

07/11/2011
17:16

mrCad

New Member

Members

Forum Posts: 1

Member Since:
07/11/2011

Offline

I have searched for 2 days and still am having issues using jqgrid with asp.net and a webservice, below is my code and markup:

aspx:

My jquery script:

function loadglAcctEditCriteria() {

$("#glAccountSelGrid").jqGrid({

datatype: function (pdata) { getStartData(pdata); },

colNames: ['ID', 'Account', 'Description', 'Posting Y/N', 'Lvl of Detail', 'Posting Status'],

colModel: [

{ name: 'id', width: 1, sortable: false, hidden: true},

{ name: 'Account', width: 100, sortable: false },

{ name: 'Descprition', width: 400, align: 'left', sortable: false },

{ name: 'Posting', width: 120, align: 'center', sortable: false },

{ name: 'PostingStatus', width: 120, align: 'center', sortable: false },

{ name: 'LOD', width: 150, align: 'center', sortable: false}],

pager: jQuery('#pager'),

gridComplete: doWhenGridFullyLoaded,

ondblClickRow: function(rowid) {

jQuery(this).jqGrid('editGridRow', rowid);

}

});

}

function getStartData(pData){

var myDTO = {};

var toPass = JSON.stringify(myDTO);

$.ajax({

type: 'POST',

contentType: "application/json; charset=utf-8″,

dataType: "json",

url: "gl_account_edit.aspx/testJQGrid",

data: toPass,

success: function (data, textStatus) {

if (textStatus == "success")

ReceivedClientData(JSON.parse(getMain(data)).rows);

error: function (data, textStatus) { alert('An error has occured retrieving data!'); }

});

}

Here is the returning data:

{"d":"{"total":2,"page":1,"records":12,"rows":[{"id":"d2e68652-06e3-10e1-b7fd-94e54724019b","Account":"1000","Descprition":"Cash","Posting":false,"PostingStatus":true,"LOD":"LOD 1"},{"id":"d2e68652-06e3-11e1-b7fd-94e54724019b","Account":"1001","Descprition":"Petty Cash","Posting":true,"PostingStatus":true,"LOD":"LOD 1"},{"id":"d2e68652-06e3-12e1-b7fd-94e54724019b","Account":"1000","Descprition":"Cashin Farmers Bank and Trust","Posting":true,"PostingStatus":true,"LOD":"LOD 1"},{"id":"d2e68652-06e3-13e1-b7fd-94e54724019b","Account":"1100","Descprition":"Investments","Posting":false,"PostingStatus":true,"LOD":"LOD 1"},{"id":"d2e68652-06e3-14e1-b7fd-94e54724019b","Account":"1101","Descprition":"Merrel Lynch","Posting":true,"PostingStatus":true,"LOD":"LOD 1"},{"id":"d2e68652-06e3-15e1-b7fd-94e54724019b","Account":"1200","Descprition":"Inventories Raw Materials-All Departments","Posting":false,"PostingStatus":true,"LOD":"LOD 1"},{"id":"d2e68652-06e3-16e1-b7fd-94e54724019b","Account":"1201","Descprition":"Notes Reciveables Officers","Posting":true,"PostingStatus":true,"LOD":"LOD 1"},{"id":"d2e68652-06e3-17e1-b7fd-94e54724019b","Account":"1202","Descprition":"Notes Reciveables Employees","Posting":true,"PostingStatus":true,"LOD":"LOD 1"},{"id":"d2e68652-06e3-18e1-b7fd-94e54724019b","Account":"1300","Descprition":"Inventories","Posting":false,"PostingStatus":true,"LOD":"LOD 1"},{"id":"d2e68652-06e3-19e1-b7fd-94e54724019b","Account":"1301","Descprition":"Inventories Raw Dept1","Posting":true,"PostingStatus":true,"LOD":"LOD 1"},{"id":"d2e68652-06e3-20e1-b7fd-94e54724019b","Account":"1302","Descprition":"Inventories Raw Dept2","Posting":true,"PostingStatus":true,"LOD":"LOD 1"},{"id":"d2e68652-06e3-21e1-b7fd-94e54724019b","Account":"1303","Descprition":"Inventories Raw Dept3","Posting":true,"PostingStatus"

The problems I am having is that first the loading message stays up and never leaves, I get all the rows and they exceed the container and hence no paging available since it is now hidden. The html being rendered is below. I am sure I am just missing something somewhat simple but I have stared at this so long I have no idea, any ideas or help would be greatly appreciated.

Selection Criteria

</div>

View: <select name="acctView" size="1" id="glAcctView">

<option value="0">All Accounts</option>

<option value="1">Active accounts only</option>

<option value="2">Inactive accounts only</option>

</select><br>

Account: <input id="glAcctEditAccount" type="text"><br>

</div>

Description: <input id="glAcctEditDescrp" type="text"><br>

</div>

<div style="width: 915px;" dir="ltr" id="gbox_glAccountSelGrid" class="ui-jqgrid ui-widget ui-widget-content ui-corner-all"><div class="ui-widget-overlay jqgrid-overlay" id="lui_glAccountSelGrid"></div><div class="loading ui-state-default ui-state-active" id="load_glAccountSelGrid">Loading...</div><div style="width: 915px;" id="gview_glAccountSelGrid" class="ui-jqgrid-view"><div style="display: none;" class="ui-jqgrid-titlebar ui-widget-header ui-corner-top ui-helper-clearfix"><a style="right: 0px;" class="ui-jqgrid-titlebar-close HeaderButton" role="link" href="javascript:void(0)"><span class="ui-icon ui-icon-circle-triangle-n"></span></a><span class="ui-jqgrid-title"></span></div><div class="ui-state-default ui-jqgrid-hdiv" style="width: 915px;"><div class="ui-jqgrid-hbox"><table class="ui-jqgrid-htable" style="width: 897px;" role="grid" aria-labelledby="gbox_glAccountSelGrid" border="0" cellpadding="0" cellspacing="0"><thead><tr class="ui-jqgrid-labels" role="rowheader"><th style="width: 1px; display: none;" id="glAccountSelGrid_id" role="columnheader" class="ui-state-default ui-th-column ui-th-ltr"><span style="cursor: col-resize;" class="ui-jqgrid-resize ui-jqgrid-resize-ltr"> </span><div class="ui-jqgrid-sortable" id="jqgh_glAccountSelGrid_id">ID<span class="s-ico" style="display:none"><span sort="asc" class="ui-grid-ico-sort ui-icon-asc ui-state-disabled ui-icon ui-icon-triangle-1-n ui-sort-ltr"></span><span sort="desc" class="ui-grid-ico-sort ui-icon-desc ui-state-disabled ui-icon ui-icon-triangle-1-s ui-sort-ltr"></span></span></div></th><th style="width: 98px;" id="glAccountSelGrid_Account" role="columnheader" class="ui-state-default ui-th-column ui-th-ltr"><span style="cursor: col-resize;" class="ui-jqgrid-resize ui-jqgrid-resize-ltr"> </span><div class="ui-jqgrid-sortable" id="jqgh_glAccountSelGrid_Account">Account<span class="s-ico" style="display:none"><span sort="asc" class="ui-grid-ico-sort ui-icon-asc ui-state-disabled ui-icon ui-icon-triangle-1-n ui-sort-ltr"></span><span sort="desc" class="ui-grid-ico-sort ui-icon-desc ui-state-disabled ui-icon ui-icon-triangle-1-s ui-sort-ltr"></span></span></div></th><th style="width: 392px;" id="glAccountSelGrid_Descprition" role="columnheader" class="ui-state-default ui-th-column ui-th-ltr"><span style="cursor: col-resize;" class="ui-jqgrid-resize ui-jqgrid-resize-ltr"> </span><div class="ui-jqgrid-sortable" id="jqgh_glAccountSelGrid_Descprition">Description<span class="s-ico" style="display:none"><span sort="asc" class="ui-grid-ico-sort ui-icon-asc ui-state-disabled ui-icon ui-icon-triangle-1-n ui-sort-ltr"></span><span sort="desc" class="ui-grid-ico-sort ui-icon-desc ui-state-disabled ui-icon ui-icon-triangle-1-s ui-sort-ltr"></span></span></div></th><th style="width: 118px;" id="glAccountSelGrid_Posting" role="columnheader" class="ui-state-default ui-th-column ui-th-ltr"><span style="cursor: col-resize;" class="ui-jqgrid-resize ui-jqgrid-resize-ltr"> </span><div class="ui-jqgrid-sortable" id="jqgh_glAccountSelGrid_Posting">Posting Y/N<span class="s-ico" style="display:none"><span sort="asc" class="ui-grid-ico-sort ui-icon-asc ui-state-disabled ui-icon ui-icon-triangle-1-n ui-sort-ltr"></span><span sort="desc" class="ui-grid-ico-sort ui-icon-desc ui-state-disabled ui-icon ui-icon-triangle-1-s ui-sort-ltr"></span></span></div></th><th style="width: 118px;" id="glAccountSelGrid_PostingStatus" role="columnheader" class="ui-state-default ui-th-column ui-th-ltr"><span style="cursor: col-resize;" class="ui-jqgrid-resize ui-jqgrid-resize-ltr"> </span><div class="ui-jqgrid-sortable" id="jqgh_glAccountSelGrid_PostingStatus">Lvl of Detail<span class="s-ico" style="display:none"><span sort="asc" class="ui-grid-ico-sort ui-icon-asc ui-state-disabled ui-icon ui-icon-triangle-1-n ui-sort-ltr"></span><span sort="desc" class="ui-grid-ico-sort ui-icon-desc ui-state-disabled ui-icon ui-icon-triangle-1-s ui-sort-ltr"></span></span></div></th><th style="width: 146px;" id="glAccountSelGrid_LOD" role="columnheader" class="ui-state-default ui-th-column ui-th-ltr"><span style="cursor: col-resize;" class="ui-jqgrid-resize ui-jqgrid-resize-ltr"> </span><div class="ui-jqgrid-sortable" id="jqgh_glAccountSelGrid_LOD">Posting Status<span class="s-ico" style="display:none"><span sort="asc" class="ui-grid-ico-sort ui-icon-asc ui-state-disabled ui-icon ui-icon-triangle-1-n ui-sort-ltr"></span><span sort="desc" class="ui-grid-ico-sort ui-icon-desc ui-state-disabled ui-icon ui-icon-triangle-1-s ui-sort-ltr"></span></span></div></th></tr></thead></table></div></div><div style="height: 150px; width: 915px;" class="ui-jqgrid-bdiv"><div style="position: relative;"><div></div><table style="width: 897px;" class="ui-jqgrid-btable" aria-labelledby="gbox_glAccountSelGrid" aria-multiselectable="false" role="grid" tabindex="1" id="glAccountSelGrid" border="0" cellpadding="0" cellspacing="0"><tbody><tr class="jqgfirstrow" role="row" style="height: auto;"><td role="gridcell" style="height: 0px; width: 1px; display: none;"></td><td role="gridcell" style="height: 0px; width: 98px;"></td><td role="gridcell" style="height: 0px; width: 392px;"></td><td role="gridcell" style="height: 0px; width: 118px;"></td><td role="gridcell" style="height: 0px; width: 118px;"></td><td role="gridcell" style="height: 0px; width: 146px;"></td></tr><tr id="1" role="row" tabindex="-1" class="ui-widget-content jqgrow ui-row-ltr"><td role="gridcell" aria-describedby="glAccountSelGrid_id" style="display:none;" title="d2e68652-06e3-10e1-b7fd-94e54724019b">d2e68652-06e3-10e1-b7fd-94e54724019b</td><td role="gridcell" aria-describedby="glAccountSelGrid_Account" style="" title="1000">1000</td><td role="gridcell" aria-describedby="glAccountSelGrid_Descprition" style="text-align:left;" title="Cash">Cash</td><td role="gridcell" aria-describedby="glAccountSelGrid_Posting" style="text-align:center;" title="false">false</td><td role="gridcell" aria-describedby="glAccountSelGrid_PostingStatus" style="text-align:center;" title="true">true</td><td role="gridcell" aria-describedby="glAccountSelGrid_LOD" style="text-align:center;" title="LOD 1">LOD 1</td></tr><tr id="2" role="row" tabindex="-1" class="ui-widget-content jqgrow ui-row-ltr"><td role="gridcell" aria-describedby="glAccountSelGrid_id" style="display:none;" title="d2e68652-06e3-11e1-b7fd-94e54724019b">d2e68652-06e3-11e1-b7fd-94e54724019b</td><td role="gridcell" aria-describedby="glAccountSelGrid_Account" style="" title="1001">1001</td><td role="gridcell" aria-describedby="glAccountSelGrid_Descprition" style="text-align:left;" title="Petty Cash">Petty Cash</td><td role="gridcell" aria-describedby="glAccountSelGrid_Posting" style="text-align:center;" title="true">true</td><td role="gridcell" aria-describedby="glAccountSelGrid_PostingStatus" style="text-align:center;" title="true">true</td><td role="gridcell" aria-describedby="glAccountSelGrid_LOD" style="text-align:center;" title="LOD 1">LOD 1</td></tr><tr id="3" role="row" tabindex="-1" class="ui-widget-content jqgrow ui-row-ltr"><td role="gridcell" aria-describedby="glAccountSelGrid_id" style="display:none;" title="d2e68652-06e3-12e1-b7fd-94e54724019b">d2e68652-06e3-12e1-b7fd-94e54724019b</td><td role="gridcell" aria-describedby="glAccountSelGrid_Account" style="" title="1000">1000</td><td role="gridcell" aria-describedby="glAccountSelGrid_Descprition" style="text-align:left;" title="Cashin Farmers Bank and Trust">Cashin Farmers Bank and Trust</td><td role="gridcell" aria-describedby="glAccountSelGrid_Posting" style="text-align:center;" title="true">true</td><td role="gridcell" aria-describedby="glAccountSelGrid_PostingStatus" style="text-align:center;" title="true">true</td><td role="gridcell" aria-describedby="glAccountSelGrid_LOD" style="text-align:center;" title="LOD 1">LOD 1</td></tr><tr id="4" role="row" tabindex="-1" class="ui-widget-content jqgrow ui-row-ltr"><td role="gridcell" aria-describedby="glAccountSelGrid_id" style="display:none;" title="d2e68652-06e3-13e1-b7fd-94e54724019b">d2e68652-06e3-13e1-b7fd-94e54724019b</td><td role="gridcell" aria-describedby="glAccountSelGrid_Account" style="" title="1100">1100</td><td role="gridcell" aria-describedby="glAccountSelGrid_Descprition" style="text-align:left;" title="Investments">Investments</td><td role="gridcell" aria-describedby="glAccountSelGrid_Posting" style="text-align:center;" title="false">false</td><td role="gridcell" aria-describedby="glAccountSelGrid_PostingStatus" style="text-align:center;" title="true">true</td><td role="gridcell" aria-describedby="glAccountSelGrid_LOD" style="text-align:center;" title="LOD 1">LOD 1</td></tr><tr id="5" role="row" tabindex="-1" class="ui-widget-content jqgrow ui-row-ltr"><td role="gridcell" aria-describedby="glAccountSelGrid_id" style="display:none;" title="d2e68652-06e3-14e1-b7fd-94e54724019b">d2e68652-06e3-14e1-b7fd-94e54724019b</td><td role="gridcell" aria-describedby="glAccountSelGrid_Account" style="" title="1101">1101</td><td role="gridcell" aria-describedby="glAccountSelGrid_Descprition" style="text-align:left;" title="Merrel Lynch">Merrel Lynch</td><td role="gridcell" aria-describedby="glAccountSelGrid_Posting" style="text-align:center;" title="true">true</td><td role="gridcell" aria-describedby="glAccountSelGrid_PostingStatus" style="text-align:center;" title="true">true</td><td role="gridcell" aria-describedby="glAccountSelGrid_LOD" style="text-align:center;" title="LOD 1">LOD 1</td></tr><tr id="6" role="row" tabindex="-1" class="ui-widget-content jqgrow ui-row-ltr "><td role="gridcell" aria-describedby="glAccountSelGrid_id" style="display:none;" title="d2e68652-06e3-15e1-b7fd-94e54724019b">d2e68652-06e3-15e1-b7fd-94e54724019b</td><td role="gridcell" aria-describedby="glAccountSelGrid_Account" style="" title="1200">1200</td><td role="gridcell" aria-describedby="glAccountSelGrid_Descprition" style="text-align:left;" title="Inventories Raw Materials-All Departments">Inventories Raw Materials-All Departments</td><td role="gridcell" aria-describedby="glAccountSelGrid_Posting" style="text-align:center;" title="false">false</td><td role="gridcell" aria-describedby="glAccountSelGrid_PostingStatus" style="text-align:center;" title="true">true</td><td role="gridcell" aria-describedby="glAccountSelGrid_LOD" style="text-align:center;" title="LOD 1">LOD 1</td></tr><tr id="7" role="row" tabindex="-1" class="ui-widget-content jqgrow ui-row-ltr "><td role="gridcell" aria-describedby="glAccountSelGrid_id" style="display:none;" title="d2e68652-06e3-16e1-b7fd-94e54724019b">d2e68652-06e3-16e1-b7fd-94e54724019b</td><td role="gridcell" aria-describedby="glAccountSelGrid_Account" style="" title="1201">1201</td><td role="gridcell" aria-describedby="glAccountSelGrid_Descprition" style="text-align:left;" title="Notes Reciveables Officers">Notes Reciveables Officers</td><td role="gridcell" aria-describedby="glAccountSelGrid_Posting" style="text-align:center;" title="true">true</td><td role="gridcell" aria-describedby="glAccountSelGrid_PostingStatus" style="text-align:center;" title="true">true</td><td role="gridcell" aria-describedby="glAccountSelGrid_LOD" style="text-align:center;" title="LOD 1">LOD 1</td></tr><tr id="8" role="row" tabindex="-1" class="ui-widget-content jqgrow ui-row-ltr "><td role="gridcell" aria-describedby="glAccountSelGrid_id" style="display:none;" title="d2e68652-06e3-17e1-b7fd-94e54724019b">d2e68652-06e3-17e1-b7fd-94e54724019b</td><td role="gridcell" aria-describedby="glAccountSelGrid_Account" style="" title="1202">1202</td><td role="gridcell" aria-describedby="glAccountSelGrid_Descprition" style="text-align:left;" title="Notes Reciveables Employees">Notes Reciveables Employees</td><td role="gridcell" aria-describedby="glAccountSelGrid_Posting" style="text-align:center;" title="true">true</td><td role="gridcell" aria-describedby="glAccountSelGrid_PostingStatus" style="text-align:center;" title="true">true</td><td role="gridcell" aria-describedby="glAccountSelGrid_LOD" style="text-align:center;" title="LOD 1">LOD 1</td></tr><tr id="9" role="row" tabindex="-1" class="ui-widget-content jqgrow ui-row-ltr "><td role="gridcell" aria-describedby="glAccountSelGrid_id" style="display:none;" title="d2e68652-06e3-18e1-b7fd-94e54724019b">d2e68652-06e3-18e1-b7fd-94e54724019b</td><td role="gridcell" aria-describedby="glAccountSelGrid_Account" style="" title="1300">1300</td><td role="gridcell" aria-describedby="glAccountSelGrid_Descprition" style="text-align:left;" title="Inventories">Inventories</td><td role="gridcell" aria-describedby="glAccountSelGrid_Posting" style="text-align:center;" title="false">false</td><td role="gridcell" aria-describedby="glAccountSelGrid_PostingStatus" style="text-align:center;" title="true">true</td><td role="gridcell" aria-describedby="glAccountSelGrid_LOD" style="text-align:center;" title="LOD 1">LOD 1</td></tr><tr id="10" role="row" tabindex="-1" class="ui-widget-content jqgrow ui-row-ltr"><td role="gridcell" aria-describedby="glAccountSelGrid_id" style="display:none;" title="d2e68652-06e3-19e1-b7fd-94e54724019b">d2e68652-06e3-19e1-b7fd-94e54724019b</td><td role="gridcell" aria-describedby="glAccountSelGrid_Account" style="" title="1301">1301</td><td role="gridcell" aria-describedby="glAccountSelGrid_Descprition" style="text-align:left;" title="Inventories Raw Dept1">Inventories Raw Dept1</td><td role="gridcell" aria-describedby="glAccountSelGrid_Posting" style="text-align:center;" title="true">true</td><td role="gridcell" aria-describedby="glAccountSelGrid_PostingStatus" style="text-align:center;" title="true">true</td><td role="gridcell" aria-describedby="glAccountSelGrid_LOD" style="text-align:center;" title="LOD 1">LOD 1</td></tr><tr id="11" role="row" tabindex="-1" class="ui-widget-content jqgrow ui-row-ltr"><td role="gridcell" aria-describedby="glAccountSelGrid_id" style="display:none;" title="d2e68652-06e3-20e1-b7fd-94e54724019b">d2e68652-06e3-20e1-b7fd-94e54724019b</td><td role="gridcell" aria-describedby="glAccountSelGrid_Account" style="" title="1302">1302</td><td role="gridcell" aria-describedby="glAccountSelGrid_Descprition" style="text-align:left;" title="Inventories Raw Dept2">Inventories Raw Dept2</td><td role="gridcell" aria-describedby="glAccountSelGrid_Posting" style="text-align:center;" title="true">true</td><td role="gridcell" aria-describedby="glAccountSelGrid_PostingStatus" style="text-align:center;" title="true">true</td><td role="gridcell" aria-describedby="glAccountSelGrid_LOD" style="text-align:center;" title="LOD 1">LOD 1</td></tr><tr id="12" role="row" tabindex="-1" class="ui-widget-content jqgrow ui-row-ltr"><td role="gridcell" aria-describedby="glAccountSelGrid_id" style="display:none;" title="d2e68652-06e3-21e1-b7fd-94e54724019b">d2e68652-06e3-21e1-b7fd-94e54724019b</td><td role="gridcell" aria-describedby="glAccountSelGrid_Account" style="" title="1303">1303</td><td role="gridcell" aria-describedby="glAccountSelGrid_Descprition" style="text-align:left;" title="Inventories Raw Dept3">Inventories Raw Dept3</td><td role="gridcell" aria-describedby="glAccountSelGrid_Posting" style="text-align:center;" title="true">true</td><td role="gridcell" aria-describedby="glAccountSelGrid_PostingStatus" style="text-align:center;" title="false">false</td><td role="gridcell" aria-describedby="glAccountSelGrid_LOD" style="text-align:center;" title="LOD 1">LOD 1</td></tr></tbody></table></div></div></div><div class="ui-jqgrid-resize-mark" id="rs_mglAccountSelGrid"> </div><div dir="ltr" class="ui-state-default ui-jqgrid-pager ui-corner-bottom" style="width: 915px;" id="pager"><div id="pg_pager" class="ui-pager-control" role="group"><table class="ui-pg-table" style="width: 100%; table-layout: fixed; height: 100%;" role="row" border="0" cellpadding="0" cellspacing="0"><tbody><tr><td id="pager_left" align="left"></td><td id="pager_center" style="white-space: pre; width: 218px;" align="center"><table style="table-layout:auto;" class="ui-pg-table" border="0" cellpadding="0" cellspacing="0"><tbody><tr><td id="first_pager" class="ui-pg-button ui-corner-all ui-state-disabled"><span class="ui-icon ui-icon-seek-first"></span></td><td id="prev_pager" class="ui-pg-button ui-corner-all ui-state-disabled"><span class="ui-icon ui-icon-seek-prev"></span></td><td class="ui-pg-button ui-state-disabled" style="width:4px;"><span class="ui-separator"></span></td><td dir="ltr">Page <input class="ui-pg-input" size="2" maxlength="7" value="0" role="textbox" type="text"> of <span id="sp_1_pager">0</span></td><td class="ui-pg-button ui-state-disabled" style="width:4px;"><span class="ui-separator"></span></td><td id="next_pager" class="ui-pg-button ui-corner-all"><span class="ui-icon ui-icon-seek-next"></span></td><td id="last_pager" class="ui-pg-button ui-corner-all"><span class="ui-icon ui-icon-seek-end"></span></td></tr></tbody></table></td><td id="pager_right" align="right"></td></tr></tbody></table></div></div></div>

</div>

All RSS

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
60 Guest(s)

Currently Browsing this Page:
1 Guest(s)