Loading

read xml data to variables

read xml data to variables

Koen Hendrickx

Hello,

I'm a quite newbie to C# programming. I'm busy to a program and i would like to get some values out of an XML document.

I had some success with xmldocument, but i want to use xmlreader or xml.linq

Unfortuanally, i succeed none of both.

xml document:

3

name1_1
Test1_0

name1_2
Test1_1

name1_3
Test1_2

2

name2_1
Test2_0

name2_2
Test2_0

at first, i want to derive both to a variable (integer).

after this, i want to get the name and description, depending on the requested . this should become a string, to be used in further programming.

Anyone can advice me what to use? (xmlreader or LINQ?)

How should i implement? (as after reading and trying a lot, i don't get anything working...)

Already many thanks!

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Bryian Tan8y ago
This might help you move forward.
//read the xml from file
            XElement xelement = XElement.Load("c:\\temp\\XMLFile1.xml");

            //get the type node
            IEnumerable types = from item in xelement.Descendants("Type")
                                          select item;
            //extract the amount
            foreach (var t in types)
            {
                Console.WriteLine("Amount: " + t.Element("Amount").Value);
            }

            //get the tag
            IEnumerable tags = from tag in types.Descendants("Tag")
                                         where (string)tag.Attribute("ID") == "tag1"
                                         select tag;

            //extract element fromt he selected tag
            foreach (var tag in tags)
            {
                Console.WriteLine("name : " + tag.Element("Name").Value);
                Console.WriteLine("description : " + tag.Element("Description").Value);
            }