No Linq result for XML

Question

I have the following code:

protected void Page_Load(object sender, EventArgs e) { XElement xml = XElement.Load(Server.MapPath("ArenasMembers.xml")); var query = from p in xml.Descendants("members") select new { Name = p.Element("name").Value, Email = p.Attribute("email").Value }; foreach (var member in query) { Response.Write("Employee: " + member.Name + " " + member.Email + "<br />"); } } 

That, using the guidance information in Visual Studio, it reads the XNL file correctly, however foreach does not output any of the records.

XML:

 <?xml version="1.0" encoding="utf-8" ?> <members> <member> <arena>EAA Office</arena> <memberid>1</memberid> <name>Jane Doe</name> <email> [e-mail] </email> </member> <member> <arena>EAA Office</arena> <memberid>2</memberid> <name>John Bull</name> <email> [e-mail] </email> </member> <member> <arena>O2 Arena</arena> <memberid>3</memberid> <name>John Doe</name> <email> [e-mail] </email> </member> <member> <arena>O2 Arena</arena> <memberid>4</memberid> <name>Bernard Cribbins</name> <email> [e-mail] </email> </member> <member> <arena>Colourline Arena</arena> <memberid>5</memberid> <name>John Bon Jovi</name> <email> [e-mail] </email> </member> <member> <arena>NIA</arena> <memberid>6</memberid> <name>Rhianna</name> <email> [e-mail] </email> </member> </members> 

You see what is wrong?

Answer 1

Established "members", try "member" ...

Descendants returns you all the children in the given Element , in your code you request members using name and email , which do not work.

Code example:

  var query = from p in xml.Descendants("member") select new { Name = p.Element("name").Value, Email = p.Element("email").Value }; 

Answer 2

Changing the attribute ("email") in Element ("email") turned out great for me. verified, hopefully approved.

  public void XMLTEst() { var xml = @"<?xml version='1.0' encoding='utf-8' ?>" + " <members>" + " <member>" + " <arena>EAA Office</arena> " + " <memberid>1</memberid> " + " <name>Jane Doe</name> " + " <email> [e-mail] </email> " + " </member> " + " <member> " + " <arena>EAA Office</arena> " + " <memberid>2</memberid> " + " <name>Linda Bull</name> " + " <email> [e-mail] </email> " + " </member> " + " <member> " + " <arena>O2 Arena</arena> " + " <memberid>3</memberid> " + " <name>John Doe</name> " + " <email> [e-mail] </email> " + " </member> " + " <member> " + " <arena>O2 Arena</arena> " + " <memberid>4</memberid> " + " <name>Bernard Cribbins</name> " + " <email> [e-mail] </email> " + " </member> " + " <member> " + " <arena>Colourline Arena</arena> " + " <memberid>5</memberid> " + " <name>John Bon Jovi</name> " + " <email> [e-mail] </email> " + " </member> " + " <member> " + " <arena>NIA</arena> " + " <memberid>6</memberid>" + " <name>Rhianna</name>" + " <email> [e-mail] </email>" + " </member>" + "</members>"; XElement xmlFile = XElement.Parse(xml); var query = from p in xmlFile.Descendants("member") select new { Name = p.Element("name").Value, Email = p.Element("email").Value }; foreach (var member in query) { Response.Write("Employee: " + member.Name + " " + member.Email + "<br />"); } }