Display JSON response in HTML Table using C# and VB.Net in ASP.Net

Hi Jilsoft,

Please refer below sample.

HTML

<asp:Label ID="lblOffices" runat="server" Style="float: left; top: 0px;" />
<asp:Label ID="lblOfficials" runat="server" Style="float: left; top: 0px; padding-left: 10px;" />

Namespaces

C#

using System.IO;
using System.Text;
using Newtonsoft.Json;

VB.Net

Imports System.IO
Imports System.Text
Imports Newtonsoft.Json

Code

C#

protected void Page_Load(object sender, EventArgs e)
{
    string json = File.ReadAllText(Server.MapPath("~/Json.txt"));
    Root root = JsonConvert.DeserializeObject<Root>(json);
    StringBuilder sb = new StringBuilder();
    sb.Append("<table><tr><th>Name</th></tr>");
    for (int i = 0; i < root.offices.Count; i++)
    {
        sb.Append("<tr><td>" + root.offices[i].name + "</td></tr>");
    }
    sb.Append("</table>");
    lblOffices.Text = sb.ToString();

    sb = new StringBuilder();
    sb.Append("<table><tr><th>Name</th><th>Phones</th><th>Email</th></tr>");
    for (int i = 0; i < root.officials.Count; i++)
    {
        sb.Append("<tr>");
        sb.Append("<td>" + root.officials[i].name + "</td>");
        string phones = "<table>";
        for (int j = 0; j < root.officials[i].phones.Count; j++)
        {
            phones += "<tr><td>" + root.officials[i].phones[j] + "</td></tr>";
        }
        phones += "</table>";
        sb.Append("<td>" + phones + "</td>");
        string emails = "";
        if (root.officials[i].emails != null)
        {
            emails += "<table>";
            for (int j = 0; j < root.officials[i].emails.Count; j++)
            {
                emails += "<tr><td>" + root.officials[i].emails[j] + "</td></tr>";
            }
            emails += "</table>";
        }

        sb.Append("<td>" + emails + "</td>");
        sb.Append("</tr>");
    }
    sb.Append("</table>");
    lblOfficials.Text = sb.ToString();
}

public class Address
{
    public string line1 { get; set; }
    public string city { get; set; }
    public string state { get; set; }
    public string zip { get; set; }
    public string line2 { get; set; }
    public string line3 { get; set; }
}

public class Channel
{
    public string type { get; set; }
    public string id { get; set; }
}

public class Divisions
{
    [JsonProperty("ocd-division/country:us")]
    public OcdDivisionCountryUs OcdDivisionCountryUs { get; set; }

    [JsonProperty("ocd-division/country:us/state:tx")]
    public OcdDivisionCountryUsStateTx OcdDivisionCountryUsStateTx { get; set; }
}

public class FeatureId
{
    public string cellId { get; set; }
    public string fprint { get; set; }
}

public class GeocodingSummary
{
    public string queryString { get; set; }
    public FeatureId featureId { get; set; }
    public string featureType { get; set; }
    public double positionPrecisionMeters { get; set; }
    public bool addressUnderstood { get; set; }
}

public class NormalizedInput
{
    public string line1 { get; set; }
    public string city { get; set; }
    public string state { get; set; }
    public string zip { get; set; }
}

public class OcdDivisionCountryUs
{
    public string name { get; set; }
    public List<int> officeIndices { get; set; }
}

public class OcdDivisionCountryUsStateTx
{
    public string name { get; set; }
    public List<int> officeIndices { get; set; }
}

public class Office
{
    public string name { get; set; }
    public string divisionId { get; set; }
    public List<string> levels { get; set; }
    public List<string> roles { get; set; }
    public List<int> officialIndices { get; set; }
}

public class Official
{
    public string name { get; set; }
    public List<Address> address { get; set; }
    public string party { get; set; }
    public List<string> phones { get; set; }
    public List<string> urls { get; set; }
    public List<Channel> channels { get; set; }
    public List<GeocodingSummary> geocodingSummaries { get; set; }
    public string photoUrl { get; set; }
    public List<string> emails { get; set; }
}

