EDUCBA

Home Software Development Software Development Tutorials jQuery Tutorial jQuery Data Table

jQuery Data Table

By Priya PedamkarPriya Pedamkar

jQuery Data Table

Introduction to jQuery Data Table

jQuery DataTable is a powerful and smart HTML table enhancing plugin provided by jQuery JavaScript library. It is a highly flexible tool that is basically created to display information in tables as well as adding interactions to them, hence, enhancing data accessibility in HTML tables. jQuery DataTables allow you to create dynamic data tables while adding some advanced features such as pagination, sorting, ordering, searching and many more to the HTML tables with minimal effort. It ensures better management when the quantity of data is huge. It supports both client-side processing as well as server-side processing.

Implementation of jQuery DataTable

To use DataTables, the first step is to include the jQuery library since it is a jQuery plugin. Secondly, two additional files need to be included to get DataTables running on your website.

  • DataTables JavaScript file
  • DataTables CSS file

To get started, we should know that DataTables can work with data from various sources. It can work directly with an HTML table, or data can be specified as an array while it gets initialized or it can also work on AJAX sourced data. To work with an HTML table, the basic criteria is that the table should be a valid one

Installation

The primary step to the installation of DataTables is to include DataTables source files in your code. These files can be used either in the following ways:

Start Your Free Software Development Course

Web development, programming languages, Software testing & others

  • Using individual files from DataTables CDN.
  • Using a download builder to install the files locally on your own server.
  • Using NPM or Bower package manager.

Examples of jQuery Data Table

Given below are the examples of jQuery Data Table:

Example #1

Following is a very simple example to demonstrate the power of jQuery DataTables.

Code:

<html>
<head>
<link
rel="stylesheet"
type="text/css"
href="http://ajax.aspnetcdn.com/ajax/jquery.dataTables/1.9.4/css/jquery.dataTables.css"
/>
</head>
<body>
<table id="table_id">
<thead>
<tr>
<th>Subject</th>
<th>Marks</th>
<th>Grade</th>
</tr>
</thead>
<tbody>
<tr>
<td>Maths</td>
<td>90</td>
<td>A+</td>
</tr>
<tr>
<td>Science</td>
<td>85</td>
<td>A</td>
</tr>
<tr>
<td>English</td>
<td>80</td>
<td>A</td>
</tr>
<tr>
<td>EVS</td>
<td>75</td>
<td>B+</td>
</tr>
<tr>
<td>History</td>
<td>70</td>
<td>B</td>
</tr>
</tbody>
</table>
<script
type="text/javascript"
charset="utf8"
src="http://ajax.aspnetcdn.com/ajax/jQuery/jquery-1.8.2.min.js"
></script>
<script
type="text/javascript"
charset="utf8"
src="http://ajax.aspnetcdn.com/ajax/jquery.dataTables/1.9.4/jquery.dataTables.min.js"></script>
<script>
$(function() {
$("#table_id").dataTable();
});
</script>
</body>
</html>

Output:

  • We started with a normal HTML table with three columns and then we applied the DataTables feature to this table.
  • Once the entire code gets executed, you will be able to see a nice looking table as shown below in the image.

jQuery Data Table 1

  • We have the search functionality to filter our searches from the top search box and also the sorting feature to sort them by clicking on the column name.
  • We have also included the Pagination feature in the page using which you can move through the pages.

jQuery Data Table 2

Example #2

In the below example, table data will be passed as the json array instead of a normal HTML table.

Code:

