As an addition to my latest article, this entry will show you how to harness the power of XPath by example.
XPath is a query language for XML, akin to SQL for relational databases (ok, loosely akin!) which is used to extract nodes from an XML file.
Let’s take a look at some examples:
Here’s our XML file to parse:
We can use XPath queries through the XmlDocument.SelectNodes method to return a set of nodes matching our query. Let’s set this up:
string fileName = Server.MapPath("catalog.xml");
XmlDocument doc = new XmlDocument();
Our XmlDocument is now ready to query. Rather than explain the specifics of the query language, I think its better to show by example. The full details of XPath can be found here.
OK, let’s select all the CDs in our catalog:
XmlNodeList cdNodes = doc.SelectNodes("catalog/cd");
Easy eh? Notice, we just write out the “path” of where our nodes are found in the XML file, using / to signify a level of hierarchy.
Let’s get a little more complicated. The following XPath expression will select all CDs which are by the artist Oasis:
XmlNodeList cdNodes = doc.SelectNodes("//cd[artist='Oasis']");
Notice the double slash at the start of this expression. The double slash tells XPath to look at any CD element it comes across, regardless of where exactly it is within the hierarchy. In reality, the double slash saves us time by allowing us not to write out the whole hierarchy path (if you did, it would be “catalog/cd[artist=’Oasis’]”)
The second difference with this expression is that we’re asking for all nodes which have an artist subelement equal to Oasis. The square bracket is used to signify any type of query. We can combine these queries using regular “and”s and “or”s.
Lastly, I’ll show how to grab a particular node from an element. The following query will return the price of all Beatles CDs in our catalog:
XmlNodeList cdNodes = doc.SelectNodes("//cd[artist='The Beatles']/price");
So ends a quick guide to XPath :)
A Comparison of Ruby Version Managers for macOS
By Daniel Kehoe,
If you're a serious Ruby developer, you'll need an up-to-date version, possibly several. We cover the best Ruby version managers for macOS.
A Guide to Git Interactive Rebase, with Practical Examples
By Tobias Günther,
Even if you're a Git pro, there might be more Git tricks to discover. Learn about interactive rebase, one of Git's most powerful tools.
Introduction to Data Types: Static, Dynamic, Strong & Weak
By Tim Hurd,
Static, dynamic, strong, weak data types? Are you confused? Learn what these terms really mean, and which is best for you.