Home > Net >  Error while trying to load server-side data into razor page using datatables
Error while trying to load server-side data into razor page using datatables

Time:01-26

My table code in view is:

<table  id="table3">
     <thead>
         <tr>
            <th>messageId</th>
            <th>messageText</th>
            <th>messageDate</th>
            <th>receiverUserId</th>
            <th>isSeen</th>
            <th>senderId</th>
            <th>dateSeen</th>
            <th>user</th>
        </tr>
    </thead>

jQuery code:

$('#table3').DataTable( {
         "processing": true, // for show progress bar  
         "serverSide": true, // for process server side  
         "filter": true, // this is for disable filter (search box)  
         "orderMulti": false, // for disable multiple column at once

         "ajax": {
               "url": "/Admin/LoadPmData",
               "type": "POST",  
               "datatype": "json",
               "columns": [
                              {"data":"messageId"},
                              {"data":"messageText"},
                              {"data":"messageDate"},
                              {"data":"receiverUserId"},
                              {"data":"isSeen"},
                              {"data":"senderId"},
                              {"data":"dateSeen"},
                              {"data":"user"}
                          ]
                 }
});

The controller:

[HttpPost]
    public JsonResult LoadPmData()
    {
        var pm = _messageRepository.GetAllMessages();
        return Json(new { data = JsonSerializer.Serialize(pm) });
    }

I have the following error as alert:

DataTables warning: table id=table3 - Requested unknown parameter '1' for row 0. For more information about this error, please see enter image description here

  •  Tags:  
  • Related