public class Root
{
    public NormalizedInput normalizedInput { get; set; }
    public string kind { get; set; }
    public Divisions divisions { get; set; }
    public List<Office> offices { get; set; }
    public List<Official> officials { get; set; }
}

VB.Net

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
    Dim json As String = File.ReadAllText(Server.MapPath("~/Json.txt"))
    Dim root As Root = JsonConvert.DeserializeObject(Of Root)(json)
    Dim sb As StringBuilder = New StringBuilder()
    sb.Append("<table><tr><th>Name</th></tr>")
    For i As Integer = 0 To root.offices.Count - 1
        sb.Append("<tr><td>" & root.offices(i).name & "</td></tr>")
    Next
    sb.Append("</table>")
    lblOffices.Text = sb.ToString()
    sb = New StringBuilder()
    sb.Append("<table><tr><th>Name</th><th>Phones</th><th>Email</th></tr>")

    For i As Integer = 0 To root.officials.Count - 1
        sb.Append("<tr>")
        sb.Append("<td>" & root.officials(i).name & "</td>")
        Dim phones As String = "<table>"
        For j As Integer = 0 To root.officials(i).phones.Count - 1
            phones += "<tr><td>" & root.officials(i).phones(j) & "</td></tr>"
        Next
        phones += "</table>"
        sb.Append("<td>" & phones & "</td>")
        Dim emails As String = ""

        If root.officials(i).emails IsNot Nothing Then
            emails += "<table>"
            For j As Integer = 0 To root.officials(i).emails.Count - 1
                emails += "<tr><td>" & root.officials(i).emails(j) & "</td></tr>"
            Next
            emails += "</table>"
        End If
        sb.Append("<td>" & emails & "</td>")
        sb.Append("</tr>")
    Next
    sb.Append("</table>")
    lblOfficials.Text = sb.ToString()
End Sub

Public Class Address
    Public Property line1 As String
    Public Property city As String
    Public Property state As String
    Public Property zip As String
    Public Property line2 As String
    Public Property line3 As String
End Class

Public Class Channel
    Public Property type As String
    Public Property id As String
End Class

Public Class Divisions
    <JsonProperty("ocd-division/country:us")>
    Public Property OcdDivisionCountryUs As OcdDivisionCountryUs
    <JsonProperty("ocd-division/country:us/state:tx")>
    Public Property OcdDivisionCountryUsStateTx As OcdDivisionCountryUsStateTx
End Class

Public Class FeatureId
    Public Property cellId As String
    Public Property fprint As String
End Class

Public Class GeocodingSummary
    Public Property queryString As String
    Public Property featureId As FeatureId
    Public Property featureType As String
    Public Property positionPrecisionMeters As Double
    Public Property addressUnderstood As Boolean
End Class

Public Class NormalizedInput
    Public Property line1 As String
    Public Property city As String
    Public Property state As String
    Public Property zip As String
End Class

Public Class OcdDivisionCountryUs
    Public Property name As String
    Public Property officeIndices As List(Of Integer)
End Class

Public Class OcdDivisionCountryUsStateTx
    Public Property name As String
    Public Property officeIndices As List(Of Integer)
End Class

Public Class Office
    Public Property name As String
    Public Property divisionId As String
    Public Property levels As List(Of String)
    Public Property roles As List(Of String)
    Public Property officialIndices As List(Of Integer)
End Class

Public Class Official
    Public Property name As String
    Public Property address As List(Of Address)
    Public Property party As String
    Public Property phones As List(Of String)
    Public Property urls As List(Of String)
    Public Property channels As List(Of Channel)
    Public Property geocodingSummaries As List(Of GeocodingSummary)
    Public Property photoUrl As String
    Public Property emails As List(Of String)
End Class

Public Class Root
    Public Property normalizedInput As NormalizedInput
    Public Property kind As String
    Public Property divisions As Divisions
    Public Property offices As List(Of Office)
    Public Property officials As List(Of Official)
End Class

Screenshot