javascript - 服务器端数据从 C# 加载到 jquery 数据表中

Question

嗨，我已经成功实现了 jquery 数据表服务器端调用，但我无法在 html View 中加载数据它只是说处理这是我的 Js 代码

 $('#internetTable').dataTable({
    'bProcessing': true,
    'bServerSide': true,
    'sAjaxSource': 'api/values/GetInternetSales'
    "aoColumns": [
        { "mData": "Calls" },
        { "mData": "LevelOneOperators" },
        { "mData": "LevelTwoOperators" },
        { "mData": "Issueraised" },
        { "mData": "SalesDate" },
        { "mData": "AutomaticResponses" }

    ]
});

这是 html 代码

<table id="internetTable" class="table table-bordered table-hover">
            <thead>
                <tr>
                    <th >Date</th>
                    <th>Issue Raised</th>
                    <th>Level One Operators</th>
                    <th >Level Two Operators</th>
                    <th>Automatic Responses</th>
                    <th>Calls</th>
                </tr>
            </thead>
        </table>

从服务器得到的响应是

{"sEcho":"2","iTotalRecords":10,"iDisplayStart":1,"iDisplayEnd":1,"iDisplayLength":10,"iTotalDisplayRecords":100,"InternetDataList":[{"Calls":"320","LevelOneOperators":"1","LevelTwoOperators":"7","Issueraised":"1","SalesDate":"2010-11-25T00:00:00","AutomaticResponses":235}]}

现在，我只想问一下，我需要对JS代码进行哪些修改才能在表中解析它，因为我已经搜索了很多，但无法得到任何解决方案。

Answer 1

得到答案，我需要在js中添加以下代码:

$('#internetTable').dataTable({
    'bProcessing': true,
    'bServerSide': true,
    "sServerMethod": "GET",
    // to enable Pagination
    "sPaginationType": "full_numbers",
    'sAjaxSource': 'api/values/GetInternetSales',
    "sAjaxDataProp": "InternetDataList",
    "aoColumnDefs": [{
        "mData": "InternetDataList"
    }],
    "aoColumns": [
        { "mData": "Calls" },
        { "mData": "LevelOneOperators" },
        { "mData": "LevelTwoOperators" },
        { "mData": "Issueraised" },

        { "mData": "AutomaticResponses" },
               { "mData": "SalesDate" }


    ]
});

这里 sAjaxDataProp 是您的数据名称，在我的例子中它是 InternetDataList，默认它是 aadata