Write and update data from xml file ?

Nafihudheen KT

I want to create an xml file like the following format,

        1220
        1-1-2011
        15000

        1
        1-1-2011
        150

Is any body know the C# code to create, select , and update the above xml file model please help me.

Thanking you,

5 Replies

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

Datta Kharad15y ago

Accepted answer

Write Data into XML File

// New XML Element Created
XmlElement newcatalogentry = xmldoc.CreateElement("Order");

// New Attribute Created
XmlAttribute newcatalogattr = xmldoc.CreateAttribute("ID");

// Value given for the new attribute
newcatalogattr.Value = "005";

// Attach the attribute to the XML element
newcatalogentry.SetAttributeNode(newcatalogattr);

// First Element - Order - Created
XmlElement firstelement = xmldoc.CreateElement("BillNo");

// Value given for the first element
firstelement.InnerText = "1720";

// Append the newly created element as a child element
newcatalogentry.AppendChild(firstelement);


// Second Element - BillDate - Created
XmlElement secondelement = xmldoc.CreateElement("BillDate");

// Value given for the second element
secondelement.InnerText = "1-2-2011";

// Append the newly created element as a child element
newcatalogentry.AppendChild(secondelement);

// New XML element inserted into the document
xmldoc.DocumentElement.InsertAfter(newcatalogentry,
                                   xmldoc.DocumentElement.LastChild);



FileStream fsxml = new FileStream(path,FileMode.Truncate,
                                  FileAccess.Write,
                                  FileShare.ReadWrite);

// XML Document Saved
xmldoc.Save(fsxml);


=============OR=========================

  //Create the XmlDocument.
        XmlDocument doc = new XmlDocument();
        doc.LoadXml("c:/add.xml");
        //Create a new node and add it to the document.
        //The text node is the content of the price element.
        XmlElement elem = doc.CreateElement("Order");
        XmlAttribute attr1 = doc.CreateAttribute("BillNo");
        attr1.Value = "5262";
        XmlAttribute attr2 = doc.CreateAttribute("BillDate");
        attr2.Value = "02-11-2011";

        XmlAttribute attr3 = doc.CreateAttribute("TotalAmount");

        attr3.Value="8500";
        elem.SetAttributeNode(attr1);
        elem.SetAttributeNode(attr2);
         
        elem.SetAttributeNode(attr3); 
        doc.DocumentElement.AppendChild(elem);
        Console.WriteLine("Display the modified XML...");
        doc.Save("c:/add.xml");
        //remove the added element and save to modified.xml
        XmlElement root = doc.DocumentElement;
        root.RemoveChild(elem);
        doc.Save("c:/modified.xml");

Datta Kharad15y ago
@Nafihudheen...

You are welcome...
0
Nafihudheen KT15y ago
OK, finally I get the code
thanks Mr.Datta Kharad for your replay

here is the code that I used to create and update the XML file

            XmlDocument xmlDoc = new XmlDocument();
            string PATH = @"C:\mySamleXml.xml";

            //if file path exist then update else create

            if (System.IO.File.Exists(PATH))
            {
                //if the file already exist in tha PATH then updates the file

                XmlTextReader reader = new XmlTextReader(PATH);
                //XmlDocument doc = new XmlDocument();
                xmlDoc.Load(reader);
                reader.Close();
                XmlNode oldNode;
                XmlElement root = xmlDoc.DocumentElement;
                oldNode = root.SelectSingleNode("/MyFirstXML/Node1");

                XmlElement newNode = xmlDoc.CreateElement("Node1");

                newNode.SetAttribute("Value", "yourAttributeValue");
                newNode.InnerXml = "InnerXML1InnerXml2";

                newNode["Childnode1"].SetAttribute("Value", "myChildnode1");
                newNode["Childnode2"].SetAttribute("Value", "myChildNode2");

                root.ReplaceChild(newNode, oldNode);

                XmlNode oldNode2;//here is the second node
                oldNode2 = root.SelectSingleNode("/MyFirstXML/Node2");

                XmlElement newNode2 = xmlDoc.CreateElement("Node2");
                newNode2.SetAttribute("Value", "yourNode2Attribute");
                root.ReplaceChild(newNode2, oldNode2);

                xmlDoc.Save(PATH);//save updated xml nodes
            }
            else
            {
                //Creating the xml file if it does not exit in PATH
                XmlDeclaration xmlDeclaration = xmlDoc.CreateXmlDeclaration("1.0", "utf-8", null);

                // Create the root element
                XmlElement rootNode = xmlDoc.CreateElement("MyFirstXML");
                xmlDoc.InsertBefore(xmlDeclaration, xmlDoc.DocumentElement);
                xmlDoc.AppendChild(rootNode);

                //create the first node
                XmlElement newNode = xmlDoc.CreateElement("Node1");
                newNode.SetAttribute("Value", "yourAttributeValue");
                xmlDoc.DocumentElement.PrependChild(newNode);

                newNode.SetAttribute("Value", "yourAttributeValue");
                newNode.InnerXml = "InnerXML1InnerXml2";

                newNode["Childnode1"].SetAttribute("Value", "myChildnode1");
                newNode["Childnode2"].SetAttribute("Value", "myChildNode2");

                XmlElement newNode2 = xmlDoc.CreateElement("Node2");
                newNode2.SetAttribute("Value", "yourNode2Attribute");
                xmlDoc.DocumentElement.PrependChild(newNode2);
                xmlDoc.Save(PATH);
            }
0
Sam Hobbs15y ago
There are several ways to do it and many articles in this web site. Just look at the articles in this web site.
0
Hemant Kumar15y ago
Hi Please refer this link
http://www.dotnetspider.com/forum/157958-Using-C-How-Save-Update-Data-from-XML-with-out-using-sql-server-database.aspx
0