手动声明数据(工作正常):
var data = [
["imran_15","David","Maths","80","20","10"],
["imran_15","David","Maths","80","20","10"],
["farhana_06","SIP/8002","03-09-2016","06:57:17am","03-09-2016","04:01:41pm"],
["imran_15","SIP/8001","03-09-2016","03:59:35pm","03-09-2016","09:55:14pm"],
["jannatul_66","SIP/8003","03-09-2016","10:15:34am","03-09-2016","10:26:26am"],
["jannatul_66","SIP/8003","03-09-2016","10:26:31am","03-09-2016","03:59:33pm"],
];
var data = JSON.stringify(responeText[1]);输出:
[
["imran_15","David","Maths","80","20","10"],
["imran_15","David","Maths","80","20","10"],
["imran_15","David","Maths","80","20","10"],
["farhana_06","SIP/8002","03-09-2016","06:57:17am","03-09-2016","04:01:41pm"],
["imran_15","SIP/8001","03-09-2016","03:59:35pm","03-09-2016","09:55:14pm"],
["jannatul_66","SIP/8003","03-09-2016","10:15:34am","03-09-2016","10:26:26am"],
["jannatul_66","SIP/8003","03-09-2016","10:26:31am","03-09-2016","03:59:33pm"]
]
JS:
var data = JSON.stringify(responeText[1]);
$('#table_id').DataTable({
"lengthMenu": [ [10, 25, 50, 100, -1], [10, 25, 50, 100, "All"] ],
"columns": [
{
name: 'first',
title: 'Agent Name',
},
{
name: 'second',
title: 'Extension',
},
{
name: 'third',
title: 'Login Date',
},
{
name: 'fourth',
title: 'Login Time',
},
{
name: 'fifth',
title: 'Logout Date',
},
{
name: 'sixth',
title: 'Logout Time',
},
],
"data": data,
"rowsGroup": [
'first:name',
],
});
当显示错误时:第一个警报:数据表警告:表id=table_id -请求未知参数'1'为行0。有关此错误的详细信息,请参阅http://datatables.net/tn/4第二个警报:数据表警告:表id=table_id -请求未知参数'1'为行0。有关此错误的详细信息,请参阅http://datatables.net/tn/4
请大家帮帮我。
DataTables的data
属性需要一个数组,而不是字符串,所以您根本不需要对数据进行字符串化:
var data = responeText[1];