Autocomplete Column with Huge Data is causing maxJsonLength error in JSON JavaScriptSerializer

[Reginald]

When setting datasource for column in codebehind, I use the following vb.net code :

GrdTransMain.Columns(3).DataSource = LstItems

It works fine but when LstItems is a huge data, I get maxjsonLengthe serialization error.

How can I set grid column datasource with huge data?

[Farveen Sulthana Thameeztheen Basha]

Hi Reginald, 

Thanks for contacting Syncfusion Support. 

Query#:- How can I set grid column datasource with huge data? 

We have checked your query and we have already discussed about this problem in our Syncfusion Knowledge Base documentation. Please refer to the KB link:- 

https://www.syncfusion.com/kb/3063/script-error-throws-for-exceeding-maxjson-length-while-performing-serialization-or-deserialization 

Please get back to us if you need any further assistance. 

Regards, 

Farveen sulthana T 

[Reginald]

Hi Reginald, 

Thanks for contacting Syncfusion Support. 

Query#:- How can I set grid column datasource with huge data? 

We have checked your query and we have already discussed about this problem in our Syncfusion Knowledge Base documentation. Please refer to the KB link:- 

https://www.syncfusion.com/kb/3063/script-error-throws-for-exceeding-maxjson-length-while-performing-serialization-or-deserialization 

Please get back to us if you need any further assistance. 

Regards, 

Farveen sulthana T 

The link you posted discusses how to bind large data to GRID.

My case is different, I wand to bind large data to COLUMN.

I read the link you posted more than 10 times trying to adapt it for my case but I could not and I had to create this thread.

Can you please show me how to bind large data to a COLUMN of a Grid?

[Padmavathy Kamalanathan]

Hi Reginald,

Thanks for your update. As we have suggested in our last update, you can use load on demand to bind data source to grid's column also. We suggest you to use RemoteSave Adaptor with offline property set to true and use "DataSource" property for the binding data to column.

Please refer the below help documentation,

https://help.syncfusion.com/aspnet/datamanager/data-adaptors#remotesave-adaptor

If you have further queries, please get back to us.

Regards,

Padmavathy Kamalanathan

[Reginald]

Thank you so much for your support.

[Padmavathy Kamalanathan]

Hi Reginald,

Thanks for your update. If you have further queries, please get back to us.

Regards,

Padmavathy Kamalanathan