How to get specific attributes with values from an xml document using c# console?

Question

I have an xml document like below:

<?xml version = "1.0"?>
<Employees>
    <Employee Id="1" City="Seattle">
        <EmployeeName>Nancy Davolio</EmployeeName>
        <Country>USA</Country>
    </Employee>
    <Employee Id="2" City="Tacoma">
        <EmployeeName>Andrew Fuller</EmployeeName>
        <Country>USA</Country>
    </Employee>
    <Employee Id="3" City="Kirkland">
        <EmployeeName>Janet Leverling</EmployeeName>
        <Country>USA</Country>
    </Employee>
</Employees>

From this file, I like to get displayed in the console only the EmployeeName for every employee with their tags. Below is how I tried to do so but it is showing only the opening and closing tag but not the value of EmployeeName.

static void Main(string[] args)
        {


            XmlTextReader reader = new XmlTextReader("D://test.xml");
            while (reader.Read())
            {
                switch (reader.NodeType)
                {
                    case XmlNodeType.Element: // The node is an element.
                        if (reader.Name == "EmployeeName")
                        {
                            Console.Write("<" + reader.Name);
                            Console.WriteLine(">");

                        }
                         break;
                    case XmlNodeType.Text: //Display the text in each element.
                         if (reader.Name == "EmployeeName")
                         {
                             Console.WriteLine(reader.Value);
                         }

                        break;
                    case XmlNodeType.EndElement: //Display the end of the element.
                        if (reader.Name == "EmployeeName")
                        {
                            Console.Write("</" + reader.Name);
                            Console.WriteLine(">");
                        }

                        break;
                }
            }
            Console.ReadLine();



        }

Any help, please!

The output would like look this: without the value inside the tags — Arbenita Musliu, Jul 10 '18 at 19:56
for the given input 3 empty tag pair, and the xml root also, or excluded? — ntohl, Jul 10 '18 at 19:58
Excluded the root the result is three empty attributes without the value — Arbenita Musliu, Jul 10 '18 at 20:00
When you step through with the debugger in the 2nd case, does it visit your node (before the `if` statement)? — Jasen, Jul 10 '18 at 20:07
No, it doesn't. Actually, it reads all the file at once and displays the output. — Arbenita Musliu, Jul 10 '18 at 20:13
when you are in the `case XmlNodeType.Text`, the actual Name == "EmployeeName" happened in the previous iteration — ntohl, Jul 10 '18 at 20:20
Yes, because I want to display the value of the EmployeeName node — Arbenita Musliu, Jul 10 '18 at 20:22

How to get specific attributes with values from an xml document using c# console?

0 Answers0