How to Integrate CanvasJS with SQL server using asp.net C#

Question

Hi I developed an application that was showing trend of event for period of years and i want to using CanvasJS to visualize the trend. The Data's are return in a DataTable containing Years and Values. I declare the DataTable as public parameter and convert it to JQUERY String using stringBuilder then pass the Jquery as datapoints: [' '] This did not work for me i have been on this for three(3) weeks now with no result. I need any technical assistance to get this to work. Thank you

Sameer Shaik · Answer

Hi Abraham try this Convert your DataTable to Json http://www.c-sharpcorner.com/UploadFile/9bff34/3-ways-to-convert-datatable-to-json-string-in-Asp-Net-C-Sharp/ Debug your codecopy your json string and verify whether your json string is valid or not. https://codebeautify.org/jsonviewer And if possible I prefer you to write a client side jquery Ajax call for loading charts. Hope this helps