Home > Article > Web Front-end > How to apply the jQuery plug-in datatables for table manipulation
This time I will show you how to apply the jQuery plug-in datatables for operating tables, and what are the application Notes of the plug-in datatables for jQuery operating tables. The following is a practical case, let's take a look.
1. Introduction to Datatables
DataTables is a jQuery table plug-in. This is a highly flexible tool based on progressive enhancements that will add advanced interactive controls and support for any HTML form. Main features:
Automatic paging processing
Data sorting and Data typeAutomatic detection
Automatic processing Column width
Can be customized through CSS style
Supports hidden columns
Ease of use
Scalability and flexibility
Internationalization
Dynamic creation of tables
Free ’s
2. How to use When doing the backend, there are no artists and front-end engineers to cooperate with you in making the page. In order to display the data and have certain For aesthetics, we can use jQuery's DataTables plug-in to help us complete the task
1. The default configuration of DataTables
$(document).ready(function() { $('#example').dataTable(); } );
2. Some basic attribute configurations of DataTables
"bPaginate": true, //翻页功能 "bLengthChange": true, //改变每页显示数据数量 "bFilter": true, //过滤功能 "bSort": false, //排序功能 "bInfo": true,//页脚信息 "bAutoWidth": true//自动宽度
3. Data sorting
$(document).ready(function() { $('#example').dataTable( { "aaSorting": [ [ 4, "desc" ] ] } ); } );Start from column 0, end with column 0 4 columns in reverse order
4. Hide some columns
$(document).ready(function() { $('#example').dataTable( { "aoColumnDefs": [ { "bSearchable": false, "bVisible": false, "aTargets": [ 2 ] }, { "bVisible": false, "aTargets": [ 3 ] } ] } ); } );
5.Internationalization
$(document).ready(function() { $('#example').dataTable( { "oLanguage": { "sLengthMenu": "每页显示 _MENU_ 条记录", "sZeroRecords": "抱歉, 没有找到", "sInfo": "从 _START_ 到 _END_ /共 _TOTAL_ 条数据", "sInfoEmpty": "没有数据", "sInfoFiltered": "(从 _MAX_ 条数据中检索)", "oPaginate": { "sFirst": "首页", "sPrevious": "前一页", "sNext": "后一页", "sLast": "尾页" }, "sZeroRecords": "没有检索到数据", "sProcessing": "" } } ); } );
6. Sorting function:
$(document).ready(function() { $('#example').dataTable( { "aoColumns": [ null, { "asSorting": [ "asc" ] }, { "asSorting": [ "desc", "asc", "asc" ] }, { "asSorting": [ ] }, { "asSorting": [ ] } ] } ); } );
7. Data acquisition supports 4 types: as follows
•DOM Document Data
1. Requirements: As shown in the figure below, add, edit, and delete the contents of datatables.
2. Analysis: Add function---click the add button to pop up a dialog box to add new content.Editing function---Click datatables to select a row. The row changes color, which means it has been selected. Click the edit button to pop up the dialog. The content in this dialog is the content of the row we selected. If no row is selected and the edit button is clicked, the dialog will not pop up. When a row in datatables is double-clicked, a dialog will also pop up, and the color of the double-clicked row will change. The content in the dialog is the content of the row we double-clicked.
Deletion function---click datatables to select a row, click the delete button, and a warning box will pop up, prompting you whether to delete the selected content. When nothing is selected, clicking the delete button will not pop up a warning box and the content will not be deleted.3. Encoding:
Attributes//Name
Name | Value | DisplayOrder |
---|
//声明dialog,异步更新 @using (Ajax.BeginForm("Update", "Product", new AjaxOptions { UpdateTargetId = "d_Attributes", OnSuccess = "dialogClose", HttpMethod = "Post", })) {
Name | * |
Value | * |
DisplayOrder | * |
上面代码说明:这段代码主要分了两个部分,第一部分是jquery datatables的声明,
Rendering engine | Browser | Platform(s) | Engine version | CSS grade |
---|---|---|---|---|
Trident | Internet Explorer 4.0 | Win 95+ | 4 | X |