How to retrieve records from XML element with namespace?

Question

I have the following XML:

<Document xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="urn:hl7-org:v3 CDA_SDTC.xsd" xmlns="urn:hl7-org:v3" xmlns:cda="urn:hl7-org:v3" xmlns:sdtc="urn:hl7-org:sdtc">
<component>
<structuredBody>
  <component>
    <section>
      <templateId root="abs" />
      <title>A1</title>
      <text>
        <paragraph>Hello world!</paragraph>
      </text>
    </section>
  </component>
</structuredBody>
</component>
</Document>

I have the following code used to retrieve paragraph:

XDocument m_xmld = XDocument.Load(Server.MapPath("~/xml/a.xml"));
var m_nodelist = m_xmld.Descendants().Where(p => p.Name.LocalName == "section").
    Select(i => i.Element("text").Element("paragraph").Value).ToList();

Error:

Object reference not set to an instance of an object.

However the following code works fine, but i want use above code.

XNamespace ns = "urn:hl7-org:v3";
var m_nodelist = m_xmld.Descendants(ns + "section").
       Select(i => i.Element(ns + "text").Element(ns + "paragraph").Value).ToList();

Damith · Accepted Answer · 2013-09-16 18:31:12Z

1

var m_nodelist = m_xmld.Descendants().Where(p => p.Name.LocalName == "rows").
Select(u => u.Attribute("fname").Value).ToList();

update :

var m_nodelist = m_xmld.Descendants().Where(p => p.Name.LocalName == "section").
Select(u => (string)u.Descendants().FirstOrDefault(p => p.Name.LocalName == "paragraph")).ToList();

edited Sep 16, 2013 at 18:31

answered Sep 16, 2013 at 17:02

Damith

63.2k13 gold badges106 silver badges154 bronze badges

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

2 Comments

Samiey Mehdi Over a year ago

my xml file is too big, how to convert that to string to 'string x'

Damith Over a year ago

@SamieyMehdi now check

Anirudha · Accepted Answer · 2013-09-16 17:00:05Z

1

xmlns="urn:hl7-org:v3" is your default namespace and so need to be referenced...

XNamespace ns="urn:hl7-org:v3";
m_xmld.Descendants(ns+"rows")....

OR

you can avoid the namespace itself

m_xmld.Elements().Where(e => e.Name.LocalName == "rows")

answered Sep 16, 2013 at 17:00

Anirudha

32.9k8 gold badges71 silver badges90 bronze badges

Comments

Ovidiu · Accepted Answer · 2013-09-16 17:01:54Z

1

Try this

var m_nodelist = m_xmld.Root.Descendants("rows")

If you want to specify a namespace when selecting nodes you can try

var m_nodelist = m_xmld.Root.Descendants(XName.Get("rows", "urn:hl7-org:v3"))

answered Sep 16, 2013 at 17:01

Ovidiu

1,40712 silver badges11 bronze badges

Comments

Kami · Accepted Answer · 2013-09-16 17:06:00Z

0

As you correctly identified, you need to append the namespace to the node lookup.

XNamespace nsSys = "urn:hl7-org:v3";
var m_nodelist = m_xmld.Descendants(nsSys + "rows").Select(x => x.Attribute("fname").Value).ToList();

answered Sep 16, 2013 at 17:06

Kami

19.5k4 gold badges53 silver badges65 bronze badges

Collectives™ on Stack Overflow

How to retrieve records from XML element with namespace?

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related