maitopoika on Help with Jqgrid and Asp.Net MVC 2

Tue, 11 May 2010 20:14:47 +0300

When I load the page the grid just says loading, and that never goes away. I can put a break point in my controller that the gird is bound to, and it does hit the controller and I can step through the controller getting all the correct data I would expect and goes through the return statement.
But the grid never shows the data and the loading graphic never goes away.
Any Ideas?
here is my grid

       url:'PurchasingReceiving/JsonOpenPO',
       datatype: 'json',
       mtype: 'GET',
       altRows: 'true',
       colNames: ['POnum','OrderDate','Company','ChangeBy'],
       colModel: [
                         { name: 'POnum', index: 'POnum', width: 200, align: 'left' },
                         { name: 'OrderDate', index: 'OrderDate', width: 200, align: 'left' },
                         { name: 'Company', index: 'Company', width: 200, align: 'left' },
                          { name: 'ChangeBy', index: 'ChangeBy', width: 200, align: 'left' },
                           ],
       pager: jQuery('#OpenPOPager'),
       rowNum: 20,
       rowList: [5, 10, 20, 50],
       sortname: 'Id',
       sortorder: "desc",
       viewrecords: true,
       height: '200px'

   }); //end jQuery("#ScheduledL
</script>

And here is the controller

public ActionResult JsonOpenPO(string sidx, string sord, int page, int rows)
        {

            PurchaseOrderService srv = new PurchaseOrderService();
            List<PurchaseOrder> context = new List<PurchaseOrder>();
            try
            {
                context = srv.GetOpenPurchaseOrders();
            }
            catch (Exception ex)
            {
                string x = ex.Message;
                log.Error(ex.Message, ex);

}

            int pageIndex = Convert.ToInt32(page) - 1;
            int pagesize = rows;
            int totalrecords = context.Count();
            int totalPages = (int)Math.Ceiling((float)totalrecords / (float)pagesize);
            string orderBy = string.Format("{0} {1}", sidx, sord);
            var POs = context.AsQueryable()
                            .OrderBy(orderBy)
                            .Skip(pageIndex * pagesize)
                            .Take(pagesize);

            //format data for the grid
            var jsondata = new
            {
                total = totalPages,
                page = page,
                records = totalrecords,
                rows = (from s in POs
                        select new
                        {
                            cell = new string[]{
                                s.POnum,
                                s.OrderDate.ToShortDateString(),
                                s.Company,
                                s.ChangeBy
                             }
                        }).ToArray()
            };

return Json(jsondata, JsonRequestBehavior.AllowGet);
}

jQuery Grid Plugin - jqGrid - Topic: Help with Jqgrid and Asp.Net MVC 2

maitopoika on Help with Jqgrid and Asp.Net MVC 2