Write and update data from xml file ?

Question

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

Datta Kharad · 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(pathFileMode.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 Kharad · Answer

@Nafihudheen... You are welcome...

Nafihudheen KT · Answer

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 =  InnerXML1 InnerXml2 ; 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 =  InnerXML1 InnerXml2 ; 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); }

Sam Hobbs · Answer

There are several ways to do it and many articles in this web site. Just look at the articles in this web site.

Hemant Kumar · Answer

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