Monday, 30 March 2015

Convert Json string to table

No comments
 protected void Page_Load(object sender, EventArgs e)
    {
       var wc = new WebClient();
        var jsonstring = string.Empty;
        string url = "https://gist.github.com/tdreyno/4278655/raw/755b1cfc5ded72d7b45f97b9c7295d525be18780/airports.json";//done
     
        jsonstring = wc.DownloadString(url);
        var data1 = JsonConvert.DeserializeObject(jsonstring);
        //Response.Write(data.ToString());


        string json = data1.ToString();

        var jss = new JavaScriptSerializer();

        dynamic data = jss.Deserialize<dynamic>(json);

        StringBuilder sb = new StringBuilder();

        sb.Append("<table>\n  <thead>\n    <tr>\n");

        // Build the header based on the keys in the
        //  first data item.
        foreach (string key in data[0].Keys)
        {
            sb.AppendFormat("      <th>{0}</th>\n", key);
        }

        sb.Append("    </tr>\n  </thead>\n  <tbody>\n");

        foreach (Dictionary<string, object> item in data)
        {
            sb.Append("    <tr>\n");

            foreach (string val in item.Values)
            {
                sb.AppendFormat("      <td>{0}</td>\n", val);
            }
        }

        sb.Append("    </tr>\n  </tbody>\n</table>");

        string myTable = sb.ToString();
        Response.Write(myTable);
    }
read more