21 DataTables Change Options

1. To disable sorting on the fourth column, give the targets the value 3. The first column is 0.

$('#employeesTable').dataTable( {
  "columnDefs": [
    { "orderable": false, "targets": 3 }
  ]
} );

2. The last column is also indicated by the index -1

$('#employeesTable').dataTable( {
  "columnDefs": [
    { "orderable": false, "targets": -1 }
  ]
} );

3. To disable ordering on multiple columns

$('#employeesTable').dataTable( {
  "columnDefs": [
    { "orderable": false, "targets": [1, 3] }
  ]
} );

4. To enable horizontal scrolling

$('#example').dataTable( {
  "scrollX": true
} );

5 To enable vertical scrolling with pagination disabled

$('#example').dataTable( {
  "scrollY": "200px",
  "scrollCollapse": true,
  "paging": false,
  "columnDefs": [{ "orderable": false, "targets": 3 }]
} );

6. Example: Check the view /Views/Employee/Index.cshtml

7. References:DataTables Examples