Parse xml in c#.net

Question

I have to parse following xml in C#

<Packages>
      <Package>
         <PackageName>Create_Staging_Table</PackageName>
         <SequenceID>1</SequenceID>
         <AlwaysRun>True</AlwaysRun>
      </Package>
        <Package>
         <PackageName>Indigo_Staging_Load</PackageName>
         <SequenceID>2</SequenceID>
         <AlwaysRun>True</AlwaysRun>
      </Package>
        <Package>
         <PackageName>Indiogo_Load_Package</PackageName>
         <SequenceID>3</SequenceID>
         <AlwaysRun>True</AlwaysRun>
      </Package>
   </Packages>

I have tried

XmlDocument doc = new XmlDocument();
             doc.Load(filePath);
             XmlNode PackagesListNode = doc.SelectSingleNode("/Packages");
             XmlNodeList Packages = PackagesListNode.SelectNodes("Package");
             foreach (XmlNode node in Packages)
             {
                 TableLoadInstruction instruction = new TableLoadInstruction();
                 instruction.PackageName = node.Attributes.GetNamedItem("PackageName").Value;
                 instruction.Sequence = Convert.ToInt16(node.Attributes.GetNamedItem("SequenceID").Value);
                 instruction.AlwaysRun = Convert.ToBoolean(node.Attributes.GetNamedItem("AlwaysRun").Value);
                 loadInstructions.Add(instruction);
             }

I have got error like "Object reference not set to an instance of an object" at node.Attributes.GetNamedItem("PackageName").value since node.Attributes.GetNamedItem("PackageName") is 'null'

You should include what **you have tried** and what **specific problem** you encountered. — , Apr 25 '14 at 11:11
Many, many questions about extracting data from XML have already been asked and answered here. — H H, Apr 25 '14 at 11:12
OK, sou you have tried something. What went wrong? (Actual vs expected outcome, full error messages etc). — H H, Apr 25 '14 at 11:13
Henk I have got error like "Object reference not set to an instance of an object" at node.Attributes.GetNamedItem("PackageName").value since node.Attributes.GetNamedItem("PackageName") is 'null' — Shankar Kamble, Apr 25 '14 at 11:15

score 1 · Answer 1 · answered Apr 25 '14 at 11:20

1

What you are trying to do won't work because PackageName isn't an attribute. You have to look into the children nodes of Package.

answered Apr 25 '14 at 11:20

Zebrastorm

81
1
4

You should provide this kind of responses as comment rather than as answer – Jaroslav Kadlec Apr 25 '14 at 11:39
But Zebra does not have the points to comment, and it is a partial answer. To an incomplete question. – H H Apr 25 '14 at 12:14

score 1 · Accepted Answer · answered Apr 25 '14 at 11:21

Finally got solution

XmlDocument doc = new XmlDocument();
             doc.Load(filePath);
             XmlNode PackagesListNode = doc.SelectSingleNode("/Packages");
             XmlNodeList Packages = PackagesListNode.SelectNodes("Package");
             foreach (XmlNode node in Packages)
             {
                 TableLoadInstruction instruction = new TableLoadInstruction();
                 instruction.PackageName = node.SelectSingleNode("PackageName").InnerText;
                 instruction.Sequence = Convert.ToInt16(node.SelectSingleNode("SequenceID").InnerText);
                 instruction.AlwaysRun = Convert.ToBoolean(node.SelectSingleNode("AlwaysRun").InnerText);
                 loadInstructions.Add(instruction);
             }

Just a hint: look into XDocument et al. Much shorter and easier. — H H, Apr 25 '14 at 12:16

score 0 · Answer 3 · answered Apr 25 '14 at 11:16

0

You are looking for PackageName, that's anode into node.Attributes, so I think you'll never get a value for this xml. Is that your problem?

answered Apr 25 '14 at 11:16

zeppaman

844
8
23

Parse xml in c#.net

3 Answers3