3,500 rows...maxJsonLength hit!

[Carmine]

Have a rather simple grid with a dozen or so columns, three of which have server and client templates (since I'm sending down all data at once...don't want to have more requests for sorting, paging, etc.).

Above 3,500 rows or so I get the dreaded:

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

So, short of modifying the core Telerik code, is there any way I can use this grid? I can get unlimited rows using SlickGrid and such, but I would dearly love Telerik to work. Any thoughts?

Thanks,
Cimeran

[Steve]

You can configure the max length for json requests in your web.config file:

<configuration> 
    <system.web.extensions> 
        <scripting> 
            <webServices> 
                <jsonSerialization maxJsonLength="...."> 
                </jsonSerialization> 
            </webServices> 
        </scripting> 
    </system.web.extensions> 
</configuration> 

The default value for maxJsonLength is 102400. For more details, see this MSDN page: http://msdn.microsoft.com/en-us/library/bb763183.aspx

if, after implementing the above addition into your web.config, you get an “Unrecognized configuration section system.web.extensions.” error then try adding this to your web.config in the <ConfigSections> section:

        <sectionGroup name="system.web.extensions" type="System.Web.Extensions"> 
              <sectionGroup name="scripting" type="System.Web.Extensions"> 
                    <sectionGroup name="webServices" type="System.Web.Extensions"> 
                          <section name="jsonSerialization" type="System.Web.Extensions"/> 
                    </sectionGroup> 
              </sectionGroup> 
        </sectionGroup> 

Source: http://stackoverflow.com/questions/1151987/unlimited-for-maxjsonlength

[Carmine]

I've made those changes in web.config, but in MVC applications that setting is ignored. I could roll a custom ActionResult, but to use it I would have to modify the Telerik core files. Any other options? I can't seem to find any.

Carmine

[Iakov]

As a solution, I have modified Telerik.Web.Mvc.UI.GridActionResultFactory class to the following:

class GridActionResultFactory : IGridActionResultFactory
{
    public ActionResult Create(object model)
    {
        JavaScriptSerializer serializer = new JavaScriptSerializer();
        serializer.MaxJsonLength = Int32.MaxValue;
        string serializedData = serializer.Serialize(model);

        return new ContentResult()
        {
            Content = serializedData,
            ContentType = "application/json"
        };

    }
}

After that,  in my project I have replaced the default Telerik.Web.Mvc assembly with the customized one.

[David]

Look at my post: http://www.telerik.com/community/forums/aspnet-mvc/grid/multiple-data-rows-result-problem.aspx there is a better solution of this problem...