Delete element from xml file, based on sub-element

[veenna]

hi all,


I have this XML file

<?xml version="1.0" encoding="utf-8"?>
<Settings>
  <MapInfo>
    <text>item1</text>
    <positionLeft>55.426666259765625</positionLeft>
    <positionTop>163.94999694824219</positionTop>
    <original>item1</original>
  </MapInfo>
  <MapInfo>
    <text>item2</text>
    <positionLeft>103.42666625976563</positionLeft>
    <positionTop>110.94999694824219</positionTop>
    <original>name</original>
  </MapInfo>
</Settings>

How do i remove mapinfo node with all its sub nodes based on 'text' element it has?

I tried something like this

xDocument.Descendants().Descendants("MapInfo").Descendants().Where(e => e.Value == "item1").Remove();

it just removed text node from mapinfo.

Any idea?


Regards
Veena

[Dormilich]

because you call .Remove() on that text node. you have to climb up to <MapInfo> and call .Remove() there.

[Monomachus]

hi all,


I have this XML file

<?xml version="1.0" encoding="utf-8"?>
<Settings>
  <MapInfo>
    <text>item1</text>
    <positionLeft>55.426666259765625</positionLeft>
    <positionTop>163.94999694824219</positionTop>
    <original>item1</original>
  </MapInfo>
  <MapInfo>
    <text>item2</text>
    <positionLeft>103.42666625976563</positionLeft>
    <positionTop>110.94999694824219</positionTop>
    <original>name</original>
  </MapInfo>
</Settings>

How do i remove mapinfo node with all its sub nodes based on 'text' element it has?

I tried something like this

xDocument.Descendants().Descendants("MapInfo").Descendants().Where(e => e.Value == "item1").Remove();

it just removed text node from mapinfo.

Any idea?


Regards
Veena

xDocument.Descendants("MapInfo").Descendants("text").FirstOrDefault(el => el.Value == "item1").Parent.Remove();

[Monomachus]

xDocument.Descendants("MapInfo").Descendants("text").FirstOrDefault(el => el.Value == "item1").Parent.Remove();

What I made there is selecting first the element <text>item1</text> and than selecting his parent, which obviously is MapInfo, and remove it.

[drhowarddrfine]

I don't understand. That's not XML or XSL or XPath or anything I've seen.

[Monomachus]

I don't understand. That's not XML or XSL or XPath or anything I've seen.

That's LINQ to XML. It is a .NET thing. Let's say it's a "framework" to deal with different kind-of lists. It is used with Collections, SQL and XML in .NET.

More information here - LINQ to XML

[drhowarddrfine]

Ok. Didn't know this was a Windows only question.