How To create XML Format using C#

A very basic form that get you going and you can improve the code as you want.

static void CreateXML()
{
    XmlDocument doc = new XmlDocument();

    XmlNode rootNode = doc.CreateElement("etaalup_count");
    doc.AppendChild(rootNode);

    XmlNode countNode = doc.CreateElement("countnodes");
    XmlAttribute serviceAttribute = doc.CreateAttribute("serviceid");
    serviceAttribute.Value = "A022114704152";
    countNode.Attributes.Append(serviceAttribute);
    XmlAttribute countAttribute = doc.CreateAttribute("count");
    countAttribute.Value = "10";
    countNode.Attributes.Append(countAttribute);
    rootNode.AppendChild(countNode);

    countNode = doc.CreateElement("countnodes");
    serviceAttribute = doc.CreateAttribute("serviceid");
    serviceAttribute.Value = "A022114704153";
    countNode.Attributes.Append(serviceAttribute);
    countAttribute = doc.CreateAttribute("count");
    countAttribute.Value = "15";
    countNode.Attributes.Append(countAttribute);
    rootNode.AppendChild(countNode);

    countNode = doc.CreateElement("countnodes");
    serviceAttribute = doc.CreateAttribute("serviceid");
    serviceAttribute.Value = "A022114704154";
    countNode.Attributes.Append(serviceAttribute);
    countAttribute = doc.CreateAttribute("count");
    countAttribute.Value = "5";
    countNode.Attributes.Append(countAttribute);

    rootNode.AppendChild(countNode);
    doc.Save(Console.Out);
}

The WriteChars method of the XmlWriter class writes characters to XML. It takes an array of characters and writes one character at a time.

The following code snippet takes an array of characters and writes them to an XML file.

using (XmlWriter writer = XmlWriter.Create("M.xml")) {
writer.WriteStartDocument();

char[] ch = new char[6];
ch[0] = 'm';
ch[1] = 'a';
ch[2] = 'h';
ch[3] = 'e';
ch[4] = 's';
ch[5] = 'h';

writer.WriteStartElement("WriteChars");

writer.WriteChars(ch, 0, ch.Length);

writer.WriteEndElement();

writer.WriteEndDocument();

}

You can create xml from database table like this:


using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Diagnostics;
partial class myxml : System.Web.UI.Page
{

protected void Button1_Click(object sender, EventArgs e)
{
System.Data.DataSet ds = new System.Data.DataSet();
System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter("Select * from demo", "Data Source=184.107.55.15;Initial Catalog=training;User ID=ing;Password=ing");
da.Fill(ds);
// Write to XML here

ds.WriteXml("D:\\output.xml", System.Data.XmlWriteMode.WriteSchema);
}
}