XPath Search : XPath « XML « ASP.NET Tutorial






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

<!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.Xml;
using System.Text;

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

    XmlNodeList nodes = doc.SelectNodes("/DvdList/DVD/Title[../@Category='Category 1']");

    StringBuilder str = new StringBuilder();
    foreach (XmlNode node in nodes)
    {
      str.Append("Found: <b>");
      str.Append(node.ChildNodes[0].Value);
      str.Append("</b><br>");
    }
    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.17.XPath
25.17.1.Use XPath to navigate XML document (VB.net)
25.17.2.Use XPath to query XML data (VB.net)
25.17.3.XPath Navigator Read
25.17.4.XPath Search
25.17.5.Querying XML with XPathDocument and XPathNodeIterator (C#)
25.17.6.Querying XML with XPathDocument and XPathNodeIterator (VB)