DataTables.js插入数据的两种方式

一:采用数组的方式插入值

var tableData = [];
var i = ;
var idxTable = ;
$.each(data, function (i, d) {
tableData.push([idxTable, d.stcd, d.stnm, d.ddz, d.ddcp, d.ckflz,d.normz,d.ttcp,d.actcp,d.z,d.w,d.inq,d.oz,d.outq,d.adjw,"","","查看"]);
idxTable++;
});
//所有数据添加到表格中
thGridTable.fnClearTable(false);
thGridTable.fnAddData(tableData);

二:采用Json对象插入值,必须在创建的时候设置列名

//创建表格
var thGridTable = $('#' + tableName).dataTable({
"sScrollY": "320px",
"bPaginate": false,
"bLengthChange": false,
"bScrollCollapse": false,
"paging": false,
"ordering": false,
"bSort": false,
"info": false,
"bFilter": false,
"bJQueryUI": false,
"language": {
"lengthMenu": "每页 _MENU_ 条记录",
"zeroRecords": "没有找到记录",
"info": "共 _TOTAL_ 条记录",
"infoEmpty": "无记录",
"infoFiltered": "(从 _MAX_ 条记录过滤)"
},
"aoColumns": [
{ "mData": "stcd" },
{ "mData": "stcd" },
{ "mData": "stnm" },
{ "mData": "ddz" },
{ "mData": "ddcp" },
{ "mData": "ckflz" },
{ "mData": "normz" },
{ "mData": "ttcp" },
{ "mData": "actcp" },
{ "mData": "z" },
{ "mData": "w" },
{ "mData": "inq" },
{ "mData": "oz" },
{ "mData": "outq" },
{ "mData": "adjw" },
{ "mData": "ddcp" },
{ "mData": "ddcp" },
{ "mData": "ddcp" },
]
});
//所有数据添加到表格中
thGridTable.fnClearTable(false);
thGridTable.fnAddData(data);
上一篇:1.通过模板创建MAP版本项目


下一篇:SQL数据库的十条命令