Read and display XML response in GridView in ASP.Net

Hi Alauddin,

Please refer below sample.

HTML

<div>
    <asp:GridView ID="gvXML" runat="server">
    </asp:GridView>
</div>

Namespaces

C#

using System;
using System.Linq;
using System.Data;

VB.Net

Imports System.Xml
Imports System.Data

Code

C#

protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        DataSet ds = new DataSet();
        ds.ReadXml(Server.MapPath("XMLFile.xml"));
        DataTable dtaccountDetail = ds.Tables["accountLists"];
        DataTable dtreturn = ds.Tables["return"];

        var list = (from returnid in dtreturn.AsEnumerable()
                    join accountdeatails in dtaccountDetail.AsEnumerable() on returnid["return_Id"] equals accountdeatails["return_Id"]
                    select new
                    {
                        accountName = accountdeatails["accountName"],
                        responseTime = returnid["responseTime"],
                        status = returnid["status"],
                        accountNumber = accountdeatails["accountNumber"],
                        accountStatus = accountdeatails["accountStatus"],
                        accountType = accountdeatails["accountType"],
                        customerId = accountdeatails["customerId"],
                    }).ToList();
        DataTable dt = new DataTable();
        dt.Columns.Add("accountName", typeof(string));
        dt.Columns.Add("responseTime", typeof(string));
        dt.Columns.Add("status", typeof(string));
        dt.Columns.Add("accountNumber", typeof(string));
        dt.Columns.Add("accountStatus", typeof(string));
        dt.Columns.Add("accountType", typeof(string));
        dt.Columns.Add("customerId", typeof(string));
        foreach (var rows in list)
        {
            dt.Rows.Add(rows.accountName, rows.responseTime, rows.status, rows.accountNumber, rows.accountStatus, rows.accountType, rows.customerId);
        }

        gvXML.DataSource = dt;
        gvXML.DataBind();
    }
}

VB.Net

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
    If Not Me.IsPostBack Then
        Dim ds As DataSet = New DataSet()
        ds.ReadXml(Server.MapPath("XMLFile.xml"))
        Dim dtaccountDetail As DataTable = ds.Tables("accountLists")
        Dim dtreturn As DataTable = ds.Tables("return")
        Dim list = (From returnid In dtreturn.AsEnumerable() Join accountdeatails In dtaccountDetail.AsEnumerable() On returnid("return_Id") Equals accountdeatails("return_Id")
                    Select New With
                           {Key .accountName = accountdeatails("accountName"), Key .responseTime = returnid("responseTime"), Key .status = returnid("status"), Key .accountNumber = accountdeatails("accountNumber"), Key .accountStatus = accountdeatails("accountStatus"), Key .accountType = accountdeatails("accountType"), Key .customerId = accountdeatails("customerId")
        }).ToList()
        Dim dt As DataTable = New DataTable()
        dt.Columns.Add("accountName", GetType(String))
        dt.Columns.Add("responseTime", GetType(String))
        dt.Columns.Add("status", GetType(String))
        dt.Columns.Add("accountNumber", GetType(String))
        dt.Columns.Add("accountStatus", GetType(String))
        dt.Columns.Add("accountType", GetType(String))
        dt.Columns.Add("customerId", GetType(String))

        For Each rows In list
            dt.Rows.Add(rows.accountName, rows.responseTime, rows.status, rows.accountNumber, rows.accountStatus, rows.accountType, rows.customerId)
        Next

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

Screenshot