Replies

• allan Posts: 63,389Questions: 1Answers: 10,450 Site admin

  December 2012

  Please provide a link to a test case: http://datatables.net/forums/discussion/12899/post-test-cases-when-asking-for-help-please-read
• santosh6681 Posts: 4Questions: 0Answers: 0

  January 2013

  hi allan my data is coming from web service so i am unable to host it in jsfiddle .every thing works fine for below 500 rows but not working for more than 500 rows here is my code.
  
  
  
  
  
  $(document).ready(function () {
  function renderTable(result) {
  var dtData = [];
  $.each(result, function () {
  dtData.push([
  this.rank,
  this.name,
  this.LW_amount,
  this.LW_units,
  this.CW_amount,
  this.CW_units
  ]);
  });
  
  $('#grid').dataTable({ //grid is the id of the table
  'aaData': dtData,
  
  //'fnRowCallback': function (nRow, aData, iDisplayIndex, iDisplayIndexFull) {
  //if (aData[2] > 20000) {
  
  // $('td:eq(0)', nRow).addClass('conditionalRowColor');
  //$('td:eq(1)', nRow).addClass('conditionalRowColor');
  //$('td:eq(2)', nRow).addClass('conditionalRowColor');
  //$('td:eq(3)', nRow).addClass('conditionalRowColor');
  //$('td:eq(4)', nRow).addClass('conditionalRowColor');
  //$('td:eq(5)', nRow).addClass('conditionalRowColor');
  // }
  //return nRow;
  //},
  
  'bFilter': true,
  'bLengthChange': true,
  "aoColumns": [{ "sClass": "right" }, { "sClass": "left" }, { "sClass": "right" }, { "sClass": "right" }, { "sClass": "right" }, { "sClass": "right"}],
  'sPaginationType': 'full_numbers',
  'iDisplayLength':5,
  "fnDrawCallback": function () {
  if ($("#grid").find("tr:not(.ui-widget-header)").length <= 5) {
  $('div.dataTables_paginate')[0].style.display = "none";
  } else {
  $('div.dataTables_paginate')[0].style.display = "block";
  }
  }
  });
  }
  
  
  $.ajax({
  type: "GET",
  url: "http://localhost:1504/WebService1.asmx/Getsales",
  contentType: "application/json; charset=utf-8",
  dataType: "json",
  success: function (response) {
  renderTable(response.d);
  },
  failure: function (errMsg) {
  $('#errorMessage').text(errMsg); //errorMessage is id of the div
  }
  });
  });
• allan Posts: 63,389Questions: 1Answers: 10,450 Site admin

  January 2013

  Looks fine to me - I don't know why that would stop working at 500 rows. I'd need to see an example to know why.
  
  Allan
• allan Posts: 63,389Questions: 1Answers: 10,450 Site admin

  January 2013

  btw - that will be slow as anything!
  
  I'd very much suggest you have a look at this blog post and use DataTables built in Ajax source options along with deferred rendering to see things up massively: http://datatables.net/blog/Extended_data_source_options_with_DataTables
• santosh6681 Posts: 4Questions: 0Answers: 0

  January 2013

  its working very fine for fewer rows.but not working for more than 500 rows.how can i produce example because i am consuming from webservice
• allan Posts: 63,389Questions: 1Answers: 10,450 Site admin

  January 2013

  When you say not working - what do you actually mean? Slow, Javascript error, crash? This is why a link to a test case is needed so I can see what is actually happening.
  
  Did you try changing to using the DataTables Ajax with sAjaxSource and mData ?
  
  Allan
• santosh6681 Posts: 4Questions: 0Answers: 0

  January 2013

  hi allan not working in the sense no values displaying in table