c# - 从具有特定名称属性的父级获取裸体

Question

我有以下 XML 文档:

<database name="pressPlay">
    <table name="users">
      <column name="userID"       type="INT"            constraints="tableID_c" />
      <column name="username"     type="VARCHAR(50)"    constraints="user_c" />
      <column name="password"     type="VARCHAR(50)"    constraints="not_null_c" />
    </table>
    <table name="song">
      <column name="songID"       type="INT"            constraints="tableID_c" />
      <column name="albumID"      type="INT"            constraints="albumFK_c" />
      <column name="artistID"     type="INT"            constraints="artistFK_c" />
      <column name="songName"     type="VARCHAR(50)"    constraints="not_null_c" />
      <column name="songDuration" type="VARCHAR(5)"     constraints="not_null_c" />
      <column name="link"         type="VARCHAR(100)" />
    </table>
    <table name="album">
      <column name="albumID"      type="INT"            constraints="tableID_c" />
      <column name="albumName"    type="VARCHAR(50)"    constraints="not_null_c" />
      <column name="albumGener"   type="VARCHAR(50)"    constraints="not_null_c" />
    </table>
    <table name="artist">
      <column name="artistID"     type="INT"            constraints="tableID_c" />
      <column name="artistName"   type="VARCHAR(50)"    constraints="not_null_c" />
    </table>

    <constraints>
      <constraint name="tableID_c"    type="unique"     content="not_null" increment="auto"/>
      <constraint name="user_c"       type="unique"     content="not_null"/>
      <constraint name="not_null_c"                     content="not_null"/>
      <constraint name="albumFK_c"    type="forign_key" content="not_null" columns="album.albumID" />
      <constraint name="artistFK_c"   type="forign_key" content="not_null" columns="artist.artistID" />
    </constraints>    
</database>

现在我需要的是从共享具有特定名称属性的父节点的节点获取属性。

我尝试使用 XmlNodeList 但这给了我所有名为 column 的节点，而不管父节点的名称是什么，即:

我需要列节点的名称属性，父名称是用户。

有人知道怎么做吗？我已经绞尽脑汁了一段时间了..

Answer 1

类似的东西:

XmlDocument inventory = new XmlDocument();
inventory.Load("inventory.xml");

XmlNodeList elements = inventory.SelectNodes("/XMLProject/table[@name='users']/column");
foreach (XmlElement element in elements)
{
    ...
}

这会给你:

<column name="userID"       type="INT"            constraints="tableID_c" />
<column name="username"     type="VARCHAR(50)"    constraints="user_c" />
<column name="password"     type="VARCHAR(50)"    constraints="not_null_c" />

现在您可以遍历每个并获取其属性。