Datatables.net 没有加载 JSON - SignalR

Question

我想将以下 JSON 对象加载到 Datatables.net 中，但它不起作用。我使用 SignalR 将 JSON 从服务器端传递到客户端，并且它运行，因为我可以接收 JSON，但无法将其加载到数据表中。请问有人可以帮助我吗？提前致谢！C#代码：cmm_dbEntities db = new cmm_dbEntities();var result = from a in db.TAB_PNjoin b in db.TAB_APPL on a.idapplicability equals b.idapplicabilityjoin c in db.TAB_ISSUE on a.idissue equals c.idissueselect new{    a.pn,    a.title,    b.appl_desc,    c.issue,    c.issue_date,    c.rev,    c.rev_date,    a.equipment,    a.formattype};var obj = new { data = result };string json = JsonConvert.SerializeObject(obj);return json;这是我的 JSON：{    "data": [{        "pn": "346B0300A3300.801",        "title": "Test Bench Replenish Unit, Engine Oil - Operation and Maintenance Manual with Illustrated Parts Breakdown",        "appl_desc": "DESCRIZIONE 005",        "issue": "ISSUE-003",        "issue_date": "2015-03-01T00:00:00",        "rev": "0003",        "rev_date": "AAAAAAAAB9M=",        "equipment": "Test Bench, Replenish Unit, Engine Oil",        "formattype": "XML"    }, {        "pn": "346B0300A3300.805",        "title": "Test Bench Replenish Unit, Engine Oil - Operation and Maintenance Manual with Illustrated Parts Breakdown",        "appl_desc": "DESCRIZIONE 015",        "issue": "ISSUE-004",        "issue_date": "2015-04-01T00:00:00",        "rev": "004",        "rev_date": "AAAAAAAAB9Q=",        "equipment": "Test Bench, Replenish Unit, Engine Oil",        "formattype": "XML"    }, {        "pn": "415808",        "title": "Operating and Maintenance Manual for Ni-Cd Aircraft batteries",        "appl_desc": "DESCRIZIONE 015",        "issue": "ISSUE-001",        "issue_date": "2015-01-01T00:00:00",        "rev": "0001",        "rev_date": "AAAAAAAAB9E=",        "equipment": "Battery",        "formattype": "XML"    }, }

Answer 1

我没有看到你设置属性data。请data: data在初始化表时进行赋值。

hub.client.inizializzaFiltri = function (data) {

    console.log(data);

    $('#PNTable').DataTable({

        data: data //you are missing this

        dataSrc: "objects",

        columns: [

            { data: null, defaultContent: '' },

            { data: 'pn' },

            { data: 'title' },

            { data: 'appl_desc' },

            { data: 'issue' },

            { data: 'issue_date' },

            { data: 'rev' },

            { data: 'rev_date' },

            { data: 'equipment' },

            { data: 'formattype' }],

        order: [[1, "asc"]],

        columnDefs: [

            {

                orderable: false,

                className: 'select-checkbox',

                targets: 0

            },

        ],

        retrieve: true,

        select: {

            style: 'os',

            selector: 'td:first-child'

        }

    });

}

Answer 2

我是这样解决的...

C#代码：

    ...

    var obj = new { data = result };

    string json = JsonConvert.SerializeObject(obj);

    return json;

JS代码：

hub.client.inizializzaFiltri = function (data) {

    var jsn = JSON.parse(data);

    $('#PNTable').DataTable({

    "bPaginate": false,

    "bLengthChange": false,

    "bFilter": true,

    "bInfo": true,

    "bAutoWidth": true,

    "dataSrc": "",

    "data": jsn.data,

    "dataSrc": jsn.data,

     responsive: true,

     columns: [

        { "data": null, defaultContent: '' },

        { "data": 'pn' },

        { "data": 'title' },        

         ...

在将其放入数据表之前，我必须使用 JSON.parse(data) 反序列化 che JSON。

再次感谢