[KlocMember]

Peter,

That looks like exactly what I’m looking for.  Thanks for the response and the quick update!

Thanks!

[KlocMember]

Thanks for the reply but I am still having issues. I tried your code in a new project and everything worked fine so I’m not sure why it’s not working when I try to implement it within my code. Here is part of my LargeJsonResult when I download it.

[{“CPT1″:”01844″,”MOD”:null,”SDESC”:”Anesth vascular shunt surg”,”FAGE”:0,”TAGE”:0},
{“CPT1″:”01844″,”MOD”:null,”SDESC”:”Anesth vascular shunt surg”,”FAGE”:0,”TAGE”:0},
{“CPT1″:”01844″,”MOD”:null,”SDESC”:”Anesth vascular shunt surg”,”FAGE”:0,”TAGE”:0},
{“CPT1″:”01844″,”MOD”:null,”SDESC”:”Anesth vascular shunt surg”,”FAGE”:0,”TAGE”:0},
{“CPT1″:”01900″,”MOD”:null,”SDESC”:”Anes- inj proc hysterosalpingography (Deleted 12/31/99)”,”FAGE”:0,”TAGE”:0},{“CPT1″:”01900″,”MOD”:null,”SDESC”:”Anes- inj proc hysterosalpingography (Deleted 12/31/99)”,”FAGE”:0,”TAGE”:0},

I have nullable and double fields, is this what might be causing the problem? Here is my new script.

$(document).ready(function () {
// prepare the data

var datafields = [
{ name: 'CPT1'},
{ name: 'MOD'},
{ name: 'SDESC'},
{ name: 'FAGE'},
{ name: 'TAGE'}];

// get data records.
var source = {
datatype: "json",
datafields: datafields,
url: 'dbCPT/GetCustomers'
};
var dataAdapter = new $.jqx.dataAdapter(source, { async: false, autoBind: true });
var records = dataAdapter.records;

$("#jqxgrid").jqxGrid({
source: { datafields: datafields, totalrecords: records.length },
theme: 'classic',
virtualmode: true,
rendergridrows: function (params) {
var start = params.startindex;
var end = params.endindex;
var array = new Array();
for (i = start; i < end; i++) {
array[i] = records[i];
}
return array;
}, columns: [{ text: 'CPT Code', datafield: 'CPT1', width: 250 },
{ text: 'Modifiers', datafield: 'MOD', width: 150 },
{ text: 'Short Description', datafield: 'SDESC', width: 180 },
{ text: 'From Age', datafield: 'FAGE', width: 200 },
{ text: 'To Age', datafield: 'TAGE', width: 120}]
});
});

My controller


public class dbCPTController : Controller
{
private dbCPTEntities db = new dbCPTEntities();

public ViewResult Index()
{
return View(db.CPTs.ToList());
}

public LargeJsonResult GetCustomers()
{
var dbResult = db.CPTs.ToList();
var customers = from customer in dbResult

select new
{
customer.CPT1,
customer.MOD,
customer.SDESC,
customer.FAGE,
customer.TAGE
};
return new LargeJsonResult { Data = customers, JsonRequestBehavior = System.Web.Mvc.JsonRequestBehavior.AllowGet };
}
}


Any help would be appreciated!

[Author]

Posts