Data is now being shown. This should have been included.

jsonReader: {

repeatitems: false,

id: "0"

},

However when the data is being loaded the total page numbers is 1 and I cannot move from one page to the next.

I am trying to use this grid with ASP.NET MVC with no apparent luck. It is giving me undefined is null when the grid is trying to load and data is not shown.

I am using this code.

For the controller I am using : 

StockControlBL.Products pr = new StockControlBL.Products();

List<StockControlDB.Product> products = (from p in pr.GetProducts()

select new StockControlDB.Product { ProductCode = p.ProductCode, ProductDescription = p.ProductDescription, ProductName = p.ProductName, ProductStockQty = p.ProductStockQty }).ToList<StockControlDB.Product>();

var data = products.ToPagedList(0, 10);

var productsJSON = new

{

total = data.PageCount-1,

records=data.TotalItemCount,

page = data.PageIndex,

rows = data

};

if (Request.IsAjaxRequest())

return Json(productsJSON, JsonRequestBehavior.AllowGet);

else

return View();

}

Then for the javascript I am using

<link href="/Content/ui-lightness/jquery-ui-1.8.5.custom.css" rel="stylesheet" type="text/css" />

<link href="/Content/ui.jqgrid.css" rel="stylesheet" type="text/css" />

<script type="text/javascript" src="/Scripts/jquery-1.4.2.min.js"></script>

<script type="text/javascript" src="/Scripts/jgrid/jquery.jqGrid.min.js"></script>

<script type="text/javascript" src="/Scripts/jgrid/jqModal.js"></script>

<script type="text/javascript" src="/Scripts/jgrid/jqDnR.js"></script>

 <script type="text/javascript">

$(document).ready(function () {

$("#list3").jqGrid({

url: '/Products/ProductsList',

datatype: "json",

mtype:"GET",

colNames: ['Code', 'Name', 'Description', 'Stock Qty'],

colModel: [

{ name: 'ProductCode', index: 'code', width: 60, sorttype: "string" },

{ name: 'ProductName', index: 'name', width: 90, sorttype: "string" },

{ name: 'ProductDescription', index: 'description', width: 100 },

{ name: 'ProductStockQty', index: 'qty', width: 80, align: "right", sorttype: "float" },

],

rowNum: 10,

rowList: [10, 20, 30],

pager: '#pager3',

page:'1',

sortname: 'ProductCode',

viewrecords: true,

sortorder: "desc",

loadonce: true,

caption: "Products"

});

});