给定以下XML,我想返回eventtype id = 23的所有eventtitles。我当前的查询只查看第一个eventtype,所以返回了错误的结果。
<event>
<eventtitle>Garrison Keillor</eventtitle>
<eventtypes>
<eventtype id="24"/>
<eventtype id="23"/>
</eventtypes>
</event>
<event>
<eventtitle>Joe Krown Trio featuring Walter Wolfman Washington</eventtitle>
<eventtypes>
<eventtype id="23"/>
</eventtypes>
</event>LINQ查询:
Dim query = _
From c In calXML...<event> _
Where c...<eventtypes>.<eventtype>.@id = "23" _
Select c.<eventtitle>.Value, c.<eventlocation>.Value
For Each item In query
Response.Write("<h3>" & item.eventtitle & "</h3>")
Response.Write(item.eventlocation & "<br />")
Next发布于 2010-03-09 04:32:58
您需要调用Any,如下所示:
Dim query = _
From c In calXML...<event> _
Where c.<eventtypes>.<eventtype>.Any(Function(t) t.@id = "23") _
Select c.<eventtitle>.Value, c.<eventlocation>.Value https://stackoverflow.com/questions/2404510
复制相似问题