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

how to convert json result into datatable c#

Add Answer

Wicked Warbler answered on December 22, 2021 Popularity 10/10 Helpfulness 4/10

answer how to convert json result into datatable c#

related convert json result to datatable c#

related C# Convert Json File to DataTable

how to convert json result into datatable c#

Comment

using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
using System.Data;
using System.Linq;
...

public static DataTable Tabulate(string json)
{
    var jsonLinq = JObject.Parse(json);

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

Popularity 10/10 Helpfulness 4/10 Language javascript

Source: stackoverflow.com

Tags: c# datatable javascript json

Link to this answer
Share Copy Link

Contributed on Jan 05 2022

Wicked Warbler

0 Answers Avg Quality 2/10

Closely Related Answers

convert json result to datatable c#

Comment

DataTable dt = (DataTable)JsonConvert.DeserializeObject(json, (typeof(DataTable)));

Popularity 10/10 Helpfulness 5/10 Language javascript

Source: stackoverflow.com

Tags: c# c

Link to this answer
Share Copy Link

Contributed on Dec 22 2021

Wicked Warbler

0 Answers Avg Quality 2/10

C# Convert Json File to DataTable

Comment

 public DataTable Read(string filePath)
        {
            try
            {
                //check if json structure is okay (http://jsonlint.com)
                //generate object class http://www.jsonutils.com
             
                DataTable dt = new DataTable();
                dt = JsonConvert.DeserializeObject<DataTable>(File.ReadAllText(filePath));

                return dt;
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
        }

Popularity 9/10 Helpfulness 4/10 Language javascript

Source: Grepper

Tags: c# datatable datatab

Link to this answer
Share Copy Link

Contributed on May 16 2022

BlackSwan

0 Answers Avg Quality 2/10

how to convert json result into datatable c#

Contents

More Related Answers

how to convert json result into datatable c#

Closely Related Answers

convert json result to datatable c#

C# Convert Json File to DataTable

Grepper

Documentation

Social

Legal

Contact

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