CODEWITHSUNDEEP
c#xml
dotnet-practitioner
dotnet-practitioner

Reputation: 14148

VS2005 .net 2.0 c# : Best way to create xml file

What is the best way to create xml file in .net 2.0 in terms of nodes etc. I dont think I could use LINQ. Any code sample or article would be helpful.

Upvotes: 2

Views: 1128

Answers (2)

Chris Zwiryk
Chris Zwiryk

Reputation: 1317

You best bet is to use the XmlTextWriter class.

Here's a pretty basic example:

var writer = new XmlTextWriter("Foo.xml", Encoding.UTF8);
writer.WriteStartDocument();
writer.WriteStartElement("Foo");
writer.WriteAttributeString("hello", "world"); 
writer.WriteEndElement();
writer.WriteEndDocument();
writer.Close();

This will give you:

<?xml version="1.0" encoding="utf-8"?>
<Foo hello="world" />

Upvotes: 4

Rap
Rap

Reputation: 7282

Here's a code snippet that works:

XmlTextWriter myXW  = new XmlTextWriter(@"C:\NewXmlFile.xml", Encoding.UTF8)
myXW.WriteStartDocument();
myXW.WriteStartElement("Customers");
string strConn = myConnectionString;
OleDbConnection myConn = new OleDbConnection(strConn);
myConn.Open();
OleDbCommand myCMD = new OleDbCommand("select * from customers", myConn);
OleDbDataReader myRdr = myCMD.ExecuteReader();
while (myRdr.Read())
{
    myXW.WriteStartElement("Customer");
    myXW.WriteAttributeString("id", myRdr.GetString(0));
    myXW.WriteElementString("companyname", myRdr.GetString(1));
    myXW.WriteElementString("contactname", myRdr.GetString(2));
    myXW.WriteElementString("contactname", myRdr.GetString(3));
    myXW.WriteElementString("address", myRdr.GetString(4));
    myXW.WriteElementString("city", myRdr.GetString(5));
    myXW.WriteElementString("country", myRdr.GetString(8));
    myXW.WriteElementString("phone", myRdr.GetString(9));
    myXW.WriteElementString("fax", myRdr.GetString(10));
    myXW.WriteEndElement();
}
myXW.WriteEndElement();
myXW.WriteEndDocument();
myXW.Flush();
myXW.Close();

Upvotes: 1

Related Questions