Forum


14:31

09/10/2010

Guys
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"
});
});
Most Users Ever Online: 715
Currently Online:
60 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
OlegK: 1255
markw65: 179
kobruleht: 144
phicarre: 132
YamilBracho: 124
Renso: 118
Member Stats:
Guest Posters: 447
Members: 11373
Moderators: 2
Admins: 1
Forum Stats:
Groups: 1
Forums: 8
Topics: 10592
Posts: 31289
Newest Members:
, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.comModerators: tony: 7721, Rumen[Trirand]: 81
Administrators: admin: 66