Solved

Looping through elements in XML

Posted on 2008-10-22
2
2,104 Views
Last Modified: 2010-02-12
Hi - I am trying to loop through an xml string as shown in listing A.

When I try run the code in Listing B, I only get the details of the FIRST node (UNH) in the XML displayed, not the rest, like UCM, UNT etc.

Why is this and how do I get the thing to display all nodes??
I suspect its because the nodes have different names?
But surely there must be a away to get all nodes with DIFFERENT names?

Please help
Thanks


//Listing A
 
incomingMessage = @"
<EdiMessage>
<UNH>
    <unhCode>100</unhCode>
    <unhMessageType>CUSDEC</unhMessageType>
    <unhShortCode>CDSA</unhShortCode>
</UNH>
<UCM>
    <ucmNumber>12345</ucmNumber>
    <ucmOrganisation>GreenPeace</ucmOrganisation>
    <ucmIndex>1</ucmIndex>
    <ucmIndexCode>GP</ucmIndexCode>
</UCM>
<UNT>
    <untTotalCode>TAX</untTotalCode>
    <untTotal>135 000 000</untTotal>
</UNT>
<UNT>
    <untTotalCode>REBATE</untTotalCode>
    <untTotal>35 000 000</untTotal>
</UNT>
<UNT>
    <untTotalCode>DIFF</untTotalCode>
    <untTotal>100 000 000</untTotal>
</UNT>
<UNZ>
    <unzCode>ANT01</unzCode>
    <unzId>1234-908-34544-0001</unzId>
</UNZ>
<UNT>
    <untTotalCode>SAL</untTotalCode>
    <untTotal>100 000</untTotal>
</UNT>
<UNT>
    <untTotalCode>COST</untTotalCode>
    <untTotal>20 000</untTotal>
</UNT>
</EdiMessage>";
 
//Listing B
 
 xmlIn.LoadXml(incomingMessage);
           
            XmlNodeList xmlnode = xmlIn.SelectNodes("EdiMessage");
            for (int i = 0; i < xmlnode.Count; i++)
            {
                XmlAttributeCollection xmlattrc = xmlnode[i].Attributes;
                Console.Write(xmlnode[i].FirstChild.Name);
                Console.WriteLine(":\t" + xmlnode[i].FirstChild.InnerText);
            }

Open in new window

0
Comment
Question by:djcheeky
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 12

Accepted Solution

by:
ShazbotOK earned 125 total points
ID: 22780694
Since "EditMessage" is your ROOT node, use this instead:
XmlNodeList xmlnode = xmlIn.FirstChild.ChildNodes;
0
 
LVL 3

Assisted Solution

by:torrie01
torrie01 earned 125 total points
ID: 22780768
There is only 1 EdiMessage, which is why you only get one node.  Once you get that node, you can just loop through its children, like so:


XmlNode node = xmlIn.SelectSingleNode("EdiMessage");
for (int i = 0; i < node.ChildNodes.Count; i++)
{
     XmlAttributeCollection xmlattrc = node.ChildNodes[i].Attributes;
     Console.Write(node.ChildNodes[i].FirstChild.Name);
     Console.WriteLine(":\t" + node.ChildNodes[i].FirstChild.InnerText);
}

Open in new window

0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How to escape alias names for Oracle query 1 41
parsing question on dynamic concatenation 3 40
Web page design problem 3 41
How does this modal gets closed? 6 41
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question