<html>
<head>
<link
rel="stylesheet"
type="text/css"
href="http://ajax.aspnetcdn.com/ajax/jquery.dataTables/1.9.4/css/jquery.dataTables.css"
/>
</head>
<body>
<table id="table_id">
<thead>
<tr>
<th class="subj_name">Subject</th>
<th>Marks</th>
<th>Grade</th>
<th>Last Modified</th>
</tr>
</thead>
<tbody></tbody>
</table>
<script
type="text/javascript"
charset="utf8"
src="http://ajax.aspnetcdn.com/ajax/jQuery/jquery-1.8.2.min.js"
></script>
<script
type="text/javascript"
charset="utf8"
src="http://ajax.aspnetcdn.com/ajax/jquery.dataTables/1.9.4/jquery.dataTables.min.js"
></script>
<script>
$(function() {
$("#table_id").dataTable({
aaData: [
["Maths", "95", "A+", "null"],
["English", "85", "A", "null"],
["Science", "70", "A+", "2019-06-11 06:30:00"],
["History", "80", "A", "null"],
["Arts", "75", "B", "null"],
["Economics", "70", "A+", "2019-11-09 06:30:00"],
["Commerce", "80", "A", "null"]
],
aoColumnDefs: [
{
sTitle: "Subject Name",
aTargets: ["subj_name"]
},
{
aTargets: [3],
sType: "date",
mRender: function(date, type, full) {
return full[1] == "70" ? new Date(date).toDateString() : "N/A";
}
}
]
});
});
</script>
</body>
</html>

Output:

  • The first step is to create an HTML table, with the required column headings and an empty table body.
  • Now, the next step would be to apply DataTable to the HTML table after which our new table would be shown as below:

passed as the json array

  • In this case, also, we have used the search, sorting and pagination feature for our DataTable.

jQuery Data Table 4

  • We have provided data to the table in a json array using aaData option.
  • aaColumnDefs which has an array of few objects decides the way each column should be rendered in the table. It lets you modify any random column in the table which is specified by aTargets property of the object.
  • aTargets take the values as the class name specified in the column heading, column index or _all to match all the table columns.
  • mRender function is called when each cell of a particular column is rendered. It takes three parameters, data, type and the complete row returning what we would like to render in its place.
  • “sType” attribute specifies the expected type of a column which helps decide the way the values will be sorted for that column.

Example #3

The following example shows data being loaded to a table by DataTables from AJAX (array) as the data source.

Code:

<html>
<head>
<link
rel="stylesheet"
type="text/css"
href="https://cdn.datatables.net/1.10.20/css/jquery.dataTables.min.css"
/>
</head>
<body>
<table id="table_id" class="display" style="width:100%">
<thead>
<tr>
<th>Name</th>
<th>Department</th>
<th>Place</th>
<th>Contact No.</th>
<th>DOJ</th>
<th>Email</th>
</tr>
</thead>
</table>
<script
type="text/javascript"
charset="utf8"
src="https://code.jquery.com/jquery-3.3.1.js"
></script>
<script
type="text/javascript"
charset="utf8"
src="https://cdn.datatables.net/1.10.20/js/jquery.dataTables.min.js"
></script>
<script>
$(document).ready(function() {
$("#table_id").DataTable({
ajax: "./ajaxList.txt"
});
});
</script>
</body>
</html>

AJAX: ajaxList.txt

{
"data": [
[
"Jack Williamson",
"Analytics",
"Florida",
"7689764534",
"2015/01/21",
"jack.williamson@xyz.com"
],
[
"Greer Marshall",
"Finannce",
"London",
"8756456734",
"2013/06/26",
"greer.marshall@xyz.com"
],
[
"Jennifer Davidson",
"IT",
"Mexico",
"7854563456",
"2008/11/10",
"jennifer.davidson@xyz.com"
],
[
"Rodrix Cox",
"Accounts",
"Tokyo",
"8976549087",
"2011/08/29",
"rodrix.cox@xyz.com"
]
]
}

Output:

  • In this example, we are setting the ajax option to the JSON data source address.
  • Table loads data by using AJAX which can be updated anytime automatically on the addition of any further data.
  • DataTables then read the data to be displayed in each column using the column index.

column using the column index

Conclusion

jQuery DataTable is a highly customizable and feature-rich library that can be used to enhance the normal HTML tables. This library provides a simple API and a lot of configuration options to allow you to get data from various data sources. In this article, we have briefly discussed some of the most useful features of DataTables but there is more to it.

Recommended Articles

This is a guide to the jQuery Data Table. Here we discuss the basic concept, different implementation, and examples of jQuery DataTable. You may also have a look at the following articles to learn more –

  1. jQuery mouseover()
  2. jQuery plugins
  3. jQuery html()
  4. jQuery Validate
0 Shares
Share
Tweet
Share
quiz