Error during serialization or deserialization using the JSON JavaScriptSerializer. MVC Kendo Grid Binding

Question

I am Binding data to Kendo grid using Ienumerable not with Json Data .

Am Getting this Error : Error during serialization or deserialization using the JSON JavaScriptSerializer. The length of the string exceeds the value set on the maxJsonLength property.

Even after tried with setting below maxjsonlength in web.config

<system.web.extensions>
<scripting>
  <webServices>

    <jsonSerialization maxJsonLength="2147483647" />
  </webServices>
</scripting>

Here is my kendo Grid

@model IEnumerable<AssetTrackingSystem.Model.SampleDetailsSummary>
    @(Html.Kendo().Grid(Model)
.Name("Grid")
.Columns(columns=>
{
    columns.Bound(p => p.JobNumber).Title("Job Number").Width("125px");
    columns.Bound(p => p.SampleNumber).Template(@<text></text>).ClientTemplate("<a href='" + Url.Action("SampleDetails", "JobDetails", new { AssetId = "#=AssetId#" }) + "'>#=SampleNumber#</a>").Title("Sample Number").Width("125px");
    columns.Bound(p => p.SampleType).Title("Sample Type").Width("125px");
    columns.Bound(p => p.ServiceVendor).Title("Service Vendor").Width("125px");
    columns.Bound(p => p.BarCode).Title("Barcode").Width("125px");
    columns.Bound(p => p.LocationName).Title("Current Location").Width("125px");
    columns.Bound(p => p.GPS).Title("GPS").Width("125px");     
}).Pageable().Sortable().Scrollable(scr => scr.Height(scroolheight)).Filterable().Pageable(pageable => pageable
       .Refresh(true)
       .PageSizes(true)
       .ButtonCount(5)).DataSource(dataSource => dataSource
   .Ajax()
   .PageSize(50)
   .ServerOperation(false)
   .Model(model => model.Id(p => p.AssetId))
)

Here is my controller action Method

   public ActionResult CompanyAssets()
    {
        Guid CompanyId = new Guid(Request.Params["CompanyId"].ToString());
        int GPSOnly = int.Parse(Request.Params["Gps"]);
        //bool GPSOnly = GPSOnly1.Equals("1") ? true : false;
        JobDetailsRepository rep = new JobDetailsRepository(Session["Connectionstring"].ToString());
        //   IList<AssetDetails> assetinfo = rep.GetAssetsByCompanyId(CompanyId);

        IList<SampleDetailsSummary> assetinfo = rep.GetAllSamplesByCompanyId(CompanyId, GPSOnly);
        CompanyRepository cmprep = new CompanyRepository(Session["Connectionstring"].ToString());
        // IList<CompanyInfoSummary> s = cmprep.GetLocationsByCompanyId(CompanyId);
        var company = cmprep.GetCompany(CompanyId);
        ViewBag.companyName = company.CompanyName;
        var model = assetinfo;
        return View(model);
    }

Can any one please help me through this am trying to fix these spending 24 hours

JamieD77 · Accepted Answer · 2015-10-09 14:05:22Z

2

Your issue might be that you're binding your grid to an object that has a circular reference..

for example..

public class Employee 
{
    public Company Company {get;set}
}
public class Company
{
    public Employee Owner { get; set}
}

the serializer will get stuck in an infinite loop here since employee has a company and company has an employee.

another issue could be the size of your IEnumerable<AssetTrackingSystem.Model.SampleDetailsSummary> is so large that is just exceeds the max length allowed.

the best way to avoid this with Kendo is to create View Models and bind your grid to those instead of actual database entities.

If SampleDetailsSummary only had the fields you're displaying in the grid and you can't make it any smaller by eliminating extra properties, then you should look into using the actual ajax functionality and doing paging server side.

edited Oct 9, 2015 at 14:05

answered Oct 9, 2015 at 13:54

JamieD77

14k1 gold badge19 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Error during serialization or deserialization using the JSON JavaScriptSerializer. MVC Kendo Grid Binding

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related