Parsing XML file using C#

Question

I need to read and get all the customer ids from the xml. i tried the below code. but returns only one id. i have mentioned by xml file as well. Can anyone help on this issue.

var xdoc = XDocument.Load(@"d:\reply2.xml");
            var entries = xdoc.Descendants("customerlist").Select(x => new { custid = (int) x.Element("customerid")});
            foreach (var e in entries)
            {
                Console.WriteLine("Start: {0}", e.custid);
            }
            Console.ReadLine();

xml file.

<customerlist>
<customerid>1001</customerid>
<customerid>1002</customerid>
<customerid>1003</customerid>
<customerid>1004</customerid>
</customerlist>

possible duplicate of How does one parse XML files?

DarkWanderer
– DarkWanderer

2014-03-27 11:25:18 +00:00
Commented Mar 27, 2014 at 11:25 — DarkWanderer
– DarkWanderer, Commented Mar 27, 2014 at 11:25

Sergey Berezovskiy · Accepted Answer · 2014-03-27 11:32:59Z

2

Your code is not working, because you are selecting all customerlist from your file (there is only one such element, which is root), and then you are projecting each customerlist element in result sequence to following anonymous type:

new { custid = (int)x.Element("customerid")}

What is happening here? You gen first customerid element from x (which is customerlist) and return new anonymous object for each customerlist item in source sequence. But you have only one customerlist. So you have single anonymous object as query result.

If you want to select anonymous type with property custid:

var entries = from c in xdoc.Root.Elements("customerid")
              select new { custid = (int)c };

But I think you can simply select sequence of ids here without creating new type:

var ids = xdoc.Root.Elements("customerid").Select(c => (int)c);

edited Mar 27, 2014 at 11:32

answered Mar 27, 2014 at 11:27

Sergey Berezovskiy

237k44 gold badges441 silver badges468 bronze badges

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

Comments

Daniel · Accepted Answer · 2014-03-27 12:01:38Z

0

Here is the simple way to do this:

List <string> customerId = new List< string>();
string xmlString = @"Your XML string";
XDocument xDoc = XDocument.Parse(xmlString);

foreach (var element in xDoc.Descendants("customerid"))
{
    customerId.Add(element.Value);
}

edited Mar 27, 2014 at 12:01

Daniel

4116 silver badges31 bronze badges

answered Mar 27, 2014 at 11:47

Amit Upadhyay

11 bronze badge

2 Comments

Innovative Thinker Over a year ago

but i have file not xml string

Amit Upadhyay Over a year ago

You can load XML file instead of parse like XDocument doc = XDocument.Load("xmlfile.xml");

Collectives™ on Stack Overflow

Parsing XML file using C#

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related