Please refer below code.
C#
protected void Page_Load(object sender, EventArgs e)
{
List<string> values = new List<string>();
DataSet ds = new DataSet();
ds.ReadXml(Server.MapPath("~/XMLFile.xml"));
foreach (DataRow row in ds.Tables[0].Rows)
{
string value = row.ItemArray[0].ToString();
if (value.ToLower() != "http://www.facebook.com".ToLower())
{
values.Add(value);
}
}
XmlDocument doc = new XmlDocument();
XmlDeclaration xmlDeclaration = doc.CreateXmlDeclaration("1.0", "UTF-8", null);
XmlElement root = doc.DocumentElement;
doc.InsertBefore(xmlDeclaration, root);
XmlElement urlset = doc.CreateElement(string.Empty, "urlset", string.Empty);
doc.AppendChild(urlset);
foreach (var item in values)
{
XmlElement url = doc.CreateElement(string.Empty, "url", string.Empty);
XmlElement loc = doc.CreateElement(string.Empty, "loc", string.Empty);
XmlText locText = doc.CreateTextNode(item);
loc.AppendChild(locText);
url.AppendChild(loc);
urlset.AppendChild(url);
}
doc.Save(@"C:\Users\shashikant.EXCELASOFT\Desktop\document.xml");
}
document.xml
<?xml version="1.0" encoding="UTF-8"?>
<urlset>
<url>
<loc>http://test.test.com/global/mc-lite-test-client/mc-lite/s/09db1cc9-a452-4a01-ba17-78692110</loc>
</url>
<url>
<loc>http://www.1facebook.com</loc>
</url>
</urlset>
I hope this will help you out.