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);
}
{
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);
}

