How Many Columns Can I add from DataTable by aoColumns?

chelseajcole

I am using aoColumns to add more columns from my datatable to show in the browser, when I add more than 30 columns, it give me an error:

the length of the query string for this request exceeds the configured maxQueryStringLength value.

Is there and limitation on how many columns can I add?

patriklindstrom

I have 29 to 31 columns and I get the same Error. I have read about it here. http://learn.iis.net/page.aspx/143/use-request-filtering/
http://mvcscriptmanager.codeplex.com/workitem/5263
and made the changes:










But it does no work. I have tryed it in IIS 7.5 and IIS Express on win7 64 bit system.

allan

This thing to do here is to use POST rather than GET: http://datatables.net/release-datatables/examples/server_side/post.html (it's easier with 1.9, which is currently in beta: http://datatables.net/beta/1.9/examples/server_side/post.html ).

Regards,
Allan

patriklindstrom

Aha. That could also solve this old secuirty risk that I think exist in IE7 (wich I am forced to adopt for)
They talk about it here http://haacked.com/archive/2008/11/20/anatomy-of-a-subtle-json-vulnerability.aspx
and here its now default not ta allow GET for JSon in mvc you have to set JsonRequestBehavior to AllowGet
http://haacked.com/archive/2009/06/25/json-hijacking.aspx