Loading

duplicate nodes based on specific nodes in XML

duplicate nodes based on specific nodes in XML

darma teja

10y920Visual Basic .NET

my XML file is like this:

type1

India

US

type2

India

US

type3

India

US

type4

India

US

I want to duplicate the "text" node for every "pro1" and "pro2" nodes:

The output should be like this:

type1

India

type1

US

type2

India

type2

US

type3

India

type3

US

type4

India

type4

US

Advance thanks,

Darma

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Midhun Tp10y ago
Accepted answer
Hidarma teja,
Try below code -
XDocument doc = XDocument.Load(Server.MapPath("XMLFile.xml"));
var k = doc.Descendants("texts").ToList();
for (int i = 0; i < k.Count(); i++)
{
var f = k[i];
var l = k[i].Descendants("text").ToList();
for (int j = 0; j < l.Count(); j++)
{
l[j].AddAfterSelf(l[j]);
}
l = k[i].Descendants("text").ToList();
for (int j = 0; j < l.Count(); j++)
{
if ((j + 1) % 2 == 0)
{
l[j].Descendants("pro1").ToList().Remove();
}
else
{
l[j].Descendants("pro2").ToList().Remove();
}
}
}
doc.Save(Server.MapPath("Newxml.xml"));
darma teja10y ago
Hi Bikesh,
thanks for hint.
I tried like this: unfortunately no success.
[Serializable()]
public class text1
{
[System.Xml.Serialization.XmlElement("type")]
public string type { get; set; }
[System.Xml.Serialization.XmlElement("pro1")]
public string pro1 { get; set; }
[System.Xml.Serialization.XmlElement("finalText")]
public string finalText{ get; set; }
}
[Serializable()]
[System.Xml.Serialization.XmlRoot("Root")]
public class Root
{
[XmlArray("root")]
[XmlArrayItem("root", typeof(text1))]
public text1[] text1 { get; set; }
}
Bikesh Srivastava10y ago
Hi,Teja
To resolve this problem very easy way,
FirstlyDeserializeyour xml into your c# object,thereafter you can perform action easily..
try this if resolve mark as answer otherwise reply me.