How to display xml data in asp.net

Question

Here is my xml file:

<?xml version="1.0" encoding="utf-8"?>
<entry>
 <comment Name="xxx" Location="India" Email="[email protected]" Gender="Male" />
 <comment Name="yyy" Location="usa" Email="[email protected]" Gender="Male" />
 <comment Name="zzz" Location="uae" Email="[email protected]" Gender="Male" />
 <comment Name="abc" Location="china" Email="[email protected]" Gender="Male" />
</entry>

How do I display only the comment tags' data (e.g. name,location,email,gender) in ASP.NET? Please help. Thank you.

you should also upvote answers that best adresses ur needs

user1499112
– user1499112

2012-08-07 05:35:41 +00:00
Commented Aug 7, 2012 at 5:35 — user1499112
– user1499112, Commented Aug 7, 2012 at 5:35

Community · Accepted Answer · 2020-06-20 09:12:55Z

1

Output

enter image description here

Code Behind

using (DataSet ds = new DataSet())
{
    ds.ReadXml(MapPath("XMLFile1.xml"));
    grd.DataSource = ds;
    grd.DataBind();
}

Mark Up

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

Add an Xml File in the Project

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Aug 5, 2012 at 6:21

user1499112

Sign up to request clarification or add additional context in comments.

Comments

Waqar Janjua · Accepted Answer · 2012-08-05 06:57:37Z

You can use an Xml Data Source with Tree view, Repeater control as

<asp:XmlDataSource ID="XmlDataSource1" runat="server" DataFile="~/XMLFile.xml" XPath="entry" >
</asp:XmlDataSource>

//Repeater
<asp:Repeater ID="Repeater1"
    runat="server"
    DataSourceID="XmlDataSource1">
    <ItemTemplate>
        <h2>Entry</h2>
        <table>
          <tr>                
            <td><%#XPath("comment[1]/@Name")%></td>
            <td><%#XPath("comment[1]/@Location")%></td>
            <td><%#XPath("comment[1]/@Email")%></td>
               <td><%#XPath("comment[1]/@Gender")%></td>
          </tr>   
            <tr>               
            <td><%#XPath("comment[2]/@Name")%></td>
            <td><%#XPath("comment[2]/@Location")%></td>
            <td><%#XPath("comment[2]/@Email")%></td>
               <td><%#XPath("comment[2]/@Gender")%></td>
          </tr>                             
            <td><%#XPath("comment[3]/@Name")%></td>
            <td><%#XPath("comment[3]/@Location")%></td>
            <td><%#XPath("comment[3]/@Email")%></td>
               <td><%#XPath("comment[3]/@Gender")%></td>
          </tr>   
            <tr>                
            <td><%#XPath("comment[4]/@Name")%></td>
            <td><%#XPath("comment[4]/@Location")%></td>
            <td><%#XPath("comment[4]/@Email")%></td>
               <td><%#XPath("comment[4]/@Gender")%></td>
          </tr>                    
        </table>                     
    </ItemTemplate>
</asp:Repeater>

// Output 
Entry

xxx India   [email protected]   Male
yyy usa [email protected]   Male
zzz uae [email protected]   Male
abc china   [email protected]   Male

Collectives™ on Stack Overflow

How to display xml data in asp.net

2 Answers 2

Output

Code Behind

Mark Up

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Output

Code Behind

Mark Up

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related