How to get column config of DataTable and feed it to DataTable dynamically ?

farhadtable

Before, in our old application we are using JQGrid free, as far as I am aware there are a lot's of feture in JQGrid that we can see some of them in DataTable,
before we are saving column state of jqgrid per users in DB and read back it while users get log-in,
now we migrate to DataTable but some feature are not easy to use ,
so my main issue is saving column state in DB and read it back to render, is there a way to get column config of DataTable and feed it to DataTable dynamically not static,ordering,visibility and so on...

allan

Hi,

Thanks for your question. This is actually one that is in the FAQs:

Q. Can I define my columns in Ajax loaded JSON?

The reason you can't currently do that using DataTables' configuration options is that JSON doesn't support Javascript functions, and thus you wouldn't be able to make use of all of the features of DataTables. Having said that, if you are happy with that fact, its just an extra line to use $.ajax to get the information from the server!

Allan

farhadtable

In fact, we now need to make this features ..
Please write to me a solutions

farhadtable

Is there a dll file in asp lib ?

allan

The method that the FAQ describes is exactly how you would do it:

$.ajax( {
  url: ...
  success: function ( json ) {
    $('#myTable').DataTable( {
      columns: json.columns,
      data: json.data
     } );
  }
} );

Is there a dll file in asp lib ?

The dll provided in the Editor .NET download is CLR, so it would work in ASP as well as the C# that it was originally written in.

Allan