C# XML file - collect all elements with the value.

Question

Hello,

I have a XML file and need to collect all values from YPOS into a new list with index and value.

How can I easily reach this? Thanks in advance.

The goal is a list with

Index, YPOS

1, 41.352
2, 51.352
3, 61.352
4, 71.352

What is the best way with XDocument?

Accepted Answer

Here is one way how to implement it.

c#

void Main()
{
 const string SOURCEXMLFILE = @"e:\Temp\MarkusFreitagInput.xml";

 XDocument xdoc = XDocument.Load(SOURCEXMLFILE);

   List objects2 = new List();

 objects2 = xdoc.Descendants("POSITION")
    .Select(p => new PositionObject()
    {
    Index = Convert.ToInt16(p.Element("INDEX").Attribute("value")?.Value),
    YPOS = p.Element("YPOS").Attribute("value")?.Value
    }
    ).ToList();
}

public class PositionObject
{
 public int Index { get; set; }
 public string YPOS { get; set; }
}

-- UPDATE --
Method #2, by using a dictionary.

void Main()
{
    const string SOURCEXMLFILE = @"e:\Temp\MarkusFreitagInput.xml";

    XDocument xdoc = XDocument.Load(SOURCEXMLFILE);

    Dictionary dictIndexContent = new Dictionary();

    dictIndexContent = xdoc.Descendants("POSITION")
        .ToDictionary(e => Convert.ToInt32(e.Element("INDEX").Attribute("value")?.Value),
                    e => e.Element("YPOS").Attribute("value")?.Value);
}

Answer

            var xDoc = XDocument.Load("../../XMLFile1.xml");
            var vList1 = new List>();

            var vIndex = "";
            var vYPos = "";
            var vPos = xDoc.XPathSelectElements("//POSITION");
            foreach (var vNode in vPos)
            {
                vIndex = vNode.XPathSelectElement("INDEX").Attribute("value").Value;
                vYPos = vNode.XPathSelectElement("YPOS").Attribute("value").Value;

                vList1.Add(new Tuple(vIndex, vYPos));
            }

Answer

Do you have to use XDocument?

If you can use other methods, you can generate the required classes according to vb2ae's recommendations, and then use XmlSerializer to deserialize xml.

            XmlSerializer serializer = new XmlSerializer(typeof(root));  
            using (TextReader reader = new StreamReader(@"D:	est\xml	est.txt"))  
            {  
                root root = (root)serializer.Deserialize(reader);  
                 
                var positions = root.GROUP.SelectMany(t => t.POSITIONS);  
  
                var result = from position in positions  
                             select new  
                             {  
                                 Index = position.INDEX.value,  
                                 XPOS = position.YPOS.value  
                             };  
            }

The generated class is a bit long, I will provide it as an attachment.
61733-classes.txt

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Share via

C# XML file - collect all elements with the value.

2 additional answers

Your answer