Here, in this blog, I have described four methods to convert a datatable or a dataset into a JSON string and vice versa.
For this, you have to use the following namespaces.
- using System;
- using System.Xml;
- using System.Data;
- using System.Linq;
- using System.Collections;
- using System.Collections.Generic;
- using System.Text.RegularExpressions;
- using System.Web.Script.Serialization;
- using Newtonsoft.Json;
- using Newtonsoft.Json.Linq;
First Method - DataTable to JSON String
Here, I have used the JavaScriptSerializer class to covert the DataTable into a JSON string.
- public static object dataTableToJSON(DataTable table)
- {
- var list = new List<Dictionary<string, object>>();
- foreach (DataRow row in table.Rows)
- {
- var dict = new Dictionary<string, object>();
- foreach (DataColumn col in table.Columns)
- {
- dict[col.ColumnName] = (Convert.ToString(row[col]));
- }
- list.Add(dict);
- }
- JavaScriptSerializer serializer = new JavaScriptSerializer();
- return serializer.Serialize(list);
- }
Second Method - Dataset to JSON string
- public static object dataSetToJSON(DataSet ds)
- {
- ArrayList root = new ArrayList();
- List<Dictionary<string, object>> table;
- Dictionary<string, object> data;
- foreach (DataTable dt in ds.Tables)
- {
- table = new List<Dictionary<string, object>>();
- foreach (DataRow dr in dt.Rows)
- {
- data = new Dictionary<string, object>();
- foreach (DataColumn col in dt.Columns)
- {
- data.Add(col.ColumnName, dr[col]);
- }
- table.Add(data);
- }
- root.Add(table);
- }
- JavaScriptSerializer serializer = new JavaScriptSerializer();
- return serializer.Serialize(root);
- }
Third Method - JSON String to DataTable
Here, I have used Newtonsoft.
- public static DataTable jsonToDataTable(string jsonString)
- {
- var jsonLinq = JObject.Parse(jsonString);
- // Find the first array using Linq
- var srcArray = jsonLinq.Descendants().Where(d => d is JArray).First();
- var trgArray = new JArray();
- foreach (JObject row in srcArray.Children<JObject>())
- {
- var cleanRow = new JObject();
- foreach (JProperty column in row.Properties())
- {
- // Only include JValue types
- if (column.Value is JValue)
- {
- cleanRow.Add(column.Name, column.Value);
- }
- }
- trgArray.Add(cleanRow);
- }
- return JsonConvert.DeserializeObject<DataTable>(trgArray.ToString());
- }
chris jonesPosted Jan 22, 2021, 5:58 AM
Legend!, this was by far the best and easiest examples I have found. Thank you
Angel CochaPosted May 15, 2020, 8:19 PM
Excelente fue de gran ayuda
Gaurav MishraPosted May 11, 2019, 5:25 AM
Awesome post but can you suggest me which one would be performance efficient from the above mentioned?
Shahrahan ShahrahanPosted May 8, 2019, 7:50 AM
Thanks for this post