Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 299
  • Last Modified:

How Do I Delete An XML Node And Its Children With C# Without Leaving An Empty Element Behind?

Hello.
I am trying to delete an XML node and all its children without leaving behind an empy element.  Below is the xml before the delete:

<?xml version="1.0" encoding="utf-8"?>
<WorkTeams>
  <WorkTeam Name="BlueTeam">
    <HomeBase>Los Angeles</HomeBase>
    <Vehicles>35</Vehicles>
    <VehicleMfgs>
      <VehicleMfg>Toyota</VehicleMfg>
      <VehicleMfg>Nissan</VehicleMfg>
      <VehicleMfg>Volvo</VehicleMfg>
    </VehicleMfgs>
  </WorkTeam>
  <WorkTeam Name="RedTeam">
    <HomeBase>San Diego</HomeBase>
    <Vehicles>20</Vehicles>
    <VehicleMfgs>
      <VehicleMfg>Ford</VehicleMfg>
      <VehicleMfg>Dodge</VehicleMfg>
      <VehicleMfg>Suzuki</VehicleMfg>
    </VehicleMfgs>
  </WorkTeam>
</WorkTeams>

I am trying to delete the node for   <WorkTeam Name="RedTeam"> and all its children.  I have written the following C# code to do this but the problem with it is that it leaves behind an empy node:

            XmlDocument anXmlDoc = new XmlDocument();
            const string XmlFilePath = "c:\\workteams.xml";
            const string XmlFileModifiedPath = "c:\\workteams2.xml";

            anXmlDoc.Load(XmlFilePath);

            XmlNodeList anXmlNodeListOfWorkTeam = anXmlDoc.GetElementsByTagName("WorkTeam");

            XmlNode anXMLNodeForWorkTeam = anXmlNodeListOfWorkTeam[0].SelectSingleNode("/WorkTeams/WorkTeam[@Name='RedTeam']");

            if (anXMLNodeForWorkTeam != null)
            {  
                anXMLNodeForWorkTeam.RemoveAll();
                anXmlDoc.Save(XmlFileModifiedPath);
            }

After running the above C# program the XML ends up looking as follows:

<?xml version="1.0" encoding="utf-8"?>
<WorkTeams>
  <WorkTeam Name="BlueTeam">
    <HomeBase>Los Angeles</HomeBase>
    <Vehicles>35</Vehicles>
    <VehicleMfgs>
      <VehicleMfg>Toyota</VehicleMfg>
      <VehicleMfg>Nissan</VehicleMfg>
      <VehicleMfg>Volvo</VehicleMfg>
    </VehicleMfgs>
  </WorkTeam>
  <WorkTeam>
  </WorkTeam>
</WorkTeams>

At the bottom I am left with an empty node showing as
<WorkTeam>
</WorkTeam>

How can I perform the delete without ending up with this empty node?  A code example solving the above example is what I am looking for.  Thanks in advance
0
zonkerman
Asked:
zonkerman
  • 2
1 Solution
 
burakiewiczCommented:
try this
if (anXMLNodeForWorkTeam != null)
            {  
anXmlNodeListOfWorkTeam[0].RemoveChild(anXMLNodeForWorkTeam);
                anXmlDoc.Save(XmlFileModifiedPath);
            }
0
 
jandromedaCommented:
Use this code.
XmlDocument anXmlDoc = new XmlDocument();
            const string XmlFilePath = "c:\\workteams.xml";
            const string XmlFileModifiedPath = "c:\\workteams2.xml";
 
            anXmlDoc.Load(XmlFilePath);
 
XmlNode removeNode = anXmlDoc.SelectSingleNode("//WorkTeam[@Name='RedTeam']");
			anXmlDoc.DocumentElement.RemoveChild(removeNode);

Open in new window

0
 
zonkermanAuthor Commented:
Hello Jandromeda.
Your code does all nodes related to RedTeam properly.  Thanks!  Looks like you might have forgotten to add the save statement but you did plan to implement it because of the XMLFileModifiedPath variable so I simply added that one statement

anXmlDoc.Save(XmlFileModifiedPath);

to the end of your sample as follows:

        private void button2_Click(object sender, EventArgs e)
        {
            XmlDocument anXmlDoc = new XmlDocument();
            const string XmlFilePath = "c:\\workteams.xml";
            const string XmlFileModifiedPath = "c:\\workteams2.xml";

            anXmlDoc.Load(XmlFilePath);

            XmlNode removeNode = anXmlDoc.SelectSingleNode("//WorkTeam[@Name='RedTeam']");
            anXmlDoc.DocumentElement.RemoveChild(removeNode);
            anXmlDoc.Save(XmlFileModifiedPath);
        }
0
 
jandromedaCommented:
I intentionally did not included it as you already know how to save an Xml document. I'm really sorry if that cause you any inconveniences.
Happy coding! :)
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now