asp.net mvc 3 - Unable to load the jquery grid on post in mvc3 -
i have 2 views , first index displaying jquery grid. second entry page customer after insertion redirect index() in controller again onload grid not displayed,below jquery function grid jquerygrid code
<script type="text/javascript"> $(document).ready(function () { search(); }); function search() { var jqdataurl = "queuemgmt/loaddata"; var reportname = "wallboard"; $("#jqtable").jqgrid({ url: jqdataurl, datatype: "json", mtype: "post", postdata: { }, colnames: ["queue", "ciq", "avail", "staff"], colmodel: [ { name: "queue_no", index: "queue_no", align: "left" }, { name: "ciq", index: "ciq", align: "left" }, { name: "avail", index: "avail", align: "left" }, { name: "staff", index: "staff", align: "left" } ], autowidth: true, viewrecords: true, sortname: "queue_no", sortorder: "asc", caption: reportname, onselectrow: function (id) { rowselected(id); } }); $("#jqtable").parents('div.ui-jqgrid-bdiv'); } </script>
controller code:
public actionresult loaddata(string sidx, string sord, int page, int rows) { try { // list var configs = mmdataprocess.select().asqueryable(); var filteredconfigs = configs; // sort list var sortedconfigs = sortiqueryable<queuemgmtmodel>(filteredconfigs, sidx, sord); // calculate total number of pages var totalrecords = filteredconfigs.count(); var totalpages = (int)math.ceiling((double)totalrecords / (double)rows); // prepare data fit requirement of jqgrid var data = (from s in sortedconfigs select new { id = s.queue_no, cell = new object[] {s.queue_no,s.ciq,s.avail,s.staff} }).toarray(); // send data jqgrid var jsondata = new { total = totalpages, page = page, records = totalrecords, rows = data.skip((page - 1) * rows).take(rows) }; return json(jsondata); } catch (exception ex) { } return null; }
since new mvc ,kindly me resolve issue.
use bellow in controller return statement
return json(jsondata,jsonrequestbehavior.allowget);
Comments
Post a Comment