DataTable convert to JSON Format

Question

I have C# DataTable in the following format:

ID | ParetCode|ChildCode| AttName | AttCode|
-------------------------------------------------
01 | 01 | 001 | att1 | 3 |
02 | 01 | 001 | att2 | 456 |
03 | 01 | 002 | att1 | 87 |
04 | 01 | 002 | att0 | 65 |
05 | 02 | 054 | att1 | 54654|

How can I convert that into a Json object as follows?

[
{"id":"01","ParentCode":"01","ChildCode":001
{"AttName":"att1",
"AttCode":3,
"AttName":"att2",
"AttCode":456,
},
"ChildCode":002
{
"AttName":"att1",
"AttCode":87,
"AttName":"att0",
"AttCode":65
}
{"id":"05","ParentCode":"02","ChildCode":054
{"AttName":"att1",
"AttCode":"54654"
}
}
]

Vishal Jadav · Answer

Hi You can use Json.net Newtonsoft library which is really helpful to achieve what you want. Thanks.

Vinay Singh · Answer

Hi check the link public string ConvertDataTableToJSON( DataTable dt) { JavaScriptSerializer jSonString = new JavaScriptSerializer (); List Dictionary string  object >> rows = new List Dictionary string  object >>(); Dictionary string  object > row; foreach ( DataRow dr in dt.Rows) { row = new Dictionary string  object >(); foreach ( DataColumn col in dt.Columns) { row.Add(col.ColumnName dr[col]); } rows.Add(row); } return jSonString.Serialize(rows); } http://www.aspdotnet-pools.com/2016/06/convert-datatable-to-json-objectdata-in.html

Vasanth Natarajan · Answer

Hi follow this it may helpful for you http://www.c-sharpcorner.com/uploadfile/9bff34/3-ways-to-convert-datatable-to-json-string-in-asp-net-c-sharp/

ketan borsdiya · Answer

Hi Ekrem Use below code you need to add Newtonsoft.Json.dll in your referecnce. after that write below code string result = ; result = JsonConvert.SerializeObject(dtbl); you get JSON string in result. If you need to create file for that json string write below code StreamWriter file = new StreamWriter(FilePath + \ + FileName); file.AutoFlush = true; file.WriteLine(result); file.Close(); file.Dispose();

Rajeesh Menoth · Answer

Hi For this first we need to download Json.Net DLL. We can download it from Nuget.org and then import Newtonsoft.Json namespace in our page as shown in below code. Using Json.net Newtonsoft DLL its very easy to get JSON data Reference : http://codepedia.info/convert-datatable-to-json-in-asp-net-c-sharp/ http://www.dotnetpickles.com/2015/02/convert-dataset-datatable-to-json-data.html http://www.codeproject.com/Articles/19396/Convert-ASP-NET-DataTable-to-JSON-to-use-a-DataTab

Manas Mohapatra · Answer

http://www.c-sharpcorner.com/uploadfile/9bff34/3-ways-to-convert-datatable-to-json-string-in-asp-net-c-sharp/ Please find below link in this article user has implemented in 3 ways: 1. Using StringBuilder 2. Using JavaScriptSerializer. 3. UsingJSON.NET As you need the JSON data in little different you can use Option1(StringBuilder).