update table data using ajax

zack

How can I upadte table data using ajax json source when you click a button?
I coundn't find out by myself ;-(
please let me know...

Thank you in advence.


This is json data.
[code]
{
"aaData": [
{
"id": "23",
"Item_Number": "2060914",
},
{
"id": "78",
"Item_Number": "2060914",
},
{
"id": "62",
"Item_Number": "2060914",
}
]
}
[/code]

This is I've been trying script of after clicking "find" button.
[code]

jQuery(function(){
jQuery(".find")
.click(function(e) {
jQuery.ajax({
type: "POST",
url: "./data.json.cgi",
data: {
item_id: jQuery("#item_id").attr("value"),
Item_Number: jQuery("#Item_Number").attr("value"),
},
timeout: 1000,
dataType: "json",
success: function(data){
jQuery('#table_id').dataTable({
"bDestroy": true,
"bPaginate": false,
"bJQueryUI": true,
"bProcessing": true,
"bDeferRender": true,
"bServerSide": true,
"sAjaxSource": data,
"aoColumns": [
{ "sTitle": "ID", "mData": "id" },
{ "sTitle": "Number", "mData": "Item_Number" },
{ "sTitle": "Grade", "mData": null }
],
});
},
error: function(XMLHttpRequest, textStatus, errorThrown){
alert(textStatus + ":::::" + errorThrown);
},
});
e.preventDefault();
})
});
[/code]

allan

By using this plug-in: http://datatables.net/plug-ins/api#fnReloadAjax

Allan

zack

Dear Allan,

Thank you very much!!
I'll try this plug-in.

How good community ;-)

newer

I have tried this plug-in,but it didn't work. Are you sure this plug-in do work with this problem

allan

@newer - link to a test case please - or we can't offer any help: http://datatables.net/forums/discussion/12899/post-test-cases-when-asking-for-help-please-read

Allan

zack

Hi newer,
Just FYI, I did like in exsample below.
[code]
.click(function(e) {
oTable.fnClearTable();
oTable.fnReloadAjax("./data.cgi?aaa=1&bbb=2");
e.preventDefault();
}
[/code]