TopXML SQL XML library : How to display the first three nodes of a XML file with XmlDocument?

Home Page

Add/Edit your code items

Search the code library

Browse for the code library

SQL XML
SQL XML
SQL XML Contents
What is the usage of the XmlDataDocument?

By	Sonu Kapoor
First Posted	02/20/2005
Times viewed	173

How to display the first three nodes of a XML file with XmlDocument?

Summary How to display the first three nodes of a XML file with XmlDocument?

Some websites only shows the latest 3 articles or news on their website. Mainly they are using a SQL Server as a backend. However the same task can be accomplished with XML. In this small example you will learn how you can retrieve only the top 3 XML items. The key is to use again the SelectNodes function, with the position function. position is a XPath function which returns the position of the current node. Here is the xml file I am using for that example.

Output:

description of the 1st news description of the 2nd news description of the 3rd news

As you can see the XML file contains 5 items, however only 3 are displayed.

Additional information
<%@ import namespace="System.Xml" %> <%@ page language="C#" debug="true"%> <script runat="server"> void page_load(object sender, System.EventArgs e){ // Create a new XmlDocument object XmlDocument xmlDoc = new XmlDocument(); // Load the xml file into the object xmlDoc.Load(Server.MapPath("XmlDocumentWithSelect3Nodes.xml")); // Select only 3 top nodes XmlNodeList nodeList = xmlDoc.SelectNodes("/NewsList/News[position() <= 3~"); // Iterate through the nodeList for(int i=0;i<nodeList.Count;i++) { // Printout the news Response.Write(nodeList[i~.InnerXml+"/n"); } } </script>

Further additional information
<?xml version="1.0" encoding="utf-8"?> <NewsList> <News> <Title>1st news title</Title> <Description>description of the 1st news</Description> </News> <News> <Title>2nd news title</Title> <Description>description of the 2nd news</Description> </News> <News> <Title>3rd news title</Title> <Description>description of the 3rd news</Description> </News> <News> <Title>4th news title</Title> <Description>description of the 4th news</Description> </News> <News> <Title>5th news title</Title> <Description>description of the 5th news</Description> </News> </NewsList>

Rate this article on a scale of 1 to 10 (0 votes, average 0)

Your vote :

<< SEO System.XML >>


Leave a comment for this article
Your name
Your email (optional)
Your comment
Optional: Upload an attachment
Enter the code shown:



	Recent Jobs Software Developers Needed in Charlotte, Sr. Software Engineer - Analytics Immediate Mainframe openings for Chennai Immediate TANDEM-TAL openings for Chenna Immediate ASP.NET/C# Openings for Chandi View all Jobs (Add yours) View all CV (Add yours)

	conference calling swimming pool builder spfxmasks water softener Teleconference Host Department NOLIMIT Web Hosting MSN sunglasses

	Partners Dream.In.Code dotNet Slackers dotNet Spider Your HTML Source VisualBuilder.com DevGuru Planet Source Code ZVON.ORG Web Design ASPAlliance XML Pitstop Scripts The Spot 4 SAP Bitshop Web Hosting

Email TopXML