Breaking News: Grepper is joining You.com. Read the official announcement!

convert dataset format into json#

Vast Vendace answered on July 3, 2023 Popularity 1/10 Helpfulness 1/10

answer convert dataset format into json#

convert dataset format into json#

Comment

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);  
}

Popularity 1/10 Helpfulness 1/10 Language csharp

Source: Grepper

Tags: c# dataset format

Link to this answer
Share Copy Link

Contributed on Jul 03 2023

Vast Vendace

0 Answers Avg Quality 2/10

convert dataset format into json#

Contents

More Related Answers

convert dataset format into json#

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.