Fill XML data into StringBuilder from XmlTextReader : XMLTextReader « XML « ASP.NET Tutorial






<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="ReadXmlEfficient" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    <asp:Literal id="XmlText" runat="server"></asp:Literal>
    </div>
    </form>
</body>
</html>

File: Default.aspx.cs

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Text;
using System.Xml;

public partial class ReadXmlEfficient : System.Web.UI.Page
{
  protected void Page_Load(object sender, EventArgs e)
  {
    string xmlFile = Server.MapPath("Data.xml");

    XmlTextReader reader = new XmlTextReader(xmlFile);

    StringBuilder str = new StringBuilder();
    reader.ReadStartElement("DvdList");

    while (reader.Read())
    {
      if ((reader.Name == "DVD") && (reader.NodeType == XmlNodeType.Element))
      {
        reader.ReadStartElement("DVD");
        str.Append("<ul><b>");
        str.Append(reader.ReadElementString("Title"));
        str.Append("</b><li>");
        str.Append(reader.ReadElementString("Director"));
        str.Append("</li><li>");
        str.Append(String.Format("{0:C}",Decimal.Parse(reader.ReadElementString("Price"))));
        str.Append("</li></ul>");
      }
    }
    reader.Close();
    XmlText.Text = str.ToString();
  }

}

File: Data.xml

<?xml version="1.0"?>
<DvdList>
   <DVD ID="1" Category="Category 1">
      <Title>title 1</Title>
      <Director>directory 2</Director>
      <Price>1</Price>
      <Starring>
         <Star>star 1</Star>
         <Star>star 2</Star>
      </Starring>
   </DVD>
   <DVD ID="2" Category="Category 2">
      <Title>title 2</Title>
      <Director>directory 2</Director>
      <Price>2</Price>
      <Starring>
         <Star>star 3</Star>
         <Star>star 4</Star>
      </Starring>
   </DVD>
</DvdList>








25.15.XMLTextReader
25.15.1.Use XMLTextReader to read the data in an XML file (VB.net)
25.15.2.Fill XML data into StringBuilder from XmlTextReader
25.15.3.Read xml and build page along with it