How to extract XML data

Question

I have a XML file that has the following data,

<extcode Type="abc" Code="12345" />

I want to be able to extract the Code, i.e., 12345, for rows where Type is abc. I tried

XPathSelectElements("Type[@name='abc']")

but it returned nothing.

Thanks.

Edit I figured out that the problem is with namespace. The XML file is like aw:extcode instead of just extcode and that caused the query to not work properly. How should I do it in the presence of namespace? When I tried to use

XmlNameTable nameTable = doc.NameTable;

compiler complains that it can't resolve NameTable.

Good question, +1. See my answer for a list of several alternative ways to evaluate an XPath expression on an XML document with namespaces. I have included a collection of links to the relevant MSDN documentation. — Dimitre Novatchev
– Dimitre Novatchev, Commented Jul 7, 2011 at 13:33

Kirill Polishchuk · Accepted Answer · 2011-07-07 08:43:00Z

3

Use this XPath: //extcode[@Type = 'abc']/@Code

answered Jul 7, 2011 at 8:43

Kirill Polishchuk

56.4k11 gold badges125 silver badges127 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jon Skeet · Accepted Answer · 2011-07-07 08:34:49Z

2

Personally I'd use LINQ to XML, as my preferred way of working with XML data. Something like this:

XDocument doc = XDocument.Load("test.xml");

int code = doc.Descendants("extCode")
              .Where(x => (string) x.Attribute("Type") == "abc")
              .First()
              .Attribute("Code");

One reason why your XPath isn't working may be that the attribute is called "Type" rather than "name" though...

answered Jul 7, 2011 at 8:34

Jon Skeet

1.5m893 gold badges9.3k silver badges9.3k bronze badges

1 Comment

David Anderson Over a year ago

+1 for LINQ to XML as its a good way to write code in a more expressable manner.

shenhengbin · Accepted Answer · 2011-07-07 08:53:37Z

0

you can write like this ↓

        XDocument doc = XDocument.Load("test.xml");
        var x = doc.Root.XPathSelectElement("./extcode[@Type='abc']");
        Console.WriteLine("x:" + x.ToString());

answered Jul 7, 2011 at 8:53

shenhengbin

4,2941 gold badge26 silver badges33 bronze badges

Comments

marc_s · Accepted Answer · 2011-07-07 09:00:06Z

0

XDocument xmlDoc = XDocument.Load(Server.MapPath("~/FolderName/FileName.xml"));

var output= from obj in xmlDoc.Element("extcode")
            where obj.Attribute("Type").Value.ToLower() == "abc"
            select obj;

DataTable outputTable = new DataTable();
outputTable.Columns.Add(new DataColumn("code"));

foreach (var item in output)
{
   DataRow outputRows = outputTable.NewRow();

   if (outputRows != null)
   {
      outputRows["Code"] = item.Element("code").Value;
   }
}
outputTable.Rows.Add(problemsRows);
outputTable.AcceptChanges();

now we have output data table you can use the data where ever you need .

edited Jul 7, 2011 at 9:00

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Jul 7, 2011 at 8:56

raja

3431 gold badge4 silver badges9 bronze badges

Comments

Dimitre Novatchev · Accepted Answer · 2011-07-07 13:27:34Z

0

Edit I figured out that the problem is with namespace. The XML file is like aw:extcode instead of just extcode and that caused the query to not work properly. How should I do it in the presence of namespace?

Writing an XPath expression to be applied on an XML document with namespaces is one of the most FAQ about XPath.

Use the XmlNode.SelectNodes() overload that has an XmlNamespaceManager as its second argument.

The first linked-to page has a complete code example suitable for your case.

Alternative ways are to use XPathNavigator.Evaluate() or XPathNavigator.Select() overloads that use as their second argument IXmlNamespaceResolver.

With LINQ you can use the Extensions.XPathEvaluate() method.

edited Jul 7, 2011 at 13:27

answered Jul 7, 2011 at 13:11

Dimitre Novatchev

244k27 gold badges307 silver badges438 bronze badges

Collectives™ on Stack Overflow

How to extract XML data

5 Answers 5

Comments

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related