Read XML string from database and bind to Reepater (GridView) in ASP.Net

Hi Sudar,

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

SQL

CREATE TABLE SportsXml
(
	ID INT IDENTITY,
	XmlData NVARCHAR(MAX)
)
GO
INSERT INTO SportsXml VALUES('<data><Name>Test</Name><Date>5/15/2018</Date><CoachName>test test</CoachName><Course>Storyboarding</Course></data>')
GO
CREATE PROCEDURE GetXml
AS
BEGIN
    SELECT XmlData
    FROM SportsXml
END

HTML

<asp:Repeater runat="server" ID="Repeater1">
    <HeaderTemplate>
        <table>
            <tr>
                <th>Name</th>
                <th>Date</th>
                <th>Coach</th>
                <th>Course</th>
            </tr>
    </HeaderTemplate>
    <ItemTemplate>
        <tr>
            <td>
                <asp:Label ID="lblName" runat="server" Text='<%# Eval("Name") %>' />
            </td>
            <td>
                <asp:Label ID="lblDate" runat="server" Text='<%# Eval("Date") %>' />
            </td>
            <td>
                <asp:Label ID="lblCoachName" runat="server" Text='<%# Eval("CoachName") %>' />
            </td>
            <td>
                <asp:Label ID="lblCourse" runat="server" Text='<%# Eval("Course") %>' />
            </td>
        </tr>
    </ItemTemplate>
    <FooterTemplate>
        </table>
    </FooterTemplate>
</asp:Repeater>

Namespaces

C#

using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.IO;

VB.Net

Imports System.Configuration
Imports System.Data
Imports System.Data.SqlClient
Imports System.IO

Code

C#

protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        StringReader sr;
        string conString = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
        using (SqlCommand cmd = new SqlCommand("GetXml"))
        {
            using (SqlConnection con = new SqlConnection(conString))
            {
                cmd.Connection = con;
                cmd.CommandType = CommandType.StoredProcedure;
                con.Open();
                sr = new StringReader(cmd.ExecuteScalar().ToString());
                con.Close();
            }
        }
        DataSet ds = new DataSet();
        ds.ReadXml(sr);
        this.Repeater1.DataSource = ds;
        this.Repeater1.DataBind();
    }
}

VB.Net

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
    If Not Me.IsPostBack Then
        Dim sr As StringReader
        Dim conString As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
        Dim cmd As SqlCommand = New SqlCommand("GetXml")
        Dim con As SqlConnection = New SqlConnection(conString)
        cmd.Connection = con
        cmd.CommandType = CommandType.StoredProcedure
        con.Open
        sr = New StringReader(cmd.ExecuteScalar.ToString)
        con.Close
        Dim ds As DataSet = New DataSet
        ds.ReadXml(sr)
        Me.Repeater1.DataSource = ds
        Me.Repeater1.DataBind
    End If        
End Sub

Screenshot