How to use Ancestors with Descendants in LINQ to XML?

Oct 16 2017 8:37 AM

How do I get the contents of a node <title> whose immediate ancestor is <sec> using linq 2 xml. Here is a sample xml file

<?xml version="1.0" encoding="UTF-8"?>
<article article-type="proceedings" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:mml="http://www.w3.org/1998/Math/MathML" xmlns:oasis="http://www.niso.org/standards/z39-96/ns/oasis-exchange/table">
<front>
<title-group>
<title>SMALL angle scattering polarization biopsy: a comparative analysis of various skin diseases</title>
</title-group>
....
....
</front>
<body>
<boxed-text id="s1" position="anchor">
<sidebar-label>S1.</sidebar-label>
<sec id="sec1">
<title>EXPERIMENTAL TECHNIQUE</title>
In the case of lupus the changes in the basal membrane adversely affect differentiation of the epidermis; this results in disorders of keratinization combined with progressive atrophy.
</sec>
</boxed-text>
....
....
</body>

I'm trying to get the value EXPERIMENTAL TECHNIQUE from the above example using both Descendants and Ancestors method of LINQ 2 XML. I've tried

var item=from x in doc.Descendants("label")
where x.Ancestors("sec")
select x;

but getting an error

Cannot implicitly convert type 'System.Collections.Generic.IEnumerable<System.Xml.Linq.XElement>' to 'bool'

whose immediate ancestor is <sec> using linq 2 xml. Here is a sample xml file</div><div><div class="dp-highlighter"><div class="bar"></div><ol start="1" class="dp-xml"><li class="alt"><?xml version="1.0" encoding="UTF-8"?> </li><li class=""><article article-type="proceedings" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:mml="http://www.w3.org/1998/Math/MathML" xmlns:oasis="http://www.niso.org/standards/z39-96/ns/oasis-exchange/table"> </li><li class="alt"><front> </li><li class=""><title-group> </li><li class="alt"><title>SMALL angle scattering polarization biopsy: a comparative analysis of various skin diseases</title> </li><li class=""></title-group> </li><li class="alt">.... </li><li class="">.... </li><li class="alt"></front> </li><li class=""><body> </li><li class="alt"><boxed-text id="s1" position="anchor"></li><li class="alt"><sidebar-label>S1.</sidebar-label></li><li class="alt"><sec id="sec1"> </li><li class=""><title>EXPERIMENTAL TECHNIQUE</title> </li><li class="alt"><p>In the case of lupus the changes in the basal membrane adversely affect differentiation of the epidermis; this results in disorders of keratinization combined with progressive atrophy.</p> </li><li class=""></sec></li><li class=""></boxed-text> </li><li class="alt">.... </li><li class="">.... </li><li class="alt"></body> </li></ol></div>I'm trying to get the value EXPERIMENTAL TECHNIQUE from the above example using both Descendants and Ancestors method of LINQ 2 XML. I've tried</div><div><div class="dp-highlighter"><div class="bar"></div><ol start="1" class="dp-c"><li class="alt">var item=from x in doc.Descendants("label") </li><li class=""> where x.Ancestors("sec") </li><li class="alt"> select x; </li></ol></div>but getting an error</div><div> Cannot implicitly convert type 'System.Collections.Generic.IEnumerable<System.Xml.Linq.XElement>' to 'bool'</div> </body></html>

Answers (3)

SQL Server date format.

How to group multiple array of object in c#