How to write data to an XML file?

Question

I know this is a simple question but I am stuck. I have a simple WinForms application that collects the server name, username, and password and then under service credentials, the account and password. I simply want to write these values to an XML text file (not a database). I guess it should create the file if it doesn't exist. Do I need to create a root element? Can someone please help me out?

private System.Windows.Forms.Label label1;
private System.Windows.Forms.TextBox txtServerName;
private System.Windows.Forms.TextBox txtDatabaseUserName;
private System.Windows.Forms.TextBox txtDatabasePassword;
private System.Windows.Forms.TextBox txtServicePassword;
private System.Windows.Forms.TextBox txtAccount;

All I have so far is:

 private void btnSave_Click(object sender, System.EventArgs e)
        {
            string fileName = System.IO.Path.Combine(Application.StartupPath, "alphaService.xml");
            XmlDocument doc = new XmlDocument();
            doc.LoadXml(fileName);

            XmlNode databaseServer = doc.CreateElement("DatabaseServer");
            XmlNode databaseUserName = doc.CreateElement("DatabaseServerName");
        }

score 3 · Accepted Answer · edited May 23 '17 at 12:10

3

First create the XML string see this answer for many ways to do that .

For example:

XDocument doc = new XDocument();     
XElement xml = new XElement("Info",
    new XElement("Password", password),
    new XElement("UserName", userName));
doc.Add(xml);
doc.Save(path);

edited May 23 '17 at 12:10

Community

1
1

answered Feb 19 '14 at 18:19

ispiro

25,277
32
126
258

What if I wanted to use XmlNode? – user2471435 Feb 19 '14 at 18:25
@user2471435 I don't know. I'm used to using `XElement`. I edited my answer to include some. – ispiro Feb 19 '14 at 18:28
That was it! Pretty simple. The only thing I am not doing is I should not write the password in clear text. How do I solve that? – user2471435 Feb 19 '14 at 18:49

score 1 · Answer 2 · edited May 23 '17 at 10:31

1

This is a bit of an open ended question as you don't supply the database structure, I'd recommend though to access the DB through entity framework (google it) and then follow this guide:

Export SQL Server Database Table to XML Using Linq

edited May 23 '17 at 10:31

Community

1
1

answered Feb 19 '14 at 18:20

Jon Barker

1,755
14
24

There is no database structure. I am just trying to write to a simple XML text file. – user2471435 Feb 19 '14 at 18:23

How to write data to an XML file?

2 Answers2