how to loop in xml (XElement) and get values od Inside Elements

Question

Consider this XML:

enter image description here

I store this XML in XElemnt.How I can loop throw Person elements and get value ID,Name,LastName for each person?

score 2 · Answer 1 · answered Nov 27 '11 at 12:18

2

var doc = XDocument.Load(<filePath>);
var people = from person in doc.Descendents("Person")
select new Person{
    ID = (int)person.Element("ID"),
    Name = (string)person.Element("Name"),
    LastName = (string)person.Element("LastName");
};

return people.ToList();

answered Nov 27 '11 at 12:18

ek_ny

10,153
6
47
60

I'm using XElement.please say how to use XElement with your sample – Arian Nov 27 '11 at 12:25
1

you could replace doc with your XElement, I suppose. XElement has a Load method as well. http://msdn.microsoft.com/en-us/library/bb298435.aspx – ek_ny Nov 27 '11 at 12:28

score 1 · Accepted Answer · answered Nov 27 '11 at 14:35

using XElement, you will get all the people in people variable.

XElement d = XElement.Load("D:\\people.xml");
var people = (from p in d.Descendants("Person")
                select new
                {
                    ID = Convert.ToInt32(p.Element("ID").Value),
                    Name = p.Element("Name").Value,
                    LastName = p.Element("LastName").Value
                }).ToList();

how to loop in xml (XElement) and get values od Inside Elements

2 Answers2