DataTables warning: table id=datatable - Ajax error RSS

• • Reply
  RhodoDen

  None

  0 Points

  5 Posts

  DataTables warning: table id=datatable - Ajax error

  Apr 07, 2021 12:09 AM|RhodoDen|LINK

  I recently moved an older asp.net application to a new server. Among other things, it displays the contents of a SQL table. The application works with no error when I run it in Visual Studio with IIS Express, but when I publish it to IIS 10, I get this error:

  DataTables warning: table id=EmployeeTable - Ajax error. For more information about this error, please see http://datatables.net/tn/7

  I assume it's not making the SQL table connection in IIS 10, but why would IIS Express and IIS handle this differently:

  var Popup, dataTable;
          $(document).ready(function () {
              dataTable = $("#employeeTable").DataTable({
                  "ajax": {
                      "url": "/Employee/GetData",
                      "type": "GET",
                      "datatype": "json"
                  },
                  "columns": [
                      { "data": "requestorFirstName" },
                      { "data": "requestorLastName" },
                      { "data": "requestorEmail" },                                      
                      { "data": "requestorID", "render": function (data) {
                          return "<button type='button' class='btn btn-default btn-sm' onclick=PopupForm('@Url.Action("AddOrEdit", "Employee")/" + data + "')><i class='fa fa-keyboard' aria-hidden='true'></i> Edit</a><button class='btn btn-danger btn-sm' style='margin-left:5px' onclick=Delete("+data+")><i class='fa fa-trash' aria-hidden='true'></i> Delete</button>";
                      },
                          "orderable": false,
                          "searchable": false,
                          "width": "150px"
                      }
                  ],
                  "order": [[1, 'asc']],
                  "language": {
                      "emptyTable": "No data found, Please Click on <b>Add New</b> Button."
                  },
                  "lengthChange": false
              });
          });

  public ActionResult GetData() //happens on load of page
          {
              
              using (DBModel db = new DBModel())
              {
                  
                  List<Requestor> empList = db.People.ToList<Requestor>();
                  return Json(new { data = empList }, JsonRequestBehavior.AllowGet);
              }
          }

• • Reply
  AddWeb Solut...

  Participant

  860 Points

  498 Posts

  Re: DataTables warning: table id=datatable - Ajax error

  Apr 12, 2021 12:44 PM|AddWeb Solution|LINK

  Hello RhodoDen,
  Server-side processing in DataTables is enabled through use of the serverSide option.
  Try to set it true and DataTables will operate in server-side processing mode

  $('#example').DataTable({ 
  serverSide: true, 
  ajax: '/data-source' 
  });

  
  
  

  Ashish Jain