DataTable convert to JSON Format

Ekrem Tapan

10y982.NET

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"
}
}
]

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vishal Jadav10y ago
Hi,
You can use Json.net Newtonsoft library which is really helpful to achieve what you want.
Thanks.
Vinay Singh10y ago
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 Natarajan10y ago
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 borsdiya10y ago
Hi Ekrem,
Use below code,
you need to addNewtonsoft.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 Menoth10y ago
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 Mohapatra10y ago
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).