Problem updating jquery dataTables plug-in with ASP.NET MVC

Question

I need help in regards to updating a table rendered by jQuery data-tables plugin.

I have a view called Index.aspx in which I have a DIV, where the traditional table data is rendered. Something like:

<div id="students">
    <table ...>
         <thead>
           ...
         </thead>
         <tbody>
           ... (all the rows are statically rendered to DOM)
         </tbody>
    </table>

</div>

Then, I initialize the datatable as:

$(document).ready(function(){
    $("#students").dataTable();
});

The approach I have designed to use this along with CRUD operations is as follows:

All INSERT, UPDATE and REMOVE scenarios call an Action which returns a PartialView that updates the DIV.

However, even though I see the data is updated properly, I lose dataTable's functionalities like Paging, Sorting, etc. It doesn't even reflect the correct number of records in the datatable.

I understand this is happening because dataTable caches the data in its internal structure, so when I update the portion of the page using Ajax, dataTable is unaware of the data changes.

Has anyone come across this situation? What is a NICE and CLEAN approach to fix this problem?

Cheers,

Mosh

Reigel Gallarde · Accepted Answer · 2010-07-12 02:55:31Z

1

have you tried calling fnDraw after ajax?

answered Jul 12, 2010 at 2:55

Reigel Gallarde

65.4k21 gold badges126 silver badges142 bronze badges

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

Comments

Diablo · Accepted Answer · 2011-01-06 20:21:52Z

1

Try something like this in your code where you need to refresh your table:

oCache.iCacheLower = -1;
oTable.fnDraw();

answered Jan 6, 2011 at 20:21

Diablo

3,4181 gold badge24 silver badges28 bronze badges

Collectives™ on Stack Overflow

Problem updating jquery dataTables plug-in with ASP.NET MVC

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related