Converting a dataset to JSON using .NET 3.5 in C#

Question

I have been searching for a simple way to convert a dataset from a PostgreSQL database to JSON for use in a project that I am building.

This is my first time using JSON, and I have found it really tricky to find a simple way of doing this. I have been using a StringBuilder at the moment to create a JSON string from the information in the dataset, but I have heard that it is possible to do this very simply with .NET 3.5 using the System.Runtime.Serialization namespace, though I have yet to find a simple article or blog on how this is done! What is the easiest way to do this?

Peter Mortensen · Accepted Answer · 2015-02-01 16:49:45Z

7

Use Newtonsofts Json.Net and check out DataTable JSON Serialization in JSON.NET and JavaScriptSerializer where it's used to create a DataSet-to-JSON converter.

edited Feb 1, 2015 at 16:49

Peter Mortensen

31.4k22 gold badges110 silver badges134 bronze badges

answered Dec 10, 2008 at 12:07

finnsson

4,0772 gold badges39 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

David Duman · Accepted Answer · 2015-02-02 15:30:34Z

6

For others looking at this topic:

Here is the simplest way to convert a dataset to a JSON array as json_encode (PHP) does with ASP.Net:

using Newtonsoft.Json;

public static string ds2json(DataSet ds) {
    return JsonConvert.SerializeObject(ds, Formatting.Indented);
}

edited Feb 2, 2015 at 15:30

answered Jun 7, 2013 at 13:39

David Duman

6,6567 gold badges47 silver badges55 bronze badges

Comments

Bhargav Rao · Accepted Answer · 2020-11-30 01:11:26Z

public static string GetJSONString(DataTable Dt)
{
    string[] StrDc = new string[Dt.Columns.Count];
    string HeadStr = string.Empty;

    for (int i = 0; i < Dt.Columns.Count; i++)
    {
        StrDc[i] = Dt.Columns[i].Caption;
        HeadStr += "\"" + StrDc[i] + "\" : \"" + StrDc[i] + i.ToString() + "¾" + "\",";
    }

    HeadStr = HeadStr.Substring(0, HeadStr.Length - 1);

    StringBuilder Sb = new StringBuilder();
    Sb.Append("{\"" + Dt.TableName + "\" : [");

    for (int i = 0; i < Dt.Rows.Count; i++)
    {
        string TempStr = HeadStr;
        Sb.Append("{");

        for (int j = 0; j < Dt.Columns.Count; j++)
        {
            TempStr = TempStr.Replace(Dt.Columns[j] + j.ToString() + "¾", Dt.Rows[i][j].ToString());
        }
        Sb.Append(TempStr + "},");
    }

    Sb = new StringBuilder(Sb.ToString().Substring(0, Sb.ToString().Length - 1));
    Sb.Append("]}");

    return Sb.ToString();
}

var JObject = eval('(' + JSONString + ');');
for(var i = 0; i < JObject .Employees.length; i++)
{

var val1 = JObject.Employees[i].EmployeeID;

var val2 = JObject.Employees[i].NationalIDNumber;

var val3 = JObject.Employees[i].Title;

var val4 = JObject.Employees[i].BirthDate;

var val5 = JObject .Employees[i].HireDate ;

}

HOUSES · Accepted Answer · 2022-08-05 18:17:11Z

public static string dataSetToJsonSt(DataSet dataDs)
{

    int rowsCountIn = dataDs.Tables[0].Rows.Count;
    int colsCountIn = dataDs.Tables[0].Columns.Count;
    string[] columnNamesAr = new string[dataDs.Tables[0].Columns.Count];

    for (int i = 0; i < colsCountIn; i++){

        columnNamesAr[i] = dataDs.Tables[0].Columns[i].ColumnName;
    }

    string jsonSt = "[";

    for (int i = 0; i < rowsCountIn; i++)
    {
        jsonSt += "{";

        for (int j = 0; j < colsCountIn; j++)
        {
            jsonSt += ((jsonSt.Substring(jsonSt.Length - 1) == "{" ? "" : ",") + "\"" + columnNamesAr[j] + "\":" + (dataDs.Tables[0].Rows[i][j] == DBNull.Value ? "null" : ("\"" + dataDs.Tables[0].Rows[i][j] + "\"")));
        }

        jsonSt += ("}" + (i < (rowsCountIn - 1) ? "," : ""));
    }

    jsonSt += "]";

    return jsonSt;
}

Peter Mortensen · Accepted Answer · 2015-02-01 16:50:33Z

-1

Maybe you've heard about the system.runtime.serialization.json namespace in the newly announced .NET Framework 4.0.

edited Feb 1, 2015 at 16:50

Peter Mortensen

31.4k22 gold badges110 silver badges134 bronze badges

answered Dec 10, 2008 at 12:45

gimel

86.9k10 gold badges80 silver badges104 bronze badges

1 Comment

Newbie Over a year ago

I have tried using the serialization.json namespace, but to no avail... There sont seem to be many examples on how to use it and the JavaScriptSerializer and the DataContractJsonSerializer are outputting XML

fcdt · Accepted Answer · 2020-10-13 07:05:10Z

-2

public static T WriteJson<T>(this System.Data.DataSet dataSet)
{
    try
    {
        XmlDocument doc = new XmlDocument();
        doc.LoadXml(dataSet.GetXml());
        return (T)Convert.ChangeType(JsonConvert.SerializeXmlNode(doc).Replace("null", "\"\"").Replace("'", "\'"), typeof(T));
    }
    catch (Exception ex)
    {
        throw ex;
    }
}

edited Oct 13, 2020 at 7:05

fcdt

2,5215 gold badges17 silver badges27 bronze badges

answered Oct 13, 2020 at 6:32

Srinivasulareddy Mallela

1

1 Comment

fcdt Over a year ago

Welcome to StackOverflow. While this code may solve the question, including an explanation of how and why this solves the problem would really help to improve the quality of your post, and probably result in more up-votes. Remember that you are answering the question for readers in the future, not just the person asking now. Please edit your answer to add explanations and give an indication of what limitations and assumptions apply.

Collectives™ on Stack Overflow

Converting a dataset to JSON using .NET 3.5 in C#

6 Answers 6

Comments

Comments

Comments

Comments

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

Comments

Comments

Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related