Parse nested JSON data into DataTable

Question

I need to parse some JSON data below that is nested into a datatable. the 'attributes' field for each of the 3 groups contain inner data for Title, Value, and Priority.

[{
"Title": "OVERVIEW",
"Priority": 1,
"attributes": [{
    "Title": "Type",
    "Value": "MacBook Pro",
    "Priority": 1
    },
    {
       "Title": "Operating system",
       "Value": "OS X Mountain Lion",
       "Priority": 2
    },
    {
       "Title": "Processor",
       "Value": "Intel Core i5 Processor (2.3 GHz, 3.3 GHz with TurboBoost, 6MB cache)",
       "Priority": 3
   },
   {
       "Title": "Storage",
       "Value": "500 GB HDDM 5400 rpm",
       "Priority": 4
   }]
},
{
"Title": "SPECIFICATION",
"Priority": 2,
"attributes": [{
    "Title": "RAM",
    "Value": "4 GB DDR3",
    "Priority": 1
    }]
},
{
"Title": "SCREEN",
"Priority": 3,
"attributes": [{
    "Title": "Screen size",
    "Value": "13\"",
    "Priority": 1
    }]
}]

I realise i need to deserialize the JSON data first,

List<User> UserList = JsonConvert.DeserializeObject<List<User>>(jsonString);

public static DataTable ToDataTable<T>(this 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;        
}

but not sure where to go from there as the above just takes into account nrmal JSON data. Any help would be greatly appreciated.

Frebin Francis · Accepted Answer · 2015-02-11 09:36:47Z

4

Use this classes to deserialize data

         public class TitleDesc
    {
        public string Title { get; set; }
        public int Priority { get; set; }
        public Attribute[] attributes { get; set; }
    }

    public class Attribute
    {
        public string Title { get; set; }
        public string Value { get; set; }
        public int Priority { get; set; }
    }

then use this code to serialize

string jsonString = "[{'Title': 'OVERVIEW','Priority': 1,'attributes': [{    'Title': 'Type',    'Value': 'MacBook Pro',    'Priority': 1    },    {       'Title': 'Operating system',       'Value': 'OS X Mountain Lion',       'Priority': 2    },    {       'Title': 'Processor',       'Value': 'Intel Core i5 Processor (2.3 GHz, 3.3 GHz with TurboBoost, 6MB cache)',       'Priority': 3   },   {       'Title': 'Storage',       'Value': '500 GB HDDM 5400 rpm',       'Priority': 4   }]},{'Title': 'SPECIFICATION','Priority': 2,'attributes': [{    'Title': 'RAM',    'Value': '4 GB DDR3',    'Priority': 1    }]},{'Title': 'SCREEN','Priority': 3,'attributes': [{    'Title': 'Screen size',    'Value': '13',    'Priority': 1    }]}]";
        var data = JsonConvert.DeserializeObject<TitleDesc[]>(jsonString);

Hope this helps.

edited Feb 11, 2015 at 9:36

answered Feb 11, 2015 at 9:21

Frebin Francis

1,9151 gold badge12 silver badges19 bronze badges

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

1 Comment

Eoiner Over a year ago

Yes thats perfect! didnt think it would be that straight-forward, thanks!

Collectives™ on Stack Overflow

Parse nested JSON data into DataTable

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related