How to add new row as html in existing datatable

Question

Here is the sample html that I have created for my requirement. Basically I want to add a new row to existing datatable, where the source to datatable is the html dom table. And while adding new row, I need to append it first to the dom table and datatable should be re-initialize / newly created with that additional row.

<head>

<link type="text/css" rel="stylesheet" href="http://cdn.datatables.net/1.10.4/css/jquery.dataTables.css" />
<script src="http://code.jquery.com/jquery-1.11.1.min.js"></script>
<script src="http://cdn.datatables.net/1.10.4/js/jquery.dataTables.min.js"></script>

</head>

<body>
<table id="example" class="display" cellspacing="0" width="100%">
        <thead>
            <tr>
                <th>Name</th>
                <th>Position</th>
                <th>Office</th>
                <th>Age</th>
                <th>Start date</th>
                <th>Salary</th>
            </tr>
        </thead>

        <tfoot>
            <tr>
                <th>Name</th>
                <th>Position</th>
                <th>Office</th>
                <th>Age</th>
                <th>Start date</th>
                <th>Salary</th>
            </tr>
        </tfoot>

        <tbody>
            <tr>
                <td>Tiger Nixon</td>
                <td>System Architect</td>
                <td>Edinburgh</td>
                <td>61</td>
                <td>2011/04/25</td>
                <td>$320,800</td>
            </tr>
            <tr>
                <td>Garrett Winters</td>
                <td>Accountant</td>
                <td>Tokyo</td>
                <td>63</td>
                <td>2011/07/25</td>
                <td>$170,750</td>
            </tr>
            <tr>
                <td>Ashton Cox</td>
                <td>Junior Technical Author</td>
                <td>San Francisco</td>
                <td>66</td>
                <td>2009/01/12</td>
                <td>$86,000</td>
            </tr>
            <tr>
                <td>Cedric Kelly</td>
                <td>Senior Javascript Developer</td>
                <td>Edinburgh</td>
                <td>22</td>
                <td>2012/03/29</td>
                <td>$433,060</td>
            </tr>
        </tbody>
    </table>


</body>


<script>

$(document).ready(function() {

    var dt = $('#example').dataTable();


    $('#example tbody').append('<tr><td>bond</td><td>abc</td><td>xyz</td><td>22</td><td>2012/03/29</td><td>$433,060</td></tr>');

    dt.destroy();

    $('#example').dataTable();

}); 
</script>

There is another thread that talks about this. stackoverflow.com/questions/171027/add-table-row-in-jquery — Casey
– Casey, Commented Nov 26, 2014 at 0:15

Vitalij · Accepted Answer · 2020-06-09 11:43:42Z

1

I know this super old post, but if anyone is still looking for an answer, you can easily do it with the following:

Easiest way is to use rows.add passing your html, wrapped in jquery and redrawing the table

var dt = $('#example').dataTable();
var row = '<tr><td>bond</td><td>abc</td><td>xyz</td><td>22</td><td>2012/03/29</td><td>$433,060</td></tr>';
dt.rows.add($(row)).draw();

Or what you did, destroying the table, appending your html and reinitialize datatable again (you just had to destroy the datatable first, and then append)

var dt = $('#example').dataTable();
var row = '<tr><td>bond</td><td>abc</td><td>xyz</td><td>22</td><td>2012/03/29</td><td>$433,060</td></tr>';
dt.destroy();
$('#example tbody').append(row);
dt = $('#example').dataTable();

answered Jun 9, 2020 at 11:43

Vitalij

7148 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

jignesh kumar Over a year ago

Finally, This helped me!

Clément Prévost · Accepted Answer · 2014-11-26 00:18:41Z

0

You can't add a row using direct html tag manipulation once the table is instanciated, use the method from the documentation:

var t = $('#example').DataTable();
var counter = 1;

$('#addRow').on( 'click', function () {
    t.row.add( [
        counter +'.1',
        counter +'.2',
        counter +'.3',
        counter +'.4',
        counter +'.5'
    ] ).draw();

    counter++;
} );

// Automatically add a first row of data
$('#addRow').click();

answered Nov 26, 2014 at 0:18

Clément Prévost

8,6702 gold badges39 silver badges55 bronze badges

1 Comment

Mr bond Over a year ago

I had initially tried that and but my requirement is different. I want to add hmtl elements(i.e. <span class='myClass'>something</span>) within td not static data.

Collectives™ on Stack Overflow

How to add new row as html in existing datatable

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related