Reading specific XML elements from XML file

Question

I have the following XML file   lt lexicon gt   lt word gt     lt base gt a lt  base gt     lt category gt determiner lt  category gt     lt id gt E0006419 lt  id gt   lt  word gt   lt word gt     lt base gt abandon lt  base gt     lt category gt verb lt  category gt     lt id gt E0006429 lt  id gt     lt ditransitive  gt     lt transitive  gt   lt  word gt   lt word gt     lt base gt abbey lt  base gt     lt category gt noun lt  category gt     lt id gt E0203496 lt  id gt   lt  word gt   lt word gt     lt base gt ability lt  base gt     lt category gt noun lt  category gt     lt id gt E0006490 lt  id gt   lt  word gt   lt word gt     lt base gt able lt  base gt     lt category gt adjective lt  category gt     lt id gt E0006510 lt  id gt     lt predicative  gt     lt qualitative  gt   lt  word gt   lt word gt     lt base gt abnormal lt  base gt     lt category gt adjective lt  category gt     lt id gt E0006517 lt  id gt     lt predicative  gt     lt qualitative  gt   lt  word gt   lt word gt     lt base gt abolish lt  base gt     lt category gt verb lt  category gt     lt id gt E0006524 lt  id gt     lt transitive  gt   lt  word gt   lt  lexicon gt    I need to read this file with C  application  and if only the category is verb I want to print its entire element word  How can I do that

User · Answer

You could use an XPath  too  A bit old fashioned but still effective   using System Xml        XmlDocument xmlDocument   xmlDocument   new XmlDocument    xmlDocument LoadXml xml    foreach  XmlElement xmlElement in      xmlDocument DocumentElement SelectNodes  word category  verb            Console Out WriteLine xmlElement OuterXml

User · Answer

Alternatively  you can use XPath query via XPathSelectElements method   var document   XDocument Parse yourXmlAsString   var words   document XPathSelectElements    word   category text      verb

User · Answer

This is how I would do it  the code below has been tested  full source provided below   begin by creating a class with common properties      class Word               public string Base   get  set            public string Category   get  set            public string Id   get  set            load using XDocument with INPUT DATA for demonstration purposes and find element name with lexicon            XDocument doc   XDocument Parse INPUT DATA       XElement lex   doc Element  lexicon      make sure there is a value and use linq to extract the word elements from it            Word   catWords   null      if  lex    null                IEnumerable lt XElement gt  words   lex Elements  word            catWords    from itm in words                     where itm Element  category      null                          amp  amp  itm Element  category   Value     verb                           amp  amp  itm Element  id      null                          amp  amp  itm Element  base      null                     select new Word                                                  Base   itm Element  base   Value                          Category   itm Element  category   Value                          Id   itm Element  id   Value                         ToArray lt Word gt             The where statement checks if the category element exists and that the category value is not null and then check it again that it is a verb   Then check that the other nodes also exists        The linq query will return an IEnumerable lt  Typename   object  so we can call ToArray lt  Typename     to cast the entire collection into the type we want   Then print it to get          Found   Id  E0006429  Base  abandon  Category  verb   Found   Id  E0006524  Base  abolish  Category  verb   Full Source   using System  using System Collections Generic  using System Linq  using System Xml Linq   namespace test       class Program                class Word                       public string Base   get  set                public string Category   get  set                public string Id   get  set                       static void Main string   args                        XDocument doc   XDocument Parse INPUT DATA               XElement lex   doc Element  lexicon                Word   catWords   null              if  lex    null                                IEnumerable lt XElement gt  words   lex Elements  word                    catWords    from itm in words                             where itm Element  category      null                                  amp  amp  itm Element  category   Value     verb                                   amp  amp  itm Element  id      null                                  amp  amp  itm Element  base      null                             select new Word                                                                  Base   itm Element  base   Value                                  Category   itm Element  category   Value                                  Id   itm Element  id   Value                                 ToArray lt Word gt                                  print it             if  catWords    null                                Console WriteLine  Words with  lt category gt  and value verb  n                    foreach  Word itm in catWords                      Console WriteLine   Found  n Id   0  n Base   1  n Category   2  n                            itm Id  itm Base  itm Category                                    const string INPUT DATA              lt  xml version   1 0    gt           lt lexicon gt           lt word gt             lt base gt a lt  base gt             lt category gt determiner lt  category gt             lt id gt E0006419 lt  id gt           lt  word gt           lt word gt             lt base gt abandon lt  base gt             lt category gt verb lt  category gt             lt id gt E0006429 lt  id gt             lt ditransitive  gt             lt transitive  gt           lt  word gt           lt word gt             lt base gt abbey lt  base gt             lt category gt noun lt  category gt             lt id gt E0203496 lt  id gt           lt  word gt           lt word gt             lt base gt ability lt  base gt             lt category gt noun lt  category gt             lt id gt E0006490 lt  id gt           lt  word gt           lt word gt             lt base gt able lt  base gt             lt category gt adjective lt  category gt             lt id gt E0006510 lt  id gt             lt predicative  gt             lt qualitative  gt           lt  word gt           lt word gt             lt base gt abnormal lt  base gt             lt category gt adjective lt  category gt             lt id gt E0006517 lt  id gt             lt predicative  gt             lt qualitative  gt           lt  word gt           lt word gt             lt base gt abolish lt  base gt             lt category gt verb lt  category gt             lt id gt E0006524 lt  id gt             lt transitive  gt           lt  word gt           lt  lexicon gt

User · Answer

XDocument xdoc   XDocument Load path to xml   var word   xdoc Elements  word                   SingleOrDefault w   gt   string w Element  category       verb      This query will return whole word XElement  If there is more than one word element with category verb  than you will get an InvalidOperationException  If there is no elements with category verb  result will be null

User · Answer

You could use linq to xml       var xmlStr   File ReadAllText  fileName xml          var str   XElement Parse xmlStr        var result   str Elements  word    Where x   gt  x Element  category   Value Equals  verb    ToList         Console WriteLine result

[c#] Reading specific XML elements from XML file

Examples related to c#

Examples related to xml