使用XDOCUMENT和XELEMENT的XML的子元素 [英] Child elements of an XML using XDOCUMENT and XELEMENT

问题描述

我有以下结构的XML ...

Hi , I have the XML with the below structure...

<TABLE NAME="PDF " PRIMARYKEYE="PDF ">
  <FIELD NAME="PNUMBER" FIELD="FieldTypeNumber" />
  <FIELD NAME="STATUS" FIELDTYPE="FieldTypeNumber" />
  <FIELD NAME="COMPANY" FIELDTYPE="FieldTypeNumber" />
<FORM NAME="PDF_DOC" TITLE="REGEN_PDF_DOC">
  <FORMFIELD NAME="POLICY_NUMBER" DBCOLUMNNAME="(SLECT POLICY_NUMBER FROM POLICY ,NOTE WHERE POLICY.POLICY=NOTE.TABLE_KEY)" />
  <FORMFIELD NAME="STATUS" DBCOLUMNNAME="(SELECT STATUS FROM STATUS_VALUE)" />
  <FORMFIELD NAME="COMPANY" DBCOLUMNNAME="(SELECT COMPANY FROM COMPANY WHERE COMPANY=20000)" />
  <FORMFIELD NAME="ENTERPRISE" />
  <FORMFIELD NAME="EFFECTIVE_DATE" />
</FORM>
<SEARCH NAME="SEARCHPDF" ORDERBYCLAUSE="PDF ">
  <JOIN TABLE="NOTATION" TYPE="LEFT" ON="PDF  CONDITION="ISNOTNULL" />
  <JOIN TABLE="PNUM" TYPE="INNER" ON="NOTE= POLICY" CONDITION="ISNOTNULL" />
  <SEARCHFIELD NAME="PNUMBER" LABEL="PNUMBER" />
  <SEARCHFIELD NAME="EFFECTIVE_DATE" LABEL="EFFECTIVE DATE" />
</SEARCH>
  </TABLE>

xml内容按名称以xelement的形式提供表：





XElement table = this.filename.Root.Elements（TABLE）。Single（W => W.Attribute（NAME）。Value.Equals（PDF））;



现在我试图列出元素nae为JOIN的元素以下语法;



IEnumerable< xelement> joins = table.Element（SEARCH）。元素（JOIN）;



但是即使执行后，变量连接仍然具有空值而不是2个连接元素。有人可以看一下吗？

The xml content is available as an xelement by name table:


XElement table = this.filename.Root.Elements("TABLE").Single(W => W.Attribute("NAME").Value.Equals("PDF "));

Now im trying to list out the elements with the element nae as JOIN with the below syntax;

IEnumerable<xelement> joins = table.Element("SEARCH").Elements("JOIN");

but even after execution , the variable joins still has null value instead of 2 join elements . Can someone look into this?

推荐答案

XElement table = xmlDoc.Elements("TABLE").Single(W => W.Attribute("NAME").Value.Equals("PDF "));
IEnumerable<XElement> joins = table.Elements("SEARCH").First().Elements("JOIN");

这篇关于使用XDOCUMENT和XELEMENT的XML的子元素的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！