Nested Json String to DataTable

Question

I Need to convert the following Json string to DataTable.

{  
   "pnr":"1234567890",
   "train_num":"12311",
   "train_name":"HWH DLIKLK MAI",
   "doj":"23-12-2013",
   "from_station":
   {  
      "code":"DLI",
      "name":"Delhi"
   },
   "to_station":
   {  
      "code":"KLK",
      "name":"Kalka"
   }
}

In DataTable I need to Display

train_num
train_name
doj
from_station(name only)
to_station(name only)

What i have till now is,

public class Train
{
public string train_num { get; set; }
public string train_name { get; set; }
public string doj { get; set; }
public from_station from_station { get; set; }
public to_station to_station { get; set; }
}

public class from_station
{
public string code { get; set; }
public string name { get; set; }
}
public class to_station
{
public string code { get; set; }
public string name { get; set; }
}

public static DataTable ToDataTable(Train data)
{
    PropertyDescriptorCollection props =
    TypeDescriptor.GetProperties(typeof(Train));
    DataTable table = new DataTable();

    for (int i = 0; i < props.Count; i++)
    {
        PropertyDescriptor prop = props[i];
        table.Columns.Add(prop.Name, prop.PropertyType);
    }
    object[] values = new object[props.Count];

        for (int i = 0; i < values.Length; i++)
        {
            values[i] = props[i].GetValue(data);
        }
        table.Rows.Add(values);
    return table;
}

var data = JsonConvert.DeserializeObject<Train>(JsonString);
    dt = ToDataTable(data);
    ui_grdVw_EmployeeDetail1.DataSource = dt;
    ui_grdVw_EmployeeDetail1.DataBind();

I am getting only three columns in datatable

train_num
train_name
doj

why bother converting to a datatable at all? You can bind your train object directly. e.g. Train data = (Train) JsonConvert.DeserializeObject<Train>(JsonString); ui_grdVw_EmployeeDetail1.DataSource = data; — Andy-Delosdos
– Andy-Delosdos, Commented Jul 21, 2016 at 12:30

Zein Makki · Accepted Answer · 2016-07-21 12:14:21Z

5

You need to tweak your DataTable conversion method to be more Generic. Then pass for it the data shaped as you want it to be.

public static DataTable ToDataTable<T>( IList<T> data)
{
    PropertyDescriptorCollection props =
        TypeDescriptor.GetProperties(typeof(T));
    DataTable table = new DataTable();
    for (int i = 0; i < props.Count; i++)
    {
        PropertyDescriptor prop = props[i];
        table.Columns.Add(prop.Name, prop.PropertyType);
    }
    object[] values = new object[props.Count];
    foreach (T item in data)
    {
        for (int i = 0; i < values.Length; i++)
        {
            values[i] = props[i].GetValue(item);
        }
        table.Rows.Add(values);
    }
    return table;
}

Note: the below method can be used to convert any List to DataTable.

Usage:

var data = JsonConvert.DeserializeObject<Train>(JsonString);


var shapedData = Enumerable.Range(0, 1).Select(x =>
                    new
                    {
                        train_num = data.train_num,
                        train_name = data.train_name,
                        doj = data.doj,
                        from_station = data.from_station.name,
                        to_station = data.to_station.name
                    }).ToList();

DataTable dt = ToDataTable(shapedData);

answered Jul 21, 2016 at 12:14

Zein Makki

30.2k6 gold badges58 silver badges66 bronze badges

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

1 Comment

Malcolm Salvador Over a year ago

what if it is the other way around? how should you format a datatable into a Nested JSON?

Collectives™ on Stack Overflow

Nested Json String to DataTable

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related