How to use one ajax datasource with multiple JQuery Datatables
How to use one ajax datasource with multiple JQuery Datatables
There are two datatables on the same page and both have different columns.
Is there a way to use the same ajax datasource to draw multiple tables? I am trying avoid multiple calls to database.
$('#gvData').DataTable({
"processing": true,
//"serverSide": true,
"bPaginate": false,
"bFilter": false,
"bInfo": false,
"scrollY": "300px",
"scrollCollapse": true,
"bDestroy": true,
"ajax": {
"dataType": 'json',
"contentType": "application/json",
"type": "POST",
"url": "myform.aspx/GetData",
"data": function (d) {
return "{ regDate: '" + regDate + "', cmdName: '" + command + "'}";
},
"dataSrc": function (json) {
adata = json;
return $.parseJSON(json);
}
},
"columns": [{
"data": "Source_Name"
},
{
"data": "Record_Count",
"fnCreatedCell": function (nTd, sData, oData, iRow, iCol) {
$(nTd).html("<a href='" + oData.Record_Count + "' id= '" + iRow + "' style='color: black; text-decoration: none;' onclick='return GetSelectedRow(this, 'completed');' >" + oData.Record_Count + "</a>");
}
}
]
});
This discussion has been closed.
Answers
Use jQuery ajax() to fetch the data then in the
successfunction populate the Datatables, as required, usingrows.add().Kevin