Parse error while reading Json data from Url in ASP.Net

Hi gauravjain,

Refer below sample.

HTML

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

Namespaces

C#

using System.Data;
using System.IO;
using System.Net;
using Newtonsoft.Json;

VB.Net

Imports System.Data
Imports System.IO
Imports System.Net
Imports Newtonsoft.Json

Code

C#

protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        string json = (new WebClient()).DownloadString("http://103.7.130.119/wbes/Report/GetDeclarationReport?regionId=2&date=15-02-2020&revision=97&utilId=d60942af-46df-44ad-ab49-adf1652a8ac0&isBuyer=0&byOnBar=0&byDCSchd=1").Replace("{\"jaggedarray\":", "").Replace("}", "");
        string[][] array = JsonConvert.DeserializeObject<string[][]>(json);
        DataTable dt = new DataTable();
        for (int i = 0; i < array[1].Length; i++)
        {
            dt.Columns.Add(array[1][i]);
        }
        for (int i = 2; i < array.Length; i++)
        {
            DataRow dr = dt.NewRow();
            for (int j = 0; j < array[i].Length; j++)
            {
                dr[j] = array[i][j];
            }
            dt.Rows.Add(dr);
        }
        GridView1.DataSource = dt;
        GridView1.DataBind();
    }
}

VB.Net

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
    If Not Me.IsPostBack Then
        Dim json As String = (New WebClient()).DownloadString("http://103.7.130.119/wbes/Report/GetDeclarationReport?regionId=2&date=15-02-2020&revision=97&utilId=d60942af-46df-44ad-ab49-adf1652a8ac0&isBuyer=0&byOnBar=0&byDCSchd=1").Replace("{""jaggedarray"":", "").Replace("}", "")      
        Dim array As String()() = JsonConvert.DeserializeObject(Of String()())(json)
        Dim dt As DataTable = New DataTable()
        For i As Integer = 0 To array(1).Length - 1
            dt.Columns.Add(array(1)(i))
        Next
        For i As Integer = 2 To array.Length - 1
            Dim dr As DataRow = dt.NewRow()
            For j As Integer = 0 To array(i).Length - 1
                dr(j) = array(i)(j)
            Next
            dt.Rows.Add(dr)
        Next

        GridView1.DataSource = dt
        GridView1.DataBind()
    End If
End Sub