how to avoid dulicate values in XML using asp.net

Question

0.00/5 (No votes)

See more:

C#

public void insertXML()
  {
      try
      {

          // Open the XML doc
          System.Xml.XmlDocument myXmlDocument = new System.Xml.XmlDocument();
          myXmlDocument.Load(Server.MapPath("AddProducts.xml"));

          System.Xml.XmlNode myXmlNode = myXmlDocument.DocumentElement.FirstChild;

          // Create new XML element and populate its attributes
          System.Xml.XmlElement myXmlElement = myXmlDocument.CreateElement("product");
          myXmlElement.SetAttribute("name", Server.HtmlEncode(txtname.Text));


          // Insert data into the XML doc and save
          myXmlDocument.DocumentElement.InsertBefore(myXmlElement, myXmlNode);
          myXmlDocument.Save(Server.MapPath("AddProducts.xml"));

          // Re-bind data since the doc has been added to
          BindData();
      }
      catch (Exception ex)
      {
          Log(ex.Message, ex.StackTrace);
          ScriptManager.RegisterClientScriptBlock(this.Page, this.GetType(), "Exception Message", "alert('You have an exception,please consult IT department')", true);
      }

  }

My XML File is

XML

<?xml version="1.0" encoding="utf-8"?>
<Footballers>
  <product name="iop" />
  <product name="Selvit E" />
  <product name="Selvit E" />
  <product name="Ventrifort A" />
  <product name="Generator" />
  <product name="TEst" />        
  <product name="test" />
  <product name="Test" />
  <product name="test" />
  <product name="ILT" />
  <product name="No Parking" />
  <product name="No Parking" />
  <product name="Livol Liquid" />
  <product name="G-promin" />
</Footballers>

Please how to do this?please help me?

Posted 24-Aug-14 18:21pm

ramaraog96

Updated 24-Aug-14 18:39pm

v2

Add a Solution

Comments

Sergey Alexandrovich Kryukov 25-Aug-14 1:02am

Why adding those duplicates in data in first place? Would not avoiding it be better then removing them later? :-)
—SA

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

touchofevil · Answer 1 · 2014-08-27T20:21:00

Before actually creating a node you can check if there's any duplicate existing using XPathExpression.

C#

// Open the XML doc  
XmlDocument myXmlDocument = new System.Xml.XmlDocument();
myXmlDocument.Load("XMLFile1.xml");

XmlNode myXmlNode = myXmlDocument.DocumentElement.FirstChild;

//Before creating a new element check if an element like that already exists
// If data is case sensitive you can use either String.ToLower() or String.ToUpper()
// to get your data in same case.
string expression = string.Format(@"/Footballers/product[@name = ""{0}""]", Server.HtmlEncode(txtname.Text));
XmlNodeList existingNodes = myXmlDocument.SelectNodes(expression);

// Create new XML element and populate its attributes only if no existing nodes found
if (existingNodes.Count == 0)
{
    XmlElement myXmlElement = myXmlDocument.CreateElement("product");
    myXmlElement.SetAttribute("name", Server.HtmlEncode(txtname.Text));

    // Insert data into the XML doc and save  
    myXmlDocument.DocumentElement.InsertBefore(myXmlElement, myXmlNode);
}

Using Xpath expression will allow you a good range of filters to filter your nodes.

Have a look at
XPath Tutorial[^]

how to avoid dulicate values in XML using asp.net

1 solution

Solution 1

Add your solution here

Preview 0

how to avoid dulicate values in XML using asp.net

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us