无法使用jquery DataTable在html表中显示Json数据

Question

我有返回Json格式数据的C#函数，函数如下

  void DisplayProjectMasterList()
        {
            string JSONString = "";
            DataTable Dt = DB.GetDataTable("Sp_GetProjectMasterList");
            if (Dt.Rows.Count > 0)
            {
                JSONString = JsonConvert.SerializeObject(Dt);
            }
            Context.Response.Write(JSONString);
    
        }


and I am Calling This Function Via Ajax  .in console i am getting json data  But i dont know how to pass it to Jquery data table to display.. below is the javascript function... please help Me

function DisplayProjectMasterList() {
    $.ajax({
        url: 'project-master.ashx',
        type: "POST",
        dataType: 'json',
        data: {
            'fun': 'DisplayProjectMasterList'
        },
        success: function (data) {
            console.log(data);
            if (Chk_Res(data.errorMessage) == false) {
                    $('#tbl').dataTable({
                        paging: true,
                        sort: true,
                        searching: true,
                        scrollY: 200,
                        data: data,
                        columns: [
                            { 'data':data.Prj_Id },
                            { 'data':data.Prj_No },
                            { 'data':data.Prj_Name },
                            { 'data':data.Cus_Company_Name },
                            { 'data':data.Prj_StartDate },
                            { 'data':data.Prj_CompletionDate },
                        ]

                    });
               
             }
        }
        
    });
}

执行此操作时，我遇到以下错误:

null

Answer 1

Hi请确保返回的数据采用以下格式:

{
  "data": [
    {
     "Prj_Id": 1,
      "Prj_No": 1,
      "Prj_Name": "name",
      "Cus_Company_Name": "company",
      "Prj_StartDate": "2011/04/25",
      "Prj_CompletionDate": "2011/04/25"
    },
{
      "Prj_Id": 1,
      "Prj_No": 1,
      "Prj_Name": "name",
      "Cus_Company_Name": "company",
      "Prj_StartDate": "2011/04/25",
      "Prj_CompletionDate": "2011/04/25"
    }
  ]
}

默认情况下，jquery Datatables查找对象数组的数据属性https://Datatables.net/reference/option/ajax.datasrc https://Datatables.net/examples/ajax/objects.html