datatables sorting order code example

Example 1: datatables sorting order

// 3 is the column index, starting from 0 at the leftmost
$('#table').DataTable( {
   order: [[ 3, "desc" ]] // or "asc" for ascending
} );

// to sort on multiple rows
$('#example').DataTable( {
	order: [[ 3, 'desc' ], [ 0, 'asc' ]]
} );

// if using legacy datatables (initialization with lowercase dataTable)
aaSorting: [[3, "desc"]]

Example 2: sort datatable c#

Datatable.DefaultView.Sort = "Preferance ASC";

Example 3: sorting number with coma datatable

<script type="text/javascript" src="jquery.dataTables.js"></script>
<script type="text/javascript" src="dataTables.numericComma.js"></script>
<script type="text/javascript">    
	$(document).ready(function() {        
  		$('#example').dataTable( { 
          "columnDefs": [
            { "type": "numeric-comma", targets: 3 }
          ]        
        } );    
	} );
</script>