Answers

• paparush Posts: 10Questions: 2Answers: 0

  June 2016

  Update.

  I've simplified the code. Gotten rid of serverside, etc No longer getting the Cannot Read Property Length of Undefined error.

  JSON still looks the same.

  Page loads. I see the JSON in the debugger, but the table remains empty with the message "No Data Available In Table"

  [CODE]
  var table = $('#tblData').DataTable({
  ajax: {
  url: '../InventorySite/services/ArchivedAll.asmx/GetArchivedAll',
  type: 'GET',
  dataType: 'json',
  contentType: "application/json; charset=utf-8",
  dataSrc:"",
  "data": function (d) {
  return JSON.stringify(d);
  }
  }

  [/CODE]

  Thanks again.
• paparush Posts: 10Questions: 2Answers: 0

  June 2016

  SOLVED

  This StackOverflow described building the table elements first, then binding to the DataTable

  This StackOverflow described needing an inner loop and and outer loop to handle how my data was structured

  [CODE]
  $.ajax({
  type: 'GET',
  url: '../InventorySite/services/ArchivedAll.asmx/GetArchivedAll',
  dataType: 'json',
  contentType: "application/json",
  dataSrc:"",
  success: function (data) {
  var ii = 0;

              $.each(data, function () {
                  $.each(this, function (k, v) {
                      body = "<tr>";
                      body += "<td>" + v.SerialNbr + "</td>";
                      //body += "<td>" + data[ii].SerialNbr + "</td>";
                      body += "<td>" + v.BarCode + "</td>";
                      body += "<td>" + v.CategoryText + "</td>";
                      body += "<td>" + v.SubcategoryText + "</td>";
                      body += "<td>" + v.BrandText + "</td>";
                      body += "<td>" + v.ModelText + "</td>";
                      body += "<td>" + v.DispMethodText + "</td>";
                      body += "<td>" + v.Archived + "</td>";
                      body += "<td>" + v.InvArchiver + "</td>";
                      body += "</tr>";
                      $("#tblData tbody").append(body);
  
                  });
                  });
  
  
              /*DataTables instantiation.*/
              $("#tblData").DataTable();
          },
          error: function () {
              alert('Fail!');
          }
      });
  

  [/CODE]

  I'm not thrilled with having to loop over the results and build out the table elements manually, but it works, and the columns sort and the search works.
• paparush Posts: 10Questions: 2Answers: 0

  June 2016

  SOLVED Part II
  I would really appreciate some feedback. The outer/inner loop model illustrated above is PAINFULLY slow; approximately 10 second delay to load 6300 records. The stored procedure that fetches the data returns in < 1 second.