Replies

• allan Posts: 63,353Questions: 1Answers: 10,444 Site admin

  June 2016

  I'm not clear why you are trying to stringify a string :-). I think you want to parse it!

  Try:

  data: function ( json ) {
    return JSON.parse( json.d );
  }
  

  Allan
• nava1021 Posts: 9Questions: 0Answers: 1

  June 2016 edited June 2016

  Many Thanks Allan as usual.

  I must admit I forgot to JSON.parse the returned JSON string. I changed the code to the following and voila it worked....

     var DTO = { id: indicatorID, sector: sector };   //query parameters
      $('#main_data').dataTable({
          ajax:
          {
              url: "AddGDP.aspx/GetMainData",                   
              type: "POST",
              contentType: "application/json;",
              data: function () {                        //stringify JSON and send param to server
                  return JSON.stringify(DTO);
              },
               dataSrc: function (json) {              //receive JSON back from server and parse the string
                 return JSON.parse(json.d);
           },
          },               
      });
  
  

  Thanks for assisting and saving my time and patience

  datatable Allan

  Nava
• allan Posts: 63,353Questions: 1Answers: 10,444 Site admin

  June 2016

  Oops - yes, ajax.dataSrc! Good to hear you got it working :-)

  Allan