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).

DataTable convert to JSON Format

Answers (6)