SQL to JSON

I didn't tried, because i don't know how to do. meanwhile am looking for that-
"i have data table stored in my sql server and i wanna convert it into JSON for creating a chart from the JSON data(using D3JS). but for now I only want to convert sql server data into JSON"

Hi,
what is the exception or issue you are getting when you tried. 

Moreover, this is what you are looking for ?

http://www.aspdotnet-suresh.com/2013/05/c-convert-datatable-to-json-string-in-c.html

https://www.simple-talk.com/blogs/2013/03/26/sql-server-json-to-table-and-table-to-json/