using datatable.js

chandru

9y920

i have a html table which have n number of columns

now i fetch the column headers include hidden columns which are sortable true;

those all are making as a button event so, each column have one button

when i am clicking the button, the table should be sortable based on the button(column)click and it should save the order.

please help me out how to achieve....

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rathrola Prem Kumar9y ago
have you added this line in your datatable jquery
"order": [[0, "asc"]],
Prasath Balakrishnan9y ago
Hi Chandru,

You can use the below 'datatable' code for each and every column header has an option to sort the column data by clicking them. Alter the code according to your needs.Hope the below code will works fine and let me know once its done.
$('#TableId').DataTable({
           "ajax": {
               "url": '@Url.Action("MethodName","ControllerName")',
                   "type": "GET",
                   "datatype": "json",
                   "async":false,
               },
               "columns": [
                    {"data": "Column1"},
                    { "data": "Column2" },
                    { "data": "Column3" },
                    { "data": "Column4" }

               ],
               "columnDefs": [{ "orderable": false, "targets": -1 }],
               "order": [[0, "asc"]],
               dom: '<"exportbuttons"B>lTfgitp',

           });
Ramesh Palanivel9y ago
Hi Chandru,

I am not very clear in your question.

Do you want to create data table with sorted columns?