How to read an XML file that contains a namespace?

[Pradeep]

..NETters,

This may be a simple question. However, I cannot figure out what I am
doing wrong. Would appreciate if someone can help me.

Here is my Sample.xml:

<Report>
</Report>

Here is my code to read it:

XmlDocument doc = new XmlDocument();
doc.Load("Sample.xml");

XPathNavigator nav = doc.CreateNavigator();
XPathExpression expr = nav.Compile("Report");

XPathNodeIterator iter = nav.Select(expr);
while(iter.MoveNext()) {
Console.WriteLine(iter.Current.Name);
}

In this case, the output is what I expect.

Now, I modified my xml file and added a namespace as follows:
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition">
</Report>

My earlier code does not work after this point. The node iterator does
not return any matching nodes. This is expected.

To fix this, I added the namespace manager object as follows:

XmlDocument doc = new XmlDocument();
doc.Load("Sample.xml");

XPathNavigator nav = doc.CreateNavigator();
XPathExpression expr = nav.Compile("Report");

// BEGIN INSERT NEW CODE
XmlNamespaceManager mngr = new XmlNamespaceManager(doc.NameTable);
mngr.AddNamespace("",
"http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition");
expr.SetContext(mngr);
// END INSERT NEW CODE

XPathNodeIterator iter = nav.Select(expr);
while(iter.MoveNext()) {
Console.WriteLine(iter.Current.Name);
}

The node iterator still does not return any matching nodes.

Can someone please enlighten me on what is my mistake?

Thank you in advance for your help.

Pradeep

[dsmyth]

Hello Pradeep,

You need to use a prefix when querying xml with xpath even if the xml is in the default namespace.

Try changing the following code...

XPathExpression expr = nav.Compile("/default:Report");

mngr.AddNamespace("default",
"http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition");

That should hopefully work now. I'm assuming the Report element is the root of the document as your xml wasn't displayed in your post.
---
Posted via DotNetSlackers.com

[dsmyth]

Hello Pradeep,

You need to use a prefix when querying xml with xpath even if the xml is in the default namespace.

Try changing the following code...

XPathExpression expr = nav.Compile("/default:Report");

mngr.AddNamespace("default",
"http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition");

That should hopefully work now. I'm assuming the Report element is the root of the document as your xml wasn't displayed in your post.
---
Posted via DotNetSlackers.com

[dsmyth]

Hello Pradeep,

You need to use a prefix when querying xml with xpath even if the xml is in the default namespace.

Try changing the following code...

XPathExpression expr = nav.Compile("/default:Report");

mngr.AddNamespace("default",
"http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition");

That should hopefully work now. I'm assuming the Report element is the root of the document as your xml wasn't displayed in your post.
---
Posted via DotNetSlackers.com

[dsmyth]

Hello Pradeep,

You need to use a prefix when querying xml with xpath even if the xml is in the default namespace.

Try changing the following code...

XPathExpression expr = nav.Compile("/default:Report");

mngr.AddNamespace("default",
"http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition");

That should hopefully work now. I'm assuming the Report element is the root of the document as your xml wasn't displayed in your post.
---
Posted via DotNetSlackers.com

[dsmyth]

Hello Pradeep,

You need to use a prefix when querying xml with xpath even if the xml is in the default namespace.

Try changing the following code...

XPathExpression expr = nav.Compile("/default:Report");

mngr.AddNamespace("default",
"http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition");

That should hopefully work now. I'm assuming the Report element is the root of the document as your xml wasn't displayed in your post.
---
Posted via DotNetSlackers.com

[dsmyth]

Hello Pradeep,

You need to use a prefix when querying xml with xpath even if the xml is in the default namespace.

Try changing the following code...

XPathExpression expr = nav.Compile("/default:Report");

mngr.AddNamespace("default",
"http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition");

That should hopefully work now. I'm assuming the Report element is the root of the document as your xml wasn't displayed in your post.
---
Posted via DotNetSlackers.com

[dsmyth]

Hello Pradeep,

You need to use a prefix when querying xml with xpath even if the xml is in the default namespace.

Try changing the following code...

XPathExpression expr = nav.Compile("/default:Report");

mngr.AddNamespace("default",
"http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition");

That should hopefully work now. I'm assuming the Report element is the root of the document as your xml wasn't displayed in your post.
---
Posted via DotNetSlackers.com

[dsmyth at dotnetslackers dot com]

Hello Pradeep,

You need to use a prefix when querying xml with xpath even if the xml is in the default namespace.

Try changing the following code...

XPathExpression expr = nav.Compile("/default:Report");

mngr.AddNamespace("default",
"http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition");

That should hopefully work now. I'm assuming the Report element is the root of the document as your xml wasn't displayed in your post.
---
Posted via DotNetSlackers.com

[dsmyth at dotnetslackers dot com]

Hello Pradeep,

You need to use a prefix when querying xml with xpath even if the xml is in the default namespace.

Try changing the following code...

XPathExpression expr = nav.Compile("/default:Report");

mngr.AddNamespace("default",
"http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition");

That should hopefully work now. I'm assuming the Report element is the root of the document as your xml wasn't displayed in your post.
---
Posted via DotNetSlackers.com