how to parse the XML file having Same Element ?

vikas nakil

I m struggling in parsing XML with same element, node,
I want to retrieve data from XML with same element

      ABD
      ABD MNO

        ABD1
        AB1
        1


        ABD2
        ABD2
        1


        ABD3
        ABD3
        1


        ABD4
        ABD4
        1



---------------------------------------------------------------

46565

    20109087
    1612665
    11/30/2012

    20109088
    1612666
    11/30/2012

    20109089
    1612667
    11/30/2012

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes13y ago
Accepted answer
Try this:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Xml.Linq;

class Test
{
static void Main()
{
XElement contractInfo = XElement.Load("contractinfo.xml");
XElement[] serviceInfoArray = contractInfo.Element("PlanInfo").Elements("ServiceInfo").ToArray();
foreach(XElement xe in serviceInfoArray)
{
XElement serviceCode = xe.Element("ServiceCode");
XElement serviceDesc = xe.Element("ServiceDesc");
XElement outlets = xe.Element("Outlets");
Console.WriteLine(serviceCode.Value);
Console.WriteLine(serviceDesc.Value);
Console.WriteLine(outlets.Value);
Console.WriteLine();
}

XElement test = XElement.Load("test.xml");
XElement[] contractInfoArray = test.Elements("CONTRACTINFO").ToArray();
foreach(XElement xe in contractInfoArray)
{
XElement customerNo = xe.Element("CustomerNo");
XElement contractNo = xe.Element("ContractNo");
XElement startDate = xe.Element("StartDate");
Console.WriteLine(customerNo.Value);
Console.WriteLine(contractNo.Value);
Console.WriteLine(startDate.Value);
Console.WriteLine();
}

Console.ReadKey();
}
}
Vulpes13y ago
There are at least three ways to read the content of an XML file in .NET:

1. Using XmlReader which provides 'forward only' access to the data. This is fast but is no good if you want to jump about within the file and/or change something and write it back to the file.

2. Using XmlDocument (in combination with XPath) which is an implementation of the W3C DOM. This allows you to both navigate and edit an XML document.

3. Using LINQ to XML (XDocument or XElement) which provides similar functionality to #2.

Of these, #3 is the latest and (IMO) the best general purpose way of dealing with XML. Also it is just as easy to deal with XML strings or XML files. However, it requires some knowledge of LINQ.

So, I think you need to decide which of these is best suited to your requirements. You can't really 'chop and change' between them.
vikas nakil13y ago
I m struggling in parseing XMLDocument further, due same element name inside in it.
vikas nakil13y ago
I m still not getting it clearly, i m little confused,
Which is the easier way to parse, By xmlnodelist or XElement or any other way?
Following are the Orginal XML which i fetch from website and load into String.
then convert string into XMLDocument, then i m struggling to parse ahead due to same Element and same node.

---------------------------------------------------------------------

46565

20109087
1612665
11/30/2012

ABD
ABD MNO

ABD1
AB1
1

ABD2
ABD2
1

ABD3
ABD3
1

ABD4
ABD4
1

20109088
1612666
11/30/2012

ABD1
ABD1 MNO1

ABD1
AB1
1

ABD2
ABD2
1

ABD3
ABD3
1

ABD4
ABD4
1

20109089
1612667
11/30/2012

ABD2
ABD2 MNO2

ABD1
AB1
1

ABD2
ABD2
1

ABD3
ABD3
1

ABD4
ABD4
1

---------------------------------------------------------------------
Vulpes13y ago
If you're starting from an XmlNodeList, then you'll need to construct an XmlDocument from that and then use XPath to find the nodes you're interested in.

If 'list' represents the XmlNodeList for the first piece of XML, then the code will be:

XmlDocument doc = new XmlDocument();
string xml = "";
foreach(XmlNode node in list)
{
xml += node.OuterXml + "\r\n";
}
xml = xml.Substring(0, xml.Length - 2);
doc.LoadXml(xml);
XmlNodeList ServiceInfoNodes = doc.SelectNodes("//ServiceInfo");
foreach(XmlNode ServiceInfoNode in ServiceInfoNodes)
{
foreach(XmlNode child in ServiceInfoNode.ChildNodes)
{
Console.WriteLine("{0} = {1}", child.Name, child.InnerText);
}
Console.WriteLine();
}

Similarly, if 'list2' represents the XmlNodeList for the second piece of XML:

XmlDocument doc2 = new XmlDocument();
string xml2 = "";
foreach(XmlNode node in list2)
{
xml2 += node.OuterXml + "\r\n";
}
xml2 = xml2.Substring(0, xml2.Length - 2);
doc2.LoadXml(xml2);
XmlNodeList ContractInfoNodes = doc2.SelectNodes("//CONTRACTINFO");
foreach(XmlNode ContractInfoNode in ContractInfoNodes)
{
foreach(XmlNode child in ContractInfoNode.ChildNodes)
{
Console.WriteLine("{0} = {1}", child.Name, child.InnerText);
}
Console.WriteLine();
}
vikas nakil13y ago
thanx Vulpes, As i m abegginner in xml, Can you tell? how to pass xmldocument in xElement.load() rather than a file? As i am not passing any file,but passing xmlnodelist ?
vikas nakil13y ago
This is my another account,

I m struggling in parsing XML with same element, node Using C#
I want to retrieve data from XML with same element

      ABD
      ABD MNO

        ABD1
        AB1
        1


        ABD2
        ABD2
        1


        ABD3
        ABD3
        1


        ABD4
        ABD4
        1



---------------------------------------------------------------

46565

    20109087
    1612665
    11/30/2012

    20109088
    1612666
    11/30/2012

    20109089
    1612667
    11/30/2012