XmlDocument - SelectNodes

Question

I have tried a fair few different ways without much look, I'm hoping someone will be able to help :-)

XML:

<?xml version="1.0" encoding="UTF-8"?>
<ListOrdersResponse xmlns="https://services.com/Orders/2013-09-01">
   <ListOrdersResult>
      <Orders>
         <Order>
            <Id>1</Id>
         </Order>
         <Order>
            <Id>2</Id>
         </Order>
      </Orders>
   </ListOrdersResult>
</ListOrdersResponse>

Tried:

var o =xmlDocument.SelectNodes("/ListOrdersResponse/ListOrdersResult/Orders/Order");
var o = xmlDocument.SelectNodes("/ListOrdersResponse/ListOrdersResult/Orders");
var o = xmlDocument.SelectNodes("//Orders");
var o = xmlDocument.SelectNodes("//Order");
var o = xmlDocument.SelectNodes("//Orders/Order");

var root = xmlDocument.DocumentElement;
var nsmgr = new XmlNamespaceManager(xmlDocument.NameTable);
nsmgr.AddNamespace("bk", "https://services.com/Orders/2013-09-01");
var orders = root.SelectNodes("descendant::bk:Orders/Order", nsmgr);

var root = xmlDocument.DocumentElement;
var nsmgr = new XmlNamespaceManager(xmlDocument.NameTable);
nsmgr.AddNamespace("bk", "https://services.com/Orders/2013-09-01");
var orders = root.SelectNodes("descendant::bk:Orders", nsmgr);

It just returns 0 records. :-(

What am I doing wrong?

Answer 1

How about using Linq2Xml? I find it easier to use.

XNamespace ns = "https://services.com/Orders/2013-09-01";
var orders = XDocument.Load(filename)
            .Descendants(ns + "Order")
            .Select(x => (int)x.Element(ns + "Id"))
            .ToList();

PS: Xml is case sensitive. Check your sample in question. <Order> and </order> etc.

Answer 2

The

var nsmgr = new XmlNamespaceManager(xmlDocument.NameTable);
nsmgr.AddNamespace("bk", "https://services.com/Orders/2013-09-01");

part is correct but then you need to use the prefix bk to qualify all element names in your XPath expressions e.g.

XmlNodeList orders = xmlDocument.SelectNodes("//bk:Orders/bk:Order", nsmgr);
foreach (XmlElement order in orders) {
  Console.WriteLine(order.SelectSingleNode("bk:Id", nsmgr).InnerText);
}