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

c# create datatable from json

SubZero answered on March 5, 2023 Popularity 8/10 Helpfulness 4/10

answer c# create datatable from json

c# create datatable from json

Comment

o create a DataTable from a JSON string, you can use the Newtonsoft.Json package to deserialize the JSON string into a list of objects, and then use that list to populate the DataTable.

using Newtonsoft.Json;
using System.Data;

// Define the class that matches the JSON structure
public class Person
{
    public string Name { get; set; }
    public int Age { get; set; }
    public string Email { get; set; }
}

// Deserialize the JSON string into a list of objects
string json = @"[
    { 'Name': 'John', 'Age': 30, 'Email': 'john@example.com' },
    { 'Name': 'Jane', 'Age': 25, 'Email': 'jane@example.com' },
    { 'Name': 'Bob', 'Age': 40, 'Email': 'bob@example.com' }
]";
List<Person> people = JsonConvert.DeserializeObject<List<Person>>(json);

// Create a DataTable and populate it with the list of objects
DataTable dt = new DataTable();
foreach (var prop in typeof(Person).GetProperties())
{
    dt.Columns.Add(prop.Name, prop.PropertyType);
}
foreach (var person in people)
{
    DataRow row = dt.NewRow();
    foreach (var prop in typeof(Person).GetProperties())
    {
        row[prop.Name] = prop.GetValue(person);
    }
    dt.Rows.Add(row);
}

This code creates a Person class to match the JSON structure, deserializes the JSON string into a list of Person objects using JsonConvert.DeserializeObject, creates a DataTable and adds columns to match the Person class properties, and then loops through the list of Person objects to add rows to the DataTable.

Popularity 8/10 Helpfulness 4/10 Language javascript

Source: Grepper

Tags: c# datatable javascript json

Link to this answer
Share Copy Link

Contributed on Mar 05 2023

SubZero

0 Answers Avg Quality 2/10

c# create datatable from json

Contents

More Related Answers

c# create datatable from json

Grepper

Documentation

Social

Legal

Contact

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