Parse XML Backwards

[lucasstark]

I have the following XML File: I want to parse the file so that I can add each node to a database: So I need to parse the bottom node and say:
admissions, application. Then go up a level and extract "the admissions application"


<Token Type="TOP" Dectiption="" >
<Token Type="SBARQ" Dectiption="" >
<Token Type="WHNP" Dectiption="" >
<Token Type="WP" Dectiption="wh-pronoun" >What</Token>
</Token>
<Token Type="S" Dectiption="" >
<Token Type="VP" Dectiption="Verb Phrase" >
<Token Type="VBP" Dectiption="Verb, non-3rd ps. sing. present" >are</Token>
<Token Type="NP" Dectiption="Noun Phrase">
<Token Type="NP" Dectiption="Noun Phrase">
<Token Type="DT" Dectiption="Determiner" >the</Token>
<Token Type="NNS" Dectiption="Noun, plural" >fees</Token>
</Token>
<Token Type="PP" Dectiption="Prepositional Phrase">
<Token Type="IN" Dectiption="Preposition/subordinate" >for</Token>
<Token Type="NP" Dectiption="Noun Phrase" >
<Token Type="DT" Dectiption="Determiner">the</Token>
<Token Type="NNS" Dectiption="Noun, plural">admissions</Token>
<Token Type="NN" Dectiption="Noun, singular or mass">application</Token>
</Token>
</Token>
</Token>
</Token>
</Token>
</Token>
</Token>

[namit101]

You should use some kind of recursive function, like:

 
public string ProcessXML(XmlNode node)
        {            
            if (node.ChildNodes.Count == 0)
            {
                return node.InnerText;
            }
            else
            {
                StringBuilder sentence = new StringBuilder();
                for (int i = 1; i < node.ChildNodes.Count; i++)
                {
                    sentence.Append(ProcessXML(node));
                }
                return sentence.ToString();
            }
        }
 
 
 
 

*****note: I haven't tested this, it's just an example/pseudocode