How to read xml file c#

Question

<CPT xmlns="http://www.example.org/genericClientProfile" xmlns:ns2="http://www.blahblah.com" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.example.org/genericClientProfile genericClientProfile.xsd">
  <header>
    <serviceId>CPT-UK</serviceId>
    <versionId>1.0</versionId>
    <brandCode>CUK</brandCode>
    <creationTime>2013-09-26T13:55:32.31+02:00</creationTime>
  </header>
</CPT>

I need to be able to read the elements in the header tag. I'm struggling to read the values for some reason, which i'm not sure of. What i've tried:

public ActionResult readxmldata()
    {
        using (var db = new CPTEntities())
        {
            var file = System.IO.Directory.GetFiles("C:\\Workspace\\CPTStaging","*.xml");

            foreach (var xmldoc in file)
            {
                XmlDocument docpath = new XmlDocument();
                docpath.Load(xmldoc);

                CPTPROFILE doc = new CPTPROFILE();
                db.SaveChanges();

                H_HEADER header = new H_HEADER();
                header.SERVICEID = docpath.SelectSingleNode("//CPT/header/@serviceId").Value;
                header.VERSIONID = Convert.ToDecimal(docpath.SelectSingleNode("//CPT/header/@versionId").Value);
                header.CREATIONTIME = Convert.ToDateTime(docpath.SelectSingleNode("//CPT/header/@creationTime").Value);
                header.BRANDCODE = docpath.SelectSingleNode("//CPT/header/@brandCode").Value;

                db.CPTPROFILEs.AddObject(doc);
                db.SaveChanges();
            }
        }

possible duplicate of How to Deserialize XML document

Liam
– Liam

2014-03-17 11:03:01 +00:00
Commented Mar 17, 2014 at 11:03 — Liam
– Liam, Commented Mar 17, 2014 at 11:03

Dmitriy Finozhenok · Accepted Answer · 2014-03-17 11:15:58Z

3

Your XML uses namespaces. xmlns attribute declares default namespace. You should use it for each element of the XML.

XNamespace ns = "http://www.example.org/genericClientProfile";
XDocument doc = XDocument.Load(xmldoc);
XElement header = doc.Root.Element(ns + "header");

edited Mar 17, 2014 at 11:15

answered Mar 17, 2014 at 11:10

Dmitriy Finozhenok

8547 silver badges8 bronze badges

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

Comments

Matthew Watson · Accepted Answer · 2014-03-17 11:19:20Z

2

For comparison, here is one way to do it with Linq-to-XML:

XDocument doc = XDocument.Load(xmlFileName);
XNamespace ns = "http://www.example.org/genericClientProfile";

var header = doc.Descendants(ns+"header").Single();

H_HEADER header = new H_HEADER();

header.SERVICEID    = (string)   header.Element(ns + "serviceId");
header.VERSIONID    = (double)   header.Element(ns + "versionId");
header.BRANDCODE    = (string)   header.Element(ns + "brandCode");
header.CREATIONTIME = (DateTime) header.Element(ns + "creationTime");

answered Mar 17, 2014 at 11:19

Matthew Watson

111k12 gold badges179 silver badges301 bronze badges

3 Comments

Marc Howard Over a year ago

Thank you! I didn't realise you had to declare the namespace to access the attributes.

Marc Howard Over a year ago

What if i have an element like this: <section xmlns="" id="fc105706-2fbe-410c-92bb-c46b723b7e17" name="globalClientFacts"> Do i need to have both the namespace and "" ?

Matthew Watson Over a year ago

@MarcHoward Hmm I'm not sure I'm afraid.

Collectives™ on Stack Overflow

How to read xml file c#

2 Answers 2

Comments

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Linked

Related