jQuery Datatables加载数据ajax

Question

想要从asp.net mvp服务器端加载数据。 有jQuery的Ajax的功能：

Function GetData() As ActionResult 

      Dim TransactionSearchRow1 = New TransactionSearchRow With { 
      .status = Status.Cancelled, 
      .transactionId = "12345", 
      .creditCardNumber = "1234324324", 
      .supplier = "Office Depot", 
      .createdAt = New DateTime(2008, 12, 28), 
      .amount = 500 
      } 


      Dim anon = New With {.data = New List(Of TransactionSearchRow) From {TransactionSearchRow1}} 
      Dim jsonData As String = JsonConvert.SerializeObject(anon, Formatting.Indented) 

      Return Json(jsonData) 

     End Function 

但没有什么是发生时，即时通讯点击BTN：即返回我1行数据的

$("#SearchBtn").on("click", function() { 

       $.ajax({ 
        url: '/Transaction/GetData', 
        success: function (dataReturend) { 
         $("#TransactionTable").DataTable({ 
          ajax: '/Transaction/GetData', 
          data: dataReturend, 
          columns: [ 
          { data: 'status' }, 
          { data: 'transactionId' }, 
          { data: 'creditCardNumber' }, 
          { data: 'supplier' }, 
          { data: 'createdAt' }, 
          { data: 'amount' } 
          ] 
         }); 
        } 
       }); 
      }); 

和服务器端。

服务器端返回的数据是这样的：

JSON格式：写在你的单击事件大火不需要的2倍

{ 
"data": [ 
{ 
"status": 2, 
"transactionId": 12345, 
"creditCardNumber": "1234324324", 
"supplier": "Office Depot", 
"createdAt": "2008-12-28T00:00:00", 
"amount": 500.0 
    } 
    ] 
} 

Answer 1

代码。 代码应该是这样的

$("#SearchBtn").on("click", function() { 

    $("#TransactionTable").DataTable({ 
     ajax: '/Transaction/GetData', 
     columns: [ 
     { data: 'status' }, 
     { data: 'transactionId' }, 
     { data: 'creditCardNumber' }, 
     { data: 'supplier' }, 
     { data: 'createdAt' }, 
     { data: 'amount' } 
     ] 
    }); 
}); 

更多参考Datatable