Bind JSON string in ASP.Net GridView using C# and VB.Net

Hi Amitabha,

Check this example. Now please take its reference and correct your code.

HTML

<asp:GridView runat="server" ID="GridView1"></asp:GridView>

Code

C#

protected void Page_Load(object sender, EventArgs e)
{
    // Read the json string using IRestResponse.
    string ms = System.IO.File.ReadAllText(Server.MapPath("~/json.json"));
    Vehicle EResponse = Newtonsoft.Json.JsonConvert.DeserializeObject<Vehicle>(ms);
    if (EResponse.message.ToString() == "Success")
    {
        GridView1.AutoGenerateColumns = true;
        GridView1.DataSource = EResponse.onlineDataList.Select(x=>x.vehicleId);
        GridView1.DataBind();
    }
}


public class Vehicle
{
    public int code { get; set; }
    public string message { get; set; }
    public List<OnlineDataList> onlineDataList { get; set; }
    public string vehicleId { get; set; }
}

public class OnlineDataList
{
    public string address { get; set; }
    public string dailyMileage { get; set; }
    public object dateTime { get; set; }
    public bool engine { get; set; }
    public bool freeWheelAlert { get; set; }
    public string gpsdate { get; set; }
    public string haltDuration { get; set; }
    public bool harshBrakeAlert { get; set; }
    public bool idleAlert { get; set; }
    public string latitude { get; set; }
    public string longitude { get; set; }
    public int odometer { get; set; }
    public bool overSpeedAlert { get; set; }
    public int speed { get; set; }
    public string temperature { get; set; }
    public string unitId { get; set; }
    public string vehicleId { get; set; }
}

VB.Net

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
    ' Read the json string using IRestResponse.
    Dim ms As String = IO.File.ReadAllText(Server.MapPath("~/json.json"))
    Dim EResponse As Vehicle = Newtonsoft.Json.JsonConvert.DeserializeObject(Of Vehicle)(ms)
    If EResponse.message.ToString() = "Success" Then
        GridView1.AutoGenerateColumns = True
        GridView1.DataSource = EResponse.onlineDataList.Select(Function(x) x.vehicleId)
        GridView1.DataBind()
    End If
End Sub

Public Class Vehicle
    Public Property code As Integer
    Public Property message As String
    Public Property onlineDataList As List(Of OnlineDataList)
    Public Property vehicleId As String
End Class

Public Class OnlineDataList
    Public Property address As String
    Public Property dailyMileage As String
    Public Property dateTime As Object
    Public Property engine As Boolean
    Public Property freeWheelAlert As Boolean
    Public Property gpsdate As String
    Public Property haltDuration As String
    Public Property harshBrakeAlert As Boolean
    Public Property idleAlert As Boolean
    Public Property latitude As String
    Public Property longitude As String
    Public Property odometer As Integer
    Public Property overSpeedAlert As Boolean
    Public Property speed As Integer
    Public Property temperature As String
    Public Property unitId As String
    Public Property vehicleId As String
End Class

Output