Hi,
I had the same problem and I solved that problem. Here is my code you can verify that and you will able to know your fault.
<script type="text/javascript" language="javascript">
$(document).ready(function () {
try {
$("#tableGroup").jqGrid({
height: 'auto',
width: 'auto',
contentType: 'application/json; charset=utf-8',
mtype: 'POST',
url: 'Project.aspx',
datatype: 'json',
postData: {
id: function () { return 'jqGrid'; },
date: function () { return jQuery("#<%=hfDate.ClientID%>").val(); },
userName: function () { return jQuery("#<%=hfUserName.ClientID%>").val(); }
},
jsonReader: {
root: "rows",
page: "page",
total: "total",
records: "records",
repeatitems: true,
cell: "cell",
id: "id",
userdata: "userdata"
},
colNames: ['Name', 'ProjectName', 'ProjectBA', 'ProjectAD', 'PriorityOrder', 'JIRA#', 'Title', 'Priority', 'Complexity', 'Status',
'Clarity', 'InitialEstimate', 'RemainingEstimate', 'TimeSpent', 'OverallProject%', 'Comments', ''],
colModel: [
{ name: 'Name', index: 'Name', width: 120, sortable: true, editable: true, resizable: true, hidden: false },
{ name: 'ProjectName', index: 'ProjectName', width: 100, align: "left", sortable: true, editable: true, resizable: true, hidden: false },
{ name: 'ProjectBA', index: 'ProjectBA', width: 100, align: "left", sortable: true, editable: true, resizable: true, hidden: false },
{ name: 'ProjectAD', index: 'ProjectAD', width: 100, align: "left", sortable: true, editable: true, resizable: true, hidden: false },
{ name: 'PriorityOrder', index: 'PriorityOrder', sorttype: Number, width: 100, sortable: false, editable: false, resizable: false, hidden: false },
{ name: 'JIRA#', index: 'JIRA#', width: 100, sorttype: Number, align: "left", sortable: true, editable: true, resizable: true, hidden: false },
{ name: 'Title', index: 'Title', width: 150, align: "left", sortable: true, editable: true, resizable: true, hidden: false },
{ name: 'Priority', index: 'Priority', width: 50, align: "left", sortable: false, editable: true, resizable: true, hidden: false },
{ name: 'Complexity', index: 'Complexity', width: 50, align: "left", sortable: false, editable: true, resizable: true, hidden: false },
{ name: 'Status', index: 'Status', width: 50, align: "left", sortable: false, editable: true, resizable: true, hidden: false },
{ name: 'Clarity', index: 'Clarity', width: 50, align: "left", sortable: false, editable: true, resizable: true, hidden: false },
{ name: 'InitialEstimate', index: 'InitialEstimate', width: 50, align: "left", sortable: false, editable: false, resizable: true, hidden: false },
{ name: 'RemainingEstimate', index: 'RemainingEstimate', width: 50, align: "left", sortable: false, editable: false, resizable: true, hidden: false },
{ name: 'TimeSpent', index: 'TimeSpent', width: 50, align: "left", sortable: false, editable: false, resizable: true, hidden: false },
{ name: 'OverallProject%', index: 'OverallProject%', width: 50, align: "left", sortable: false, editable: false, resizable: true, hidden: false },
{ name: 'Comments', index: 'Comments', width: 200, align: "left", sortable: true, editable: true, resizable: true, hidden: false },
{ name: 'ProjectID', index: 'ProjectID', width: 75, sortable: true, editable: false, resizable: true, hidden: true }
],
rowNum: 30,
rowList: [10, 15, 20, 30, 50, 100, 200, 300, 500, 750, 1000],
pager: $('#divGroupPager'),
sortname: 'ProjectName',
sortorder: "desc",
loadtext: "Loading....",
autowidth: false,
shrinkToFit: false,
emptyrecords: "No matching records to view",
rownumbers: false,
loadonce: true,
gridComplete: function () {
},
rownumWidth: 30,
toolbar: [true, "both"],
recordpos: 'left',
viewrecords: true,
caption: "DSR Report"
});
$("#tableGroup").jqGrid('navGrid', '#divGroupPager', { edit: true, add: false, del: false, excel: true });
} catch (e) {
alert(e);
}
});
</script>
Thanks