jQuery DataTables - Reload table upon row addition

Question

I using jquery datatable plugin and having a "Create" button for ajax creation of my db instance. I wish to reload the datatable after the db instance is created, and i spend for more than one day just to find a solution for this. The closest thing i could find is the plugin for DataTables - fnReloadAjax, however, i cant get it to work. I get either error like: fnReloadAjax is not a function OR networkerror: null124234242 is not found (in firebug)

Any idea how can i reload the table so user can get to see the newly inserted data without refreshing the page??

    // Initialize data table
    var myTable = $('#stocktable').dataTable({

        // Try styling
        "sScrollX": "100%",
        "sScrollXInner": "100%",
        "bScrollCollapse": true,

        // To use themeroller theme
        "bJQueryUI": true,
        // To use TableTool plugin
        "sDom": 'T<"clear">lfrtip',
        // Allow single row to be selected
        "oTableTools": {
            "sRowSelect": "single"
        }
        // Use dataTable editable plugin to allow ajax delete
    }).makeEditable({
        // Reference to controller action
        //sAddURL: "/Stock/AddData",
        sDeleteURL: "/Stock/DeleteData",
        sDeleteHttpMethod: "GET"
    });

When i try to call myTable.fnReloadAjax(), i get the error.. Really need help here... Thanks...

Share some code with us if you want more than just guesses.

rwilliams
– rwilliams

2011-09-23 07:28:49 +00:00
Commented Sep 23, 2011 at 7:28 — rwilliams
– rwilliams, Commented Sep 23, 2011 at 7:28

Jovan MSFT · Accepted Answer · 2011-09-23 14:47:51Z

1

You are using datatable in the client-mode; hence, all rows are already in the TBODY. fnReloadAjax works only if you are in the server-side processing mode.

When makeEditable plugin post request to the server page it automatically add row in the TBODY of the table so you do not need to refresh the table - it is already there. If you do not see it maybe it is placed on some other page because when row is added it is positioned according to the current sort criterion.

If you really want to refresh the table only thing you can do is to refresh entire page but new row will still be shown on some other page and you will not see it until you find exact page where it is placed.

Jovan

answered Sep 23, 2011 at 14:47

Jovan MSFT

14.8k4 gold badges44 silver badges59 bronze badges

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

2 Comments

shennyL Over a year ago

Hi, thanks for reply but the new row is not added, i check the other page and also the total number of data records

Jovan MSFT Over a year ago

If row is not added is it possible that your server side function for adding new row does not work. make editable plugin will just call the "add" page and reload whatever is the current state of the table.

Collectives™ on Stack Overflow

jQuery DataTables - Reload table upon row addition

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related