Mega Code Archive
Displaying XML Data in a GridView and a ListBox
<![CDATA[
<%@ Page Language="C#" %>
<%@ Import Namespace="System.Xml" %>
<html xmlns="http://www.w3.org/1999/xhtml" >
<head>
<title>Displaying XML Data in a GridView and a ListBox</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:ListBox ID="lstTitles" Runat="server" DataSourceID="bookSource" DataValueField="ISBN"
DataTextField="Title"/>
</div>
<div>
<asp:GridView ID="bookView" Runat="server" DataSourceID="bookSource" AutoGenerateColumns="False">
<Columns>
<asp:BoundField HeaderText="ISBN" DataField="ISBN" SortExpression="ISBN"></asp:BoundField>
<asp:BoundField HeaderText="Title" DataField="Title" SortExpression="Title"></asp:BoundField>
<asp:BoundField HeaderText="Price" DataField="Price" SortExpression="Price"></asp:BoundField>
</Columns>
</asp:GridView>
</div>
<div>
<asp:XmlDataSource ID="bookSource" Runat="server" DataFile="~/Data.xml"
XPath="Data/genre[@name ='Fiction']/book">
</asp:XmlDataSource> </div>
</form>
</body>
</html>
File: ~/Data.xml
<Data>
<genre name="Fiction">
<book ISBN="1" Title="title 1" Price="19.99" Discount="1.999">
<chapter num="1" name="Introduction">
Abstract...
</chapter>
<chapter num="2" name="Body">
Abstract...
</chapter>
<chapter num="3" name="Conclusion">
Abstract...
</chapter>
</book>
</genre>
<genre name="NonFiction">
<book ISBN="2" Title="title 2" Price="27.95" Discount="2.795">
<chapter num="1" name="Introduction">
Abstract...
</chapter>
<chapter num="2" name="Body">
Abstract...
</chapter>
<chapter num="3" name="Conclusion">
Abstract...
</chapter>
</book>
</genre>
</Data>
]]>