Read XML in C#

Sign in to leave a comment.

• 

  Gohil Jayendrasinh14y agoPosted May 14, 2012, 2:27 AM

  Good One
• TC

  thiago costa15y agoPosted Sep 26, 2011, 7:50 PM

  hey man, thank you for providing us with this awesome code. I don't know much, but I usually take for ever to do this kind of thing, now its easy to learn from what is more likely to be obvious.
• AM

  Arsenio Madrazo15y agoPosted Mar 29, 2011, 5:03 AM

  Hi Prashanth First thnaks you for this great article. I've read it and tried to adapt to my own xml schema. This is a fragment of my xml file("Carrusel.xml") <Datos> <dato img_Url="images/galeria/foto_1.png" page_Url="http://www.atesa.es/webcorporativa/paginas/ofertas1.aspx" /> . . </Datos> And this is the code to write(to intend) a new node. void InsertItems(String sImagenUrl, String sPaginaUrl) { String rootPath = Server.MapPath("~"); String archivoXmlPath = Path.Combine(rootPath, "Xml//Carrusel.xml"); XmlDocument xmlDoc = new XmlDocument(); xmlDoc.Load(archivoXmlPath); XmlElement dato = xmlDoc.CreateElement("dato"); XmlAttribute imgenUrl = xmlDoc.CreateAttribute("img_Url"); XmlAttribute paginaUrl = xmlDoc.CreateAttribute("page_Url"); imgenUrl.InnerText = sImagenUrl; paginaUrl.InnerText = sPaginaUrl; dato.AppendChild("dato"); imgenUrl.InsertAfter("img_Url", "dato"); paginaUrl.InsertAfter("page_Url", "dato"); xmlDoc.DocumentElement.AppendChild("dato"); xmlDoc.Save(archivoXmlPath); } But I received errors. Where is the bug?. Thanks in advanced. Arsenio
• 

  angelo sucks16y agoPosted Oct 12, 2010, 7:22 PM

  great code.. but can i add adding,edit,and del button..?whats the code..?thx b4
  • 

    Prashanth Chindam16y agoeditedPosted Oct 20, 2010, 3:26 PMEdited Oct 20, 2010, 10:41 PM

    Code for inserting, updating, deleting records in xml file: we can perform these operations in two ways: i)performing operations on xml file and saving changes, which includes creating xml elements(tags), assigning values, appending them to xml root element,... (for this we have to include namespace 'using System.Xml') ii)performing operations on dataset and saving to xml file Here, I will show inserting code in two ways; updating and deleting codes using second method. Insert Code: i) XmlDocument doc = new XmlDocument(); doc.Load(openFileDialog1.FileName); XmlElement root = doc.CreateElement("student") XmlElement sno = doc.CreateElement("sno"); XmlElement sname = doc.CreateElement("sname"); XmlElement course = doc.CreateElement("course"); XmlElement fee = doc.CreateElement("fee"); XmlElement photo = doc.CreateElement("photo"); sno.InnerText = sno_txtbx.Text; sname.InnerText = sname_txtbx.Text; course.InnerText = course_txtbx.Text; fee.InnerText = fee_txtbx.Text; string ppath = pictureBox1.ImageLocation; photo.InnerText == ppath.Substring(ppath.LastIndexOf('\\') + 1); root.AppendChild(sno); root.AppendChild(sname); root.AppendChild(course); root.AppendChild(fee); root.AppendChild(photo); doc.DocumentElement.AppendChild(root); doc.Save(openFileDialog1.FileName); MessageBox.Show("record inserted"); ii) DataRow drow=ds.Tables[0].NewRow(); drow[0] = sno_txtbx.Text; drow[1] = sname_txtbx.Text; drow[2] = course_txtbx.Text; drow[3] = fee_txtbx.Text; ppath = pictureBox1.ImageLocation; drow[4]=ppath.Substring(ppath.LastIndexOf('\\') + 1); ds.Tables[0].Rows.Add(drow); ds.WriteXml(fpath); MessageBox.Show("record inserted"); Update Code: if (sno_txtbx.Text!= null) { DataRow drow = ds.Tables[0].Rows.Find(sno_txtbx.Text); rno = ds.Tables[0].Rows.IndexOf(drow); ds.Tables[0].Rows[rno][0]=sno_txtbx.Text; ds.Tables[0].Rows[rno][1]= sname_txtbx.Text; ds.Tables[0].Rows[rno][2]=course_txtbx.Text; ds.Tables[0].Rows[rno][3]=fee_txtbx.Text; ppath = pictureBox1.ImageLocation; ds.Tables[0].Rows[rno][4] = ppath.Substring(ppath.LastIndexOf('\\') + 1); ds.WriteXml(openFileDialog1.FileName); MessageBox.Show("record updated"); } Delete Code: if (sno_txtbx.Text != null) { DataRow drow = ds.Tables[0].Rows.Find(sno_txtbx.Text); ds.Tables[0].Rows.Remove(drow); ds.WriteXml(openFileDialog1.FileName); MessageBox.Show("record deleted"); rno = 0; showdata(); Note: use browse button for placing photo in the picturebox private void browsebtn_Click(object sender, EventArgs e) { openFileDialog2.Filter = "bmp|*.bmp|jpeg|*.jpg|all files|*.*"; DialogResult res = openFileDialog2.ShowDialog(); if (res == DialogResult.OK) { pictureBox1.ImageLocation = openFileDialog2.FileName; } } --------------- Thanks for Ur feedback ~ Ur's Prashanth.Chindam