Last post Dec 24, 2020 12:35 PM by l.laxmikant
None
0 Points
14 Posts
Dec 24, 2020 07:03 AM|mohitjoshi72|LINK
I want to develop a Web App in ASP.NET C# where I want to display chart based on SQL Table Column values. For that I need to extract all the values in JSON. So I kindly request to help me to perform the task ASAP.
Contributor
3540 Points
905 Posts
Dec 24, 2020 12:35 PM|l.laxmikant|LINK
Below code will give you all column names of a table
SELECT * FROM sys.columns WHERE object_id = OBJECT_ID('News')
then you can read using ADO.NET and convert to json
https://geeksarray.com/blog/convert-datatable-to-csv-or-list-or-json-string-using-dot-net-core
None
0 Points
14 Posts
Getting SQL Table Column values in json
Dec 24, 2020 07:03 AM|mohitjoshi72|LINK
I want to develop a Web App in ASP.NET C# where I want to display chart based on SQL Table Column values. For that I need to extract all the values in JSON. So I kindly request to help me to perform the task ASAP.
Contributor
3540 Points
905 Posts
Re: Getting SQL Table Column values in json
Dec 24, 2020 12:35 PM|l.laxmikant|LINK
Below code will give you all column names of a table
SELECT * FROM sys.columns WHERE object_id = OBJECT_ID('News')then you can read using ADO.NET and convert to json
https://geeksarray.com/blog/convert-datatable-to-csv-or-list-or-json-string-using-dot-net-core