資料表警告：表id=DimStatus-初始化資料表時，第0行第0列請求未知引數“代碼”

我想在資料表中顯示我的資料，但出現上述錯誤。我的表屬性：

 [Table("DimStatus", Schema = "dmg")]
  public class PolicyState
   {
      [Key]
      public int Code { get; set; }
      public string Title { get; set; }
   }

我的 Api : [Route("api/[controller]/[action]")] [ApiController] 公共類 ReportController : Controller { private ICommonServices _CommonService;

    public ReportController(ICommonServices CommonService)
    {
        _CommonService = CommonService;

    }
     //  GET
    public IActionResult Index()
    {
        return View();
    }


    [HttpPost]
    public IActionResult GetPolicyState()
    {
        try
        {
            var draw = Request.Form["draw"].FirstOrDefault();
            var start = Request.Form["start"].FirstOrDefault();
            var length = Request.Form["length"].FirstOrDefault();
            var sortColumn = Request.Form["columns["   Request.Form["order[0] 
                                         [column]"].FirstOrDefault()  
                                          "][name]"].FirstOrDefault();
            var sortColumnDirection = Request.Form["order[0][dir]"].FirstOrDefault();
            var searchValue = Request.Form["search[value]"].FirstOrDefault();
            int pageSize = length != null ? Convert.ToInt32(length) : 0;
            int skip = start != null ? Convert.ToInt32(start) : 0;
            int recordsTotal = 0;
             var PolicyData = (from tempcustomer in _CommonService.GetPolicyState() select tempcustomer);
            //var PolicyData = _CommonService.GetPolicyState();

            if (!(string.IsNullOrEmpty(sortColumn) && string.IsNullOrEmpty(sortColumnDirection)))
            {
                PolicyData = PolicyData.OrderBy(sortColumn   " "   sortColumnDirection);
            }

            if (!string.IsNullOrEmpty(searchValue))
            {
                PolicyData = PolicyData.Where(m => m.Title.Contains(searchValue));

            }
            recordsTotal = PolicyData.Count();
            var data = PolicyData.Skip(skip).Take(pageSize).ToList();
            var jsonData = new
            {
                draw = draw,
                recordsFiltered = recordsTotal,
                recordsTotal = recordsTotal,
                data = data
            };

            var testd = jsonData;
            return Ok(jsonData);
        }
        catch (Exception ex)
        {
            throw;
        }
    }
}

最后是我的 index.cshtml：

    <link rel="stylesheet" type="text/css" 
    href="https://cdn.datatables.net/1.11.3/css/jquery.dataTables.css">

<div class="container">
<br />
<div style="width:90%; margin:0 auto;">
    <table id="DimStatus" class="table table-striped table-bordered dt-responsive nowrap"
           width="100%" cellspacing="0">
        <thead>
            <tr>
                <th>Code</th>
                <th>Title</th>
                <th>asdf</th>

               </tr>
           </thead>
       </table>
    </div>
</div>
 @section Scripts
  {
  <script type="text/javascript" charset="utf8" 
 src="https://cdn.datatables.net/1.11.3/js/jquery.dataTables.js"></script>
  <script>
    $(document).ready(function () {
            dataTable = $('#DimStatus').dataTable({
            serverSide: true,
            processing: true,
            //searchDelay: 500,
            pageLength: 10,
            infoFiltered: true,
            orderMulti: false,
            "ajax": {
                "url": "/api/Report/GetPolicyState",
                "type": "POST",
                "datatype": "json"
            },

            "columns": [
                { "data": "Code", "name": "Code", "autoWidth": true },
                { "data": "Title", "name": "Title", "autoWidth": true },
                {
                    "render": function (data, row) {
                        return "<a href='#' class='btn btn-danger' onclick=DeleteCustomer('"   
               row.Code   "'); >Details</a>";
                    }

                },

                ]
        });
    });

uj5u.com熱心網友回復：

您的錯誤清楚地表明您回傳的資料沒有任何屬性名稱“代碼”。確保您回傳的資料結構包含屬性名稱“代碼”，因為您正在處理PolicyData類，而不是您在示例代碼中顯示的PolicyState類。

標籤：

上一篇：如何獲取json中的一些值來顯示？[復制]

下一篇：當值等于一位數字時，如何用前導零填充值？