Parse json string using JSON NET

Question

I have a string like the following in C   I need to loop through and create an HTML table output  I tried with JSON NET but couldn t figure out how to retrieve the keys  Name  Age  amp  Job     string data     items     Name   AAA   Age   22   Job   PPP      Name   BBB   Age   25   Job   QQQ      Name   CCC   Age   38   Job   RRR         The table format is                                  Name    Age     Job                                     AAA     22      PPP                                     BBBB    25      QQQ                                     CCC     28      RRR                                      Any help will be greatly appreciated     The code provided by Dave is the ideal solution here   but it work for  NET 4 0   I have used following code with JSON NET for  NET 3 5    using Newtonsoft Json Linq   string jsonString     items    Name   Anz   Age   29   Job        Name   Sanjai   Age   28   Job   Developer     Name   Rajeev   Age   31   Job   Designer                JObject root   JObject Parse jsonString            JArray items    JArray root  items             JObject item          JToken jtoken           for  int i   0  i  lt  items Count  i      loop through rows                       item    JObject items i               jtoken   item First               while  jtoken    null   loop through columns                               Response Write   JProperty jtoken  Name ToString               JProperty jtoken  Value ToString       lt br   gt                      jtoken   jtoken Next

User · Answer

If your keys are dynamic I would suggest deserializing directly into a DataTable:

    class SampleData
    {
        [JsonProperty(PropertyName = "items")]
        public System.Data.DataTable Items { get; set; }
    }

    public void DerializeTable()
    {
        const string json = @"{items:["
            + @"{""Name"":""AAA"",""Age"":""22"",""Job"":""PPP""},"
            + @"{""Name"":""BBB"",""Age"":""25"",""Job"":""QQQ""},"
            + @"{""Name"":""CCC"",""Age"":""38"",""Job"":""RRR""}]}";
        var sampleData = JsonConvert.DeserializeObject<SampleData>(json);
        var table = sampleData.Items;

        // write tab delimited table without knowing column names
        var line = string.Empty;
        foreach (DataColumn column in table.Columns)            
            line += column.ColumnName + "\t";                       
        Console.WriteLine(line);

        foreach (DataRow row in table.Rows)
        {
            line = string.Empty;
            foreach (DataColumn column in table.Columns)                
                line += row[column] + "\t";                                   
            Console.WriteLine(line);
        }

        // Name   Age   Job    
        // AAA    22    PPP    
        // BBB    25    QQQ    
        // CCC    38    RRR    
    }

You can determine the DataTable column names and types dynamically once deserialized.

User · Answer

You can use  NET 4 s dynamic type and built-in JavaScriptSerializer to do that   Something like this  maybe   string json       items       Name     AAA     Age     22     Job     PPP       Name     BBB     Age     25     Job     QQQ       Name     CCC     Age     38     Job     RRR         var jss   new JavaScriptSerializer     dynamic data   jss Deserialize lt dynamic gt  json    StringBuilder sb   new StringBuilder     sb Append   lt table gt  n   lt thead gt  n     lt tr gt  n        Build the header based on the keys in the     first data item  foreach  string key in data  items   0  Keys            sb AppendFormat         lt th gt  0  lt  th gt  n   key      sb Append       lt  tr gt  n   lt  thead gt  n   lt tbody gt  n     foreach  Dictionary lt string  object gt  item in data  items          sb Append       lt tr gt  n         foreach  string val in item Values            sb AppendFormat         lt td gt  0  lt  td gt  n   val            sb Append       lt  tr gt  n   lt  tbody gt  n lt  table gt      string myTable   sb ToString      At the end  myTable will hold a string that looks like this    lt table gt       lt thead gt           lt tr gt               lt th gt Name lt  th gt               lt th gt Age lt  th gt               lt th gt Job lt  th gt           lt  tr gt       lt  thead gt       lt tbody gt           lt tr gt               lt td gt AAA lt  td gt               lt td gt 22 lt  td gt               lt td gt PPP lt  td gt           lt tr gt               lt td gt BBB lt  td gt               lt td gt 25 lt  td gt               lt td gt QQQ lt  td gt           lt tr gt               lt td gt CCC lt  td gt               lt td gt 38 lt  td gt               lt td gt RRR lt  td gt           lt  tr gt       lt  tbody gt   lt  table gt

User · Answer

I did not test the following snippet    hopefully it will point you towards the right direction       var jsreader   new JsonTextReader new StringReader stringData        var json    JObject new JsonSerializer   Deserialize jsreader       var tableRows   from p in json  items                    select new                                         Name    string p  Name                         Age    int p  Age                         Job    string p  Job

[c#] Parse json string using JSON.NET

Examples related to c#

Examples related to asp.net

Examples related to json

Examples related to json.net