Implement filtering in ASP.Net GridView with JSON data based on TextBox value using C# and VB.Net

Hi kid.live,

Refer below code.

HTML

Branch Number:
<asp:TextBox runat="server" ID="txtBranchNumber" Text="004" />
<br />
Machine Number:
<asp:TextBox runat="server" ID="txtMachineNumber" Text="5M-20" />
<br />
<asp:Button Text="Search" runat="server" OnClick="Search" />
<hr />
<asp:GridView runat="server" ID="gvDetails"></asp:GridView>

Namespaces

C#

using System.Net;
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;

VB.Net

Imports System.Net
Imports Newtonsoft.Json
Imports Newtonsoft.Json.Linq

Code

C#

protected void Search(object sender, EventArgs e)
{
    ServicePointManager.Expect100Continue = true;
    ServicePointManager.SecurityProtocol = (SecurityProtocolType)3072;
    string json = (new WebClient()).DownloadString("https://fuel-station-d8853-default-rtdb.firebaseio.com/invoices-prod.json");
    JToken result = JsonConvert.DeserializeObject("[" + json + "]") as JToken;
    List<Root> roots = new List<Root>();
    foreach (var item in result)
    {
        JObject obj = JObject.Parse(item.ToString());
        foreach (var keypair in obj)
        {
            if (keypair.Key == txtBranchNumber.Text)
            {
                foreach (var keypair1 in JObject.Parse(keypair.Value.ToString()))
                {
                    if (keypair1.Key == txtMachineNumber.Text)
                    {
                        foreach (var item1 in JObject.Parse(keypair1.Value.ToString()))
                        {
                            roots.Add(JsonConvert.DeserializeObject<Root>(item1.Value.ToString()));
                        }                            
                    }
                }
            }
        }
    }
    gvDetails.DataSource = roots;
    gvDetails.DataBind();
}

public class Root
{
    public string branch_num { get; set; }
    public DateTime date { get; set; }
    public string invoice_number { get; set; }
    public string item { get; set; }
    public string machineID { get; set; }
    public string payment_type { get; set; }
    public double price { get; set; }
    public double qty { get; set; }
    public double total { get; set; }
    public string userID { get; set; }
    public double vat_amount { get; set; }
}

VB.Net

Protected Sub Search(ByVal sender As Object, ByVal e As EventArgs)
    ServicePointManager.Expect100Continue = True
    ServicePointManager.SecurityProtocol = CType(3072, SecurityProtocolType)
    Dim json As String = (New WebClient()).DownloadString("https://fuel-station-d8853-default-rtdb.firebaseio.com/invoices-prod.json")
    Dim result As JToken = TryCast(JsonConvert.DeserializeObject("[" & json & "]"), JToken)
    Dim roots As List(Of Root) = New List(Of Root)()
    For Each item In result
        Dim obj As JObject = JObject.Parse(item.ToString())
        For Each keypair In obj
            If keypair.Key = txtBranchNumber.Text Then
                For Each keypair1 In JObject.Parse(keypair.Value.ToString())
                    If keypair1.Key = txtMachineNumber.Text Then
                        For Each item1 In JObject.Parse(keypair1.Value.ToString())
                            roots.Add(JsonConvert.DeserializeObject(Of Root)(item1.Value.ToString()))
                        Next
                    End If
                Next
            End If
        Next
    Next

    gvDetails.DataSource = roots
    gvDetails.DataBind()
End Sub

Public Class Root
    Public Property branch_num As String
    <JsonProperty("date")>
    Public Property _date As DateTime
    Public Property invoice_number As String
    Public Property item As String
    Public Property machineID As String
    Public Property payment_type As String
    Public Property price As Double
    Public Property qty As Double
    Public Property total As Double
    Public Property userID As String
    Public Property vat_amount As Double
End Class

Screenshot