Last post Sep 08, 2017 03:59 AM by poornima82
Sep 05, 2017 12:01 PM|mike4u|LINK
masters kindly suggest
Sep 05, 2017 12:08 PM|PatriceSc|LINK
Some more context could help but ASP.NET does this for you when using an ASMX service, a page method or a web API. Having to do that expliciely should be very rare. Are you suing Entity Framework to access the db ?
Your final goal is to make this available to your own pages using Ajax ?
Sep 05, 2017 01:35 PM|A2H|LINK
how to convert sql table data to json
If you are using SQL Server 2016 , then you can use For Json
Sep 06, 2017 01:57 AM|Eric Du|LINK
After reading your title, I think you want to convert the datatable to JSON, please check the following tutorials:
Format Query Results as JSON with FOR JSON (SQL Server):
3 Ways to Convert DataTable to JSON String in ASP.NET C#:
Sep 08, 2017 03:59 AM|poornima82|LINK
If you want to convert sql server table into Json/Xml, please use webAPI concept in asp.net with C# programming.
Use a fiddler too...
To get the result in either JSON or XML.