Read (Consume) JSON Data and display in GridView using C# and VB.Net in ASP.Net

Hi Amitabha,

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

HTML

<asp:GridView runat="server" ID="gvDetails"></asp:GridView>
<table>
    <tr>
        <td>ChallanNo:<asp:TextBox runat="server" ID="txtChallanNo" /></td>
    </tr>
    <tr>
        <td>TruckNo:<asp:TextBox runat="server" ID="txtTruckNo" /></td>
    </tr>
</table>

Namespaces

C#

using System.Collections.Generic;
using System.IO;
using Newtonsoft.Json;
using RestSharp;
using Newtonsoft.Json.Linq;

VB.Net

Imports System.Collections.Generic
Imports System.IO
Imports Newtonsoft.Json
Imports Newtonsoft.Json.Linq
Imports RestSharp

Code

C#

protected void btnGet_Click(object sender, EventArgs e)
{
    string Code = "";
    string LrNo = txtCnsNo.Text.Trim();
    RestClient restClient = new RestClient(string.Format("http://elplerp.in/api/LRInquiry.ashx?apiname=lrinquiry&code=" + Code + "&lrno=" + LrNo + ""));
    restClient.Timeout = -1;
    RestRequest request = new RestRequest();
    IRestResponse result = restClient.Execute(request);
    string array = ((JToken)JsonConvert.DeserializeObject(result.Content)).Root["data"].ToArray()[0].ToString();
    data[] data = JsonConvert.DeserializeObject<data[]>(array);
    this.gvDetails.DataSource = data[0].ChallanEntries;
    this.gvDetails.DataBind();
    txtChallanNo.Text = data[0].ChallanNo;
    txtTruckNo.Text = data[0].TruckNo;
}

public class data
{
    public int Id { get; set; }
    public string FromBranchCode { get; set; }
    public string ChallanNo { get; set; }
    public string Lrdate { get; set; }
    public string RoyaltyPassNo { get; set; }
    public string VehicleNo { get; set; }
    public string TruckNo { get; set; }
    public string Total { get; set; }
    public string ToBranchCode { get; set; }
    public string ToBranchName { get; set; }
    public string Station { get; set; }
    public string Package { get; set; }
    public double Freight { get; set; }
    public string CompanyName { get; set; }
    public string CustFullName { get; set; }
    public string BranchName { get; set; }
    public string ConsignorName { get; set; }
    public string ConsigneeName { get; set; }
    public string RecieveDate { get; set; }
    public string DeliveryDate { get; set; }
    public string AuditedDate { get; set; }
    public string Status { get; set; }
    public string AdminName { get; set; }
    public string GrossWeight { get; set; }
    public string CNType { get; set; }
    public string GodownName { get; set; }
    public string PODFileName { get; set; }
    public string UserType { get; set; }
    public string DelPersonName { get; set; }
    public string MrNo { get; set; }
    public string IsClosingEntry { get; set; }
    public string BookingTerms { get; set; }
    public string CrossingVehicle { get; set; }
    public string PartyInvoiceNo { get; set; }
    public List<ChallanEntries> ChallanEntries { get; set; }
    public string MachineQty { get; set; }
    public string StationAddress { get; set; }
    public string FromStation { get; set; }
    public string PrivateMarkSingle { get; set; }
    public string LRCarrierType { get; set; }
    public string TrackingDetail { get; set; }
    public string Dscc_ApprovalByText { get; set; }
}
public class ChallanEntries
{
    public string BranchCode { get; set; }
    public string ChallanNo { get; set; }
    public string BranchName { get; set; }
    public string ChallaDate { get; set; }
    public string Station { get; set; }
    public string ChlType { get; set; }
    public string Rate { get; set; }
    public string TotalWeight { get; set; }
    public string VehNo { get; set; }
    public string Frieght { get; set; }
    public string BrokerName { get; set; }
    public double Total { get; set; }
    public string Balance { get; set; }
    public string TransitDate { get; set; }
    public string TotalPkgs { get; set; }
    public string CarrierType { get; set; }
}

VB.Net

Protected Sub btnGet_Click(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
    Dim Code As String = ""
    Dim LrNo As String = txtCnsNo.Text.Trim()
    Dim restClient As RestClient = New RestClient(String.Format("http://elplerp.in/api/LRInquiry.ashx?apiname=lrinquiry&code=" & Code & "&lrno=" & LrNo & ""))
    restClient.Timeout = -1
    Dim request As RestRequest = New RestRequest()
    Dim result As IRestResponse = restClient.Execute(request)
    Dim array As String = (CType(JsonConvert.DeserializeObject(result.Content), JToken)).Root("data").ToArray()(0).ToString()
    Dim data As data() = JsonConvert.DeserializeObject(Of data())(array)
    Me.gvDetails.DataSource = data(0).ChallanEntries
    Me.gvDetails.DataBind()
    txtChallanNo.Text = data(0).ChallanNo
    txtTruckNo.Text = data(0).TruckNo
End Sub

Public Class data
    Public Property Id As Integer
    Public Property FromBranchCode As String
    Public Property ChallanNo As String
    Public Property Lrdate As String
    Public Property RoyaltyPassNo As String
    Public Property VehicleNo As String
    Public Property TruckNo As String
    Public Property Total As String
    Public Property ToBranchCode As String
    Public Property ToBranchName As String
    Public Property Station As String
    Public Property Package As String
    Public Property Freight As Double
    Public Property CompanyName As String
    Public Property CustFullName As String
    Public Property BranchName As String
    Public Property ConsignorName As String
    Public Property ConsigneeName As String
    Public Property RecieveDate As String
    Public Property DeliveryDate As String
    Public Property AuditedDate As String
    Public Property Status As String
    Public Property AdminName As String
    Public Property GrossWeight As String
    Public Property CNType As String
    Public Property GodownName As String
    Public Property PODFileName As String
    Public Property UserType As String
    Public Property DelPersonName As String
    Public Property MrNo As String
    Public Property IsClosingEntry As String
    Public Property BookingTerms As String
    Public Property CrossingVehicle As String
    Public Property PartyInvoiceNo As String
    Public Property ChallanEntries As List(Of ChallanEntries)
    Public Property MachineQty As String
    Public Property StationAddress As String
    Public Property FromStation As String
    Public Property PrivateMarkSingle As String
    Public Property LRCarrierType As String
    Public Property TrackingDetail As String
    Public Property Dscc_ApprovalByText As String
End Class

Public Class ChallanEntries
    Public Property BranchCode As String
    Public Property ChallanNo As String
    Public Property BranchName As String
    Public Property ChallaDate As String
    Public Property Station As String
    Public Property ChlType As String
    Public Property Rate As String
    Public Property TotalWeight As String
    Public Property VehNo As String
    Public Property Frieght As String
    Public Property BrokerName As String
    Public Property Total As Double
    Public Property Balance As String
    Public Property TransitDate As String
    Public Property TotalPkgs As String
    Public Property CarrierType As String
End Class