Modifying the XML - Deleting certain nodes in a give xml

Hello,

This is the given xml:
"<EmailList>
   <Email>
    <EmailAddress>first@test.com</EmailAddress>
  </Email>
  <Email>
    <EmailAddress>second@test.com</EmailAddress>
  </Email>
  <Email>
    <EmailAddress>third@test.com</EmailAddress>
  </Email>
  <Email>
    <EmailAddress/>
  </Email>
  <Email>
    <EmailAddress/>
  </Email>
  <Email>
    <EmailAddress/>
  </Email>
  <Email>
    <EmailAddress/>
  </Email>
  <Email>
    <EmailAddress/>
  </Email>
  <Email>
    <EmailAddress/>
  </Email>
<Email>
    <EmailAddress/>
  </Email>
<EmailList>"


I want to delete the 'Email' node in the above xml and modify that as below:
"<EmailList>
      <EmailAddress>first@test.com</EmailAddress>
      <EmailAddress>second@test.com</EmailAddress>
      <EmailAddress>third@test.com</EmailAddress>
      <EmailAddress/>
      <EmailAddress/>
      <EmailAddress/>
      <EmailAddress/>
      <EmailAddress/>
     <EmailAddress/>
      <EmailAddress/>
 <EmailList>"

i have the above xml in a string, that is lstrSendingXml.
i am triying as below:

XMLDoc.LoadXml(lstrSendingXml)
XMLNode = RewardDoc.SelectSingleNode("EmailList/Email")

Any help would be greatly appreciated.


Start Free Trial