jQuery datatables individual column search

The following are the changes required for the example we discussed in Part 106.

1. Store the reference of the jQuery datatable in a variable for later use.
var datatableInstance = $('#datatable').DataTable()

2. Use DataTable() instead of dataTable() function. Otherwise you will get an error stating datatableInstance.columns is not a function, when you use columns() function on datatableInstance.
var datatableInstance = $('#datatable').DataTable()

What is the difference between dataTable() and DataTable()
dataTable() is the old dataTables constructur where as DataTable() is the newer version. If you use the old dataTable() constructor, please use api() function to access the new API.

var datatableInstance = $('#datatable').DataTable()
datatableInstance.api().columns().every(function () {

3. To include the Web Site column in search, set searchable option of this column to true
{
    'data': 'WebSite',
    'sortable': false,
    'searchable': true,
    'render': function (webSite) {
        if (!webSite) {
            return 'N/A';
        }
        else {
            return '<a href=' + webSite + '>'
                + webSite.substr(0, 10) + '...' + '</a>';
        }
    }
}

4. Please remove scrollY option from the dataTable, so we can see the search textboxes without having to scroll down.

5. Increase the width of the div element to 1700px so the border surrounds the datatable correctly

6. Include the following 2 blocks of code in the success callback function
$('#datatable tfoot th').each(function () {
    var title = $('#datatable thead th').eq($(this).index()).text();
    $(this).html('<input type="text" placeholder="Search ' + title + '" />');
});

datatableInstance.columns().every(function () {
    var dataTableColumn = this;

    $(this.footer()).find('input').on('keyup change', function () {
        dataTableColumn.search(this.value).draw();
    });
});

7. To include the search textboxes in the header instead, instead of footer
$('#datatable thead th').each(function () {
    var title = $('#datatable tfoot th').eq($(this).index()).text();
    $(this).html('<input type="text" placeholder="Search ' + title + '" />');
});

datatableInstance.columns().every(function () {
    var dataTableColumn = this;
    var searchTextBoxes = $(this.header()).find('input');

    searchTextBoxes.on('keyup change', function () {
        dataTableColumn.search(this.value).draw();
    });

    searchTextBoxes.on('click', function (e) {
        e.stopPropagation();
    });
});

Complete Example Code
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <script src="jquery-1.11.2.js"></script>
    <link rel="stylesheet" type="text/css"
        href="//cdn.datatables.net/1.10.7/css/jquery.dataTables.min.css" />
    <script src="//cdn.datatables.net/1.10.7/js/jquery.dataTables.min.js">
    </script>
    <script type="text/javascript">
        $(document).ready(function () {
            $.ajax({
                url: 'EmployeeService.asmx/GetEmployees',
                method: 'post',
                dataType: 'json',
                success: function (data) {
                    var datatableInstance = $('#datatable').DataTable({
                        paging: true,
                        sort: true,
                        searching: true,
                        data: data,
                        columns: [
                            { 'data': 'Id' },
                            { 'data': 'FirstName' },
                            { 'data': 'LastName' },
                            { 'data': 'Gender' },
                            { 'data': 'JobTitle' },
                            {
                                'data': 'WebSite',
                                'sortable': false,
                                'searchable': true,
                                'render': function (webSite) {
                                    if (!webSite) {
                                        return 'N/A';
                                    }
                                    else {
                                        return '<a href=' + webSite + '>'
                                            + webSite.substr(0, 10) + '...' + '</a>';
                                    }
                                }
                            },
                            {
                                'data': 'Salary',
                                'render': function (salary) {
                                    return "$" + salary;
                                }
                            },
                            {
                                'data': 'HireDate',
                                'render': function (jsonDate) {
                                    var date = new Date(parseInt(jsonDate.substr(6)));
                                    var month = date.getMonth() + 1;
                                    return month + "/" + date.getDate() + "/" + date.getFullYear();
                                }
                            }
                        ]
                    });


                    $('#datatable tfoot th').each(function () {
                        var title = $('#datatable thead th').eq($(this).index()).text();
                        $(this).html('<input type="text" placeholder="Search ' + title + '" />');
                    });

                    datatableInstance.columns().every(function () {
                        var dataTableColumn = this;

                        $(this.footer()).find('input').on('keyup change', function () {
                            dataTableColumn.search(this.value).draw();
                        });
                    });
                }
            });
        });
    </script>
</head>
<body style="font-family: Arial">
    <form id="form1" runat="server">
        <div style="width: 1700px; border: 1px solid black; padding: 3px">
            <table id="datatable">
                <thead>
                    <tr>
                        <th>Id</th>
                        <th>First Name</th>
                        <th>Last Name</th>
                        <th>Gender</th>
                        <th>Job Title</th>
                        <th>Web Site</th>
                        <th>Salary</th>
                        <th>Hire Date</th>
                    </tr>
                </thead>
                <tfoot>
                    <tr>
                        <th>Id</th>
                        <th>First Name</th>
                        <th>Last Name</th>
                        <th>Gender</th>
                        <th>Job Title</th>
                        <th>Web Site</th>
                        <th>Salary</th>
                        <th>Hire Date</th>
                    </tr>
                </tfoot>
            </table>
        </div>
    </form>
</body>
</html>

Comments

Post a Comment

Popular posts from this blog

Automatically send Birthday email using C#.Net

In order to automatically send Birthday email daily at particular time, a Windows Service will be created which will run daily at the particular time and will automatically send Birthday emails using C#.Net. In this article the Windows Service will execute a Task daily at a specific time. The Task is to fetch all records of Students who have a Birthday today. Such students will receive an email containing Birthday wishes automatically by the Windows Service. Config:- < appSettings >     < add  key  = " Mode "  value  = " Daily "  />     < add  key  = " IntervalMinutes "  value  = " 1 "  />     < add  key  = " ScheduledTime "  value  = " 17:43 "  /> </ appSettings > < connectionStrings >     < add  name = " constr "  connectionString = " Data Source=.\SQL2008R2;Initial Catalog=S...
Read more

Drag and Drop multiple File upload using jQuery AJAX in ASP.Net using C# and VB.Net

Multiple files such as Image, PDF, Word, Excel, etc. and also large Music and Video files such as MP3 and MP4 will be easily uploaded by simple Drag and Drop of files in HTML5 supported browsers using jQuery and AJAX in ASP.Net. This article makes use of the jQuery FileDrop plugin which makes use of Generic HTTP Handlers for uploading files with Drag and Drop using jQuery and AJAX in ASP.Net. In this article I will explain with an example, how to upload multiple files with Drag and Drop in HTML5 supported browsers using jQuery and AJAX in ASP.Net using C# and VB.Net. Multiple files such as Image, PDF, Word, Excel, etc. and also large Music and Video files such as MP3 and MP4 will be easily uploaded by simple Drag and Drop of files in HTML5 supported browsers using jQuery and AJAX in ASP.Net. This article makes use of the  jQuery FileDrop  plugin which makes use of Generic HTTP Handlers for uploading files with Drag and Drop using jQuery and AJAX in ASP.Net.  ...
Read more

Difference between each and map in jquery

Image
$.map $.each map method can be used as an iterator. each method is an immutable iterator Returns a new array Returns the original array The order of callback arguments - element, index. $.map(elems,  function  () { element, index }, arg) The order of callback arguments - index, element. $.each(elems,  function  () { index, element }, arg) Does not have a way to terminate the iteration Return false to terminate the iteration Example :  Notice that the callback arguments in the each method are the reverse of the callback arguments in the map function. Also notice that map returns a new array where as each method returns the original array. This proves the point that each method is an immutable iterator where as map is not. $(document).ready( function  () {      var  intArray = [1, 2, 3, 4, 5];      function  functionA(index, element) {          return ...
Read more