Pulling data from an XML file into a TreeView item (C#)

Question

I'm having a bit of an issue. I'm trying to parse an XML file and put it's contents into a TreeView. I got everything pretty much working, but I'm having issues with one thing.

Here is an example of the XML file:

<AnswerIt>

    <category name="Category 1">
        <question is="Question 1">
            <answer couldbe="Answer 1" />
            <answer couldbe="Answer 2" />
        </question>
    </category>

    <category name="Category 2">
        <question is="Question 1">
            <answer couldbe="Answer 1" />
        </question>
        <question is="Question 2">
            <answer couldbe="Answer 1" />
        </question>
    </category>

</AnswerIt>

The code I am using to prase the XML file pulls all the categories just fine. When it gets to the question part it pulls the first question, but none after that. All the answers get pulled just fine (as long as they belong to the first question). Here is my C# code:

public void LoadQuestionDatabase()
    {
        XmlTextReader reader = new XmlTextReader("http://localhost/AnswerIt.xml");


        TreeNode node = new TreeNode();
        TreeNode subnode = new TreeNode();

        while (reader.Read())
        {
            if (reader.NodeType == XmlNodeType.Element && reader.Name == "category")
            {
                node = lstQuestions.Nodes.Add(reader.GetAttribute(0));
                categories.Add(reader.GetAttribute(0));


                while (reader.NodeType != XmlNodeType.EndElement)
                {
                    reader.Read();
                    if (reader.Name == "question")
                    {
                       subnode = node.Nodes.Add(reader.GetAttribute(0));
                        questions.Add(reader.GetAttribute(0));

                        while (reader.NodeType != XmlNodeType.EndElement)
                        {
                            reader.Read();
                            if (reader.Name == "answer")
                            {
                                // add each answer
                                subnode.Nodes.Add(reader.GetAttribute(0).Replace("\t", ""));
                            }
                        }
                    }
                }

            }

        }
        reader.Close();
    }

I'm not very good at C#, I'm guessing somewhere along the lines it's not looping through all the questions and adding them. Any ideas what I'm doing wrong? Anywhere I can read up on to help me out? Every example I read puts the root node (AnswerIt) in the treeview, and I do not want that.

Dan Carlstedt · Answer 1 · 2012-06-22T20:55:44.167

0

Instead of using the XmlTextReader try using

XDocument doc = XDocument.Load("http://localhost/AnswerIt.xml");

then you don't have to manually construct all the elements.

XDocument is provided in the System.Xml.Linq assembly and namespace. Once it's loaded into the XDocument you can then use any of its built in methods to manipulate the data.

edited Jun 22 '12 at 20:55

answered Jun 22 '12 at 20:46

Dan Carlstedt

311
2
9

score 0 · Accepted Answer · answered Jun 22 '12 at 20:55

0

var xDocument = XDocument.Load("http://localhost/AnswerIt.xml");

foreach (var element in xDocument.Descendants("category"))
{
    var node = lstQuestions.Nodes.Add(element.Attribute("name").Value);
    foreach (var subElement in element.Elements("question"))
    {
        var subnode = node.Nodes.Add(subElement.Attribute("is").Value);
        foreach (var answer in subElement.Elements("answer"))
            subnode.Nodes.Add(answer.Attribute("couldbe")
                   .Value.Replace("\t", ""));
    }
}

answered Jun 22 '12 at 20:55

Raphaël Althaus

59,727
6
96
122

I have another question. The formatting inside the couldbe attribute is lost, eg newlines, when I, for example, insert the node data into a richtextbox. How can I prevent this? I've looked at the LoadOptions and none of those seem to do the trick. I have also toyed with parsing the Environment.NewLine and "/n" with no luck. – septor Jun 24 '12 at 18:33

Pulling data from an XML file into a TreeView item (C#)

2 Answers2