如何使用循环删除Xml数据 [英] How to remove the Xml Data wiht out Using Loop

问题描述

我有一个Xml在下面



我想删除有RID = 34的xml数据（hc_client_branch）节点



如何删除Xml数据



xml在一个对象中

I have one Xml that is below

I want to remove the xml data (hc_client_branch) node which is having RID=34

how can i Remove the Xml data

Below xml in one object

<FCOMMON_DATA>
    <HC_CLIENT_BRANCH>
      <RID>6</RID>
      <BranchName>15-04-Branch</BranchName>
      <ClientID>4</ClientID>
      <ORG_ACCESS />
      <VERT_ACCESS>,D1,D2, OR ,U4,U23,,</VERT_ACCESS>
      <Status>0</Status>
      <IsActive>0</IsActive>
      <ClientName>Check Client</ClientName>
      <DeptCode />
  </HC_CLIENT_BRANCH>
  <HC_CLIENT_BRANCH>
      <RID>2</RID>
      <BranchName>29thApril2014</BranchName>
      <ClientID>10</ClientID>
      <ORG_ACCESS />
      <VERT_ACCESS>,D1,D2, OR ,U17,U20,,</VERT_ACCESS>
      <Status>0</Status>
      <IsActive>0</IsActive>
      <ClientName>29thApril2014</ClientName>
      <DeptCode />
  </HC_CLIENT_BRANCH>
  <HC_CLIENT_BRANCH>
      <RID>34</RID>
      <BranchName>AA Branch</BranchName>
      <ClientID>25</ClientID>
      <ORG_ACCESS />
      <VERT_ACCESS>,D1,D2, OR ,T1,T2, OR ,U4,U23,,</VERT_ACCESS>
      <Status>0</Status>
      <IsActive>0</IsActive>
      <ClientName>AA</ClientName>
      <DeptCode />
  </HC_CLIENT_BRANCH>
  <HC_CLIENT_BRANCH>
      <RID>32</RID>
      <BranchName>aaaaa</BranchName>
      <ClientID>33</ClientID>
      <ORG_ACCESS />
      <VERT_ACCESS />
      <Status>0</Status>
      <IsActive>0</IsActive>
      <ClientName>aaaaa</ClientName>
      <DeptCode />
  </HC_CLIENT_BRANCH>
</FCOMMON_DATA>

删除节点输出后将

After Removing the Node Output Will Be

<FCOMMON_DATA>
    <HC_CLIENT_BRANCH>
      <RID>6</RID>
      <BranchName>15-04-Branch</BranchName>
      <ClientID>4</ClientID>
      <ORG_ACCESS />
      <VERT_ACCESS>,D1,D2, OR ,U4,U23,,</VERT_ACCESS>
      <Status>0</Status>
      <IsActive>0</IsActive>
      <ClientName>Check Client</ClientName>
      <DeptCode />
  </HC_CLIENT_BRANCH>
  <HC_CLIENT_BRANCH>
      <RID>2</RID>
      <BranchName>29thApril2014</BranchName>
      <ClientID>10</ClientID>
      <ORG_ACCESS />
      <VERT_ACCESS>,D1,D2, OR ,U17,U20,,</VERT_ACCESS>
      <Status>0</Status>
      <IsActive>0</IsActive>
      <ClientName>29thApril2014</ClientName>
      <DeptCode />
  </HC_CLIENT_BRANCH>
  <HC_CLIENT_BRANCH>
      <RID>32</RID>
      <BranchName>aaaaa</BranchName>
      <ClientID>33</ClientID>
      <ORG_ACCESS />
      <VERT_ACCESS />
      <Status>0</Status>
      <IsActive>0</IsActive>
      <ClientName>aaaaa</ClientName>
      <DeptCode />
  </HC_CLIENT_BRANCH>
</FCOMMON_DATA>

任何人帮助我

any one help me

推荐答案

试试这个（请注意，如果语法不完善，这是来自内存，谷歌）。我希望这能让你走上正确的道路：

Try this (note that this is from memory, google if the syntax is not perfect). I hope this sets you on the right path:

dim list As NodeList = xmlCommonData.SelectNodes("//RID[.="34"]/ancestor::HC_CLIENT_BRANCH")

for each n as XmlNode in list
    n.Remove
' You may have to do xmlCommonData.Remove(n) maybe ?
Next

如果这有帮助，请接受解决方案，以便其他人可以找到它。

If this helps, please accept the solution so that others may find it.

这篇关于如何使用循环删除Xml数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！