How to insert xml data into existing xml in c#?

Question

i added xml file in my windows application, i want to add values to that from textbox.. i used the following code,

string path = "codedata.xml";
        XmlDocument doc = new XmlDocument();
        if (!System.IO.File.Exists(path))
        {
            //Create neccessary nodes
            XmlDeclaration declaration = doc.CreateXmlDeclaration("1.0", "UTF-8", "yes");
            XmlComment comment = doc.CreateComment("This is an XML Generated File");
            doc.AppendChild(declaration);
            doc.AppendChild(comment);
        }
        else //If there is already a file
        {
            //    //Load the XML File
            doc.Load(path);
        }

        //Get the root element
        XmlElement root = doc.DocumentElement;

        XmlElement Subroot = doc.CreateElement("data");
        XmlElement Companycode = doc.CreateElement("Companycode");
        XmlElement Productcode = doc.CreateElement("Productcode");
        XmlElement Productname = doc.CreateElement("Productname");
        XmlElement Brandcode = doc.CreateElement("Brandcode");
        XmlElement Brandname = doc.CreateElement("Brandname");

        Companycode.InnerText = txt_companycode.Text;
        Productcode.InnerText = txt_productcode.Text;
        Productname.InnerText = txt_productname.Text;
        Brandcode.InnerText = txt_brandcode.Text;
        Brandname.InnerText = txt_brandname.Text;

        Subroot.AppendChild(Companycode);
        Subroot.AppendChild(Productcode);
        Subroot.AppendChild(Productname);
        Subroot.AppendChild(Brandcode);
        Subroot.AppendChild(Brandname);
        root.AppendChild(Subroot);
        doc.AppendChild(root);


        //Save the document
        doc.Save(path);


        //Show confirmation message
        MessageBox.Show("Details  added Successfully");

it showing error near root.AppendChild(Subroot); can any one help me, wer i made mistake.

LINQ to XML is really nice in such a situation :) You get this error because there is no instance of Subroot try add this line : Subroot sub = new Subroot(); before this lineSubroot.AppendChild(Companycode); and change all Subroot to sub — Harry89pl
– Harry89pl, Commented Jul 26, 2012 at 7:53

SidAhmed · Accepted Answer · 2012-07-26 07:11:26Z

2

You can use Linq to XML, here is an example :

var xDoc = XElement.Load("FilePath");
if (xDoc == null)
   return;

var myNewElement = new XElement("ElementName"
   new XAttribute("AttributeName", value1),
   new XAttribute("AttributeName", value2)
   //And so on ...
);
xDoc.Add(myNewElement);
xDoc.Save("FilePath");

answered Jul 26, 2012 at 7:11

SidAhmed

2,3502 gold badges27 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

KV Prajapati · Accepted Answer · 2012-07-26 08:50:02Z

1

The root is null. Try to add Root element when you create XML file.

 if (!System.IO.File.Exists(path))
        {
            //Create neccessary nodes
            XmlDeclaration declaration = doc.CreateXmlDeclaration("1.0", "UTF-8", "yes");
            XmlComment comment = doc.CreateComment("This is an XML Generated File");
            doc.AppendChild(declaration);
            doc.AppendChild(comment);
            doc.AppendChild(doc.CreateElement("Root"));
        }

Or use LINQ-XML

string _file=@"c:\sample.xml";
XDocument doc;

if (!File.Exists(_file))
{
    doc = new XDocument();
    doc.Add(new XElement("Root"));
}
else
{
    doc = XDocument.Load(_file);
}

doc.Root.Add(
      new XElement("data",
                   new XElement("CompanyCode","C101"),
                   new XElement("ProductCode","P101")
            ) 
      );
doc.Save(_file);

edited Jul 26, 2012 at 8:50

answered Jul 26, 2012 at 7:09

KV Prajapati

94.8k20 gold badges151 silver badges188 bronze badges

4 Comments

chitra Over a year ago

hi, i used, it returns saved, but no data in xml file

KV Prajapati Over a year ago

You either have set physical path c:\file.xml or have a look at Debug/Bin folder if your app is winform or console.

chitra Over a year ago

hai, when i test using break point, it shows the xml file with data i saved.but if i see in codedata.xml,its empty. Where it is saving?

KV Prajapati Over a year ago

Try to set absolute path and see what happen?

Ria · Accepted Answer · 2012-07-26 07:08:34Z

0

In null XML DocumentElement is null. Try add Subroot to Document:

XmlElement root = doc.DocumentElement;

root.AppendChild(Subroot);
doc.AppendChild(root);

// new code
doc.AppendChild(Subroot);

answered Jul 26, 2012 at 7:08

Ria

10.4k3 gold badges35 silver badges62 bronze badges

3 Comments

chitra Over a year ago

i tried ur idea, its shows the msg saved, but in xml file...no data is there empty only with <?xml version="1.0" encoding="utf-8" ?> i added my xml file by add new item

Ria Over a year ago

@chitra: I tested my code and its works correctly. check output xml.

chitra Over a year ago

should i add any element in xml, before saved btn

Collectives™ on Stack Overflow

How to insert xml data into existing xml in c#?

3 Answers 3

Comments

4 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

4 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related