writing textbox values to xml file

Question

I have been trying to write textbox value to xml file but could not get it in right format as I wish to have

I am using following code

XDocument Xdoc = new XDocument(new XElement("Users"));
if (System.IO.File.Exists("D:\\Users.xml"))
    Xdoc = XDocument.Load("D:\\Users.xml");
else
    Xdoc = new XDocument();

XElement xml = /*new XElement("Users",*/
new XElement("User",
             new XAttribute("UserId", txtUserId.Text),
             new XAttribute("Password", txtPwd.Text));

if (Xdoc.Descendants().Count() > 0)
    Xdoc.Descendants().First().Add(xml);
else
    Xdoc.Add(xml);

Xdoc.Save("D:\\Users.xml");

Here i m getting xml in this format

<User UserId="Sunny" Password="Sunny">
<User UserId="Sunny" Password="Sunny" />
<User UserId="Sunny" Password="Sunny" />
</User>

But i wanna to have like this

<Users>
  <User>
    <UserId>Sunny</UserId>
    <Password>pwd</Password>
  </User>
  <User>
    <UserId>Sunny</UserId>
    <Password>pwd</Password>
  </User>
</Users>

alex · Accepted Answer · 2013-04-04 11:15:31Z

1

Then use XElement instead of XAttribute.

 new XElement("User",
              new XElement("UserId", txtUserId.Text),
              new XElement("Password", txtPwd.Text));

And to add multiple users, given that you have userList:

 new XElement("Users",
        userList.Select(u=>
             new XElement("User",      
                 new XElement("UserId", u.UserId),
                 new XElement("Password", u.Password)));

edited Apr 4, 2013 at 11:15

answered Apr 4, 2013 at 11:10

alex

12.7k4 gold badges50 silver badges69 bronze badges

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

5 Comments

Rajeev Kumar Over a year ago

How can i add Users as root element ??

Rajeev Kumar Over a year ago

I dont have any userlist with me. I just wanna know how i add Users at the top of xml and then add user as child of this root node

alex Over a year ago

Time to notice the pattern in using XElement :)

new XElement("Users", new XElement("User", new XElement("UserId", u.UserId),                 new XElement("Password", u.Password)))

Rajeev Kumar Over a year ago

Here i want to have Users only one time as root element. This one adding Users every time i call this code

Rajeev Kumar Over a year ago

Thanks alex you have given me nice idea how can i get this one. I have posted my own answer which works as expected..

Rajeev Kumar · Accepted Answer · 2013-04-04 11:33:14Z

My own answer

XDocument Xdoc = new XDocument(new XElement("Users"));
        if (System.IO.File.Exists("D:\\Users.xml"))
            Xdoc = XDocument.Load("D:\\Users.xml");
        else
        {
            Xdoc = new XDocument();
            XElement xmlstart = new XElement("Users");
            Xdoc.Add(xmlstart);
        }
        XElement xml = /*new XElement("Users",*/
                       new XElement("User",
          new XElement("UserId", txtUserId.Text),
          new XElement("Password", txtPwd.Text));

        if (Xdoc.Descendants().Count() > 0)
            Xdoc.Descendants().First().Add(xml);
        else
        {
            Xdoc.Add(xml);
        }

        Xdoc.Element("Users").Save("D:\\Users.xml");

This is giving me xml like

<?xml version="1.0" encoding="utf-8"?>
<Users>
  <User>
  <UserId>Sunny</UserId>
  <Password>Sunny</Password>
 </User>
 <User>
   <UserId>Sunny</UserId>
   <Password>Sunny</Password>
 </User>
 <User>
   <UserId>Sunny</UserId>
   <Password>Sunny</Password>
 </User>
</Users>

DGibbs · Accepted Answer · 2013-04-04 11:16:44Z

0

If you want the values to appear as elements then you should use XElement instead of XAttribute...

E.g.

XElement xml = /*new XElement("Users",*/
                   new XElement("User",
                   new XElement("UserId", "sunny"),
                   new XElement("Password", "pwd")
                   );

To add these elements under the root use:

Xdoc.Element("Users").Add(xml);

answered Apr 4, 2013 at 11:16

DGibbs

14.7k7 gold badges49 silver badges89 bronze badges

Comments

Smaug · Accepted Answer · 2013-04-04 11:30:26Z

It just changed from XAttribute to XElement. Because attributes would be added inside the element like . Elements play a different role which form a tree XML structure.

The Root element is now become Users as per your requirement.

XElement xml = new XElement("Users",   
                       new XElement("User",
                       new XElement("UserId", "sunny"),
                       new XElement("Password", "pwd")
                       ));

If you want repeatedly add the child element use the below code block either individual or in loop.

xml.Add(
new XElement("User", new XElement("UserId", "sunny"), new XElement("Password", "pwd") ) );

Refer your complete sample

XDocument Xdoc = new XDocument(new XElement("Users"));
        if (System.IO.File.Exists("D:\\Users.xml"))
            Xdoc = XDocument.Load("D:\\Users.xml");
        else
            Xdoc = new XDocument();

       XElement xml = /*new XElement("Users",*/
                       new XElement("User",
                       new XElement("UserId", "sunny"),
                       new XElement("Password", "pwd")
                       );

        if (Xdoc.Descendants().Count() > 0)
            Xdoc.Descendants().First().Add(xml);
        else
        {
            Xdoc.Add(xml);
        }

        Xdoc.Save("D:\\Users.xml");

How can i add users as root element.Please have a look at edited question again

Vikramsinh Shinde · Accepted Answer · 2013-04-04 11:32:54Z

0

Give a try for this,

    var users= new XElement("Users");

    var userXml= new XElement("User",
                   new XElement("UserId", txtUserId.Text),
                   new XElement("Password", txtPwd.Text)
                   );

    users.Add(userXml);

answered Apr 4, 2013 at 11:32

Vikramsinh Shinde

2,8832 gold badges26 silver badges30 bronze badges

Collectives™ on Stack Overflow

writing textbox values to xml file

5 Answers 5

5 Comments

Comments

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

5 Comments

Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related