JQuery Datatable

Ronald Rex

5y822

Hi Friends,

I was wondering how I can update every users Datatable when a user enters a new record to the database without them having to refresh their html page. I don't know if this is impossible but I am new to Browser development using Javascript and how pages get updated or refreshed. Thank You !!!

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Abhishek Chadha5y ago
Accepted answer
You can rebind the datatable again after inserting the record by this way you need not to refresh the page.

Just call the method again at the end of insertion method
Sachin Singh5y ago
I am considering that you have used ajax to insert the user records and then want to update dataTable.
$("#Btn_AddUser").click(function () {
        debugger;
        var postModel = {

            UserName: $("#txtUserName").val(),
            Gender: $("#txtGender").val(),
        }
        $.ajax({

            type: "Post",
            url: "your endpoint",
            dataType: "Json",
            contentType: 'application/json',
            data:JSON.stringify(postModel),

            cache: false,
            success: function (res) {
                debugger;
                $('#dataTable').DataTable().ajax.reload();


            }
        })

    });
The key is:-
$('#dataTable').DataTable().ajax.reload();
Basem Alshabani5y ago
$('#'+yourDataTableId).DataTable().ajax.reload(
(function (json)
{
console.log('table reloaded')
});