I suggest the following approach.
1. Create JSON services on the server side to serve the SQL data
2. Make AJAX request on the client side to fetch the data
3. Convert the data into JavaScript objects as required by CanvasJS Charts
4. Assign data to the chart and render.
—
Sunil