jQuery DataTables All (edit)
jQuery DataTables Pagination, Sorting and Filtering
jQuery Datatable server side pagination and sorting in ASP.NET MVC - LateshtClick (HAY HAY HAY)
JQuery Datatable in ASP.NET Core - Server-Side Processing (codewithmukesh.com)
Datatables.net Deferred Loading of Data using ASP.NET MVC and jQuery - CodeProject
Here we will see followings with ASP.NET MVC as server side...
- Part 1: Implement jQuery Datatable (Basic initialization) in ASP.NET MVC application.
- Part 2: jQuery Datatable server side pagination and sorting in ASP.NET MVC
- Part 3: Implement custom multicolumn server-side filtering in jQuery dataTables
- Full CRUD operation using datatables in ASP.NET MVC
DataTables Server-side Processing with CodeIgniter - CodexWorld
Export HTML Table to Excel
jmaister/excellentexport: Javascript export to Excel (github.com)
Release ExcellentExport.js v1.4 · jmaister/excellentexport (github.com)
eligrey/FileSaver.js: An HTML5 saveAs() FileSaver implementation (github.com)
Export HTML Table to CSV
OmbraDiFenice/table2csv: A simple jQuery plugin to convert HTML tables to CSV (github.com)
How to export to csv, pdf and more using DataTables | Yieng Ly's Blog (wordpress.com)
Part 3: jQuery Datatables Export to CSV Example & Demo (js-tutorials.com)
We have two version of jQuery DataTables
$('#tbl').DataTable();
$('#tbl').dataTable();
More detail as the following:
-
DataTables 1.10+
Use lengthMenu to define a list of available page lengths and optionally pageLength to set initial page length.
If pageLength is not specified, it will be automatically set to the first value given in array specified by lengthMenu.
var table = $('#example').DataTable({ "lengthMenu": [ [2, 4, 8, -1], [2, 4, 8, "All"] ], "pageLength": 4 });
See this jsFiddle for code and demonstration.
-
DataTables 1.9
Use aLengthMenu to define a list of available page lengths and iDisplayLength to set initial page length.
var table = $('#example').dataTable({ "aLengthMenu": [ [2, 4, 8, -1], [2, 4, 8, "All"] ], "iDisplayLength": 4, });
See this jsFiddle for code and demonstration.