How Many Columns Can I add from DataTable by aoColumns?

How Many Columns Can I add from DataTable by aoColumns?

chelseajcolechelseajcole Posts: 12Questions: 0Answers: 0
edited July 2011 in General
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?

Replies

  • patriklindstrompatriklindstrom Posts: 15Questions: 0Answers: 0
    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.
  • allanallan Posts: 61,451Questions: 1Answers: 10,055 Site admin
    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
  • patriklindstrompatriklindstrom Posts: 15Questions: 0Answers: 0
    edited December 2011
    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
This discussion has been closed.