Reading XML Attribute with C#

Question

I have an the incoming XML file like this.

<Sport id="23" name="Basketbol">
<Country id="15" name="A.B.D.">
  <Tournament id="9" name="Amerikan Basketbol Ligi" type="1" typeDesc="League">
    <Season id="95" name="2010/2011">
      <Stage id="777" name="2010/2011 Sezonu">
        <Team id="104" name="Chicago Bulls" conferenceId="3" conference="Merkez">
          <General position="1" totalPlayed="82" won="62" draw="0" lost="20" goalsScored="8087" goalsAgainst="7485" points="144" form="W- W- W- W- W- W" />
          <Home position="1" totalPlayed="41" won="36" draw="0" lost="5" goalsScored="4104" goalsAgainst="3683" points="77" />
          <Away position="4" totalPlayed="41" won="26" draw="0" lost="15" goalsScored="3983" goalsAgainst="3802" points="67" />
        </Team>

I want to save an XML File as below in c#.

<sport>
<id>23></id>
<name>Basketbol</name>
<Country>
<id>15</id>
<name>A.B.D.</name>

Take a look at XSLT's, they are designed for this type of work. — Jon
– Jon, Commented May 5, 2011 at 17:58

LueTm · Accepted Answer · 2011-05-06 12:06:21Z

3

LinqToXml: http://msdn.microsoft.com/en-us/library/bb387098.aspx

using System.Xml.Linq;
// [...]    

var sourceDoc = XDocument.Load(@"C:\Your\Source\Xml\File.xml");
var sports = sourceDoc.Descendants().Where(s => s.Name == "Sport");

var destDoc = new XDocument(sports.Select(s =>
    new XElement("sport",
        new XElement("id", s.Attribute("id").Value),
        new XElement("name", s.Attribute("name").Value),
        new XElement("country",
            new XAttribute("id", s.Descendants().Where(c => c.Name == "Country").FirstOrDefault().Attribute("id").Value),
            new XAttribute("name", s.Descendants().Where(c => c.Name == "Country").FirstOrDefault().Attribute("name").Value)
        )
    )
));

destDoc.Save(@"C:\Your\Destination\Xml\File.xml");

edited May 6, 2011 at 12:06

answered May 5, 2011 at 18:01

LueTm

2,38022 silver badges31 bronze badges

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

2 Comments

Matt Ellen Over a year ago

If you're loading in the destination doc, then I would think you'd want to add the new xml to the root of it: destDoc.Root.Add(newElement);. Otherwise, you'd probably want create a new doc, and save it at the end.

LueTm Over a year ago

The idea there was that I create a new document. I'll correct that.

Collectives™ on Stack Overflow

Reading XML Attribute with C#

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related