How to write HTML tags in XML using CDATA (disable-output-escaping)-C#

              
C# code to write XML:

                   XmlWriter writer = XmlWriter.Create(MapPath("xmls1.xml"))

                   writer.WriteStartDocument();

                    writer.WriteStartElement("root");
                    writer.WriteStartElement("Items");        // Create subroot
                    for (int col = 0; col < 5; col++)
                    {
                        writer.WriteStartElement("Title");
                        writer.WriteCData("<b>HI</b>This is title");
                        writer.WriteEndElement();
                    }
                    writer.WriteEndElement();                // End subroot
                    writer.WriteEndElement();                  

                    writer.WriteEndDocument();

Output :

<?xml version="1.0" encoding="utf-8"?>
<root>
<items>
    <Title><![CDATA[<b>HI</b>This is title]]></Title>
  </items>
.......
</root>



NOTE :

When Transform the XML using XSLT , Set disable-output-escaping="yes", to get the output same as in node i.e with html tags.

<xslt:foreach select="root/items">
 <h1>
          <xsl:value-of select="title" disable-output-escaping="yes"/>
 </h1> 
</xsl:foreach>

Create XML through LINQ - C#

1. Firstly, Add namespace to use "XElement " class: 

 using System.Xml.Linq;


2. Call this Method to get the xml in string "getXML" :

 public void MethodToWriteXml()
    {     

XElement contacts =
    new XElement("Contacts",
        new XElement("Contact",
            new XElement("Name", "Patrick Hines"),
            new XElement("Phone", "206-555-0144", 
                new XAttribute("Type", "Home")),
            new XElement("phone", "425-555-0145",
                new XAttribute("Type", "Work")),
            new XElement("Address",
                new XElement("Street1", "123 Main St"),
                new XElement("City", "Mercer Island"),
                new XElement("State", "WA"),
                new XElement("Postal", "68042")
            )
        )
    );

        string getXML = contacts.ToString();
    }



Output: (get output in string 'getXML')

<Contacts>
  <Contact>
    <Name>Patrick Hines</Name>
    <Phone Type="Home">206-555-0144</Phone>
    <phone Type="Work">425-555-0145</phone>
    <Address>
      <Street1>123 Main St</Street1>
      <City>Mercer Island</City>
      <State>WA</State>
      <Postal>68042</Postal>
    </Address>
  </Contact>
</Contacts>

Create XML using XML Writer

 Create Datatable with Data :

  private DataTable createDT()
    {
        // Initialise Datatable
        DataTable dt = new DataTable("root");
        // add columns with their Datatypes
        dt.Columns.Add("title", Type.GetType("System.String"));                     
        dt.Columns.Add("metakeyword", Type.GetType("System.String"));            
        dt.Columns.Add("metadescription", Type.GetType("System.String"));
        dt.Columns.Add("heading", Type.GetType("System.String"));
        dt.Columns.Add("albumurl", Type.GetType("System.String"));
        dt.Columns.Add("noofimg", Type.GetType("System.String"));
        dt.Columns.Add("albumname", Type.GetType("System.String"));
        dt.Columns.Add("date", Type.GetType("System.String"));
        dt.Columns.Add("imagename", Type.GetType("System.String"));
        dt.Columns.Add("imageurl", Type.GetType("System.String"));
        dt.Columns.Add("position", Type.GetType("System.String"));
        dt.Columns.Add("imagealbumname", Type.GetType("System.String"));

        DataRow dr = dt.NewRow();
        dr["title"] = "fafasf";
        dr["metakeyword"] = "dfvvbb";
        dr["metadescription"] = "qwert";
        dr["heading"] = "vgttt";
        dr["albumurl"] = "1313";
        dr["noofimg"] = "asdad";
        dr["albumname"] = "opopi";
        dr["date"] = "t56647";
        dr["imagename"] = "gfgfg";
        dr["imageurl"] = "jhkhjk";
        dr["position"] = "kjhjk";
        dr["imagealbumname"] = "etert";

        dt.Rows.Add(dr);
        return dt;
    }

Create XML from Datatable as you want :

 private void WriteXML(DataTable dt)
    {
        using (XmlWriter writer = XmlWriter.Create(MapPath("my.xml")))           // creates 'employee.xml' to write data from datatable
        {
            int i = 0;
            writer.WriteStartDocument();
            writer.WriteStartElement(dt.TableName);                                        // create root node

            for (; i < 8; i++)
            {
                writer.WriteElementString(dt.Columns[i].ColumnName, dt.Rows[0][i].ToString());
            }

            writer.WriteStartElement("Gallery");

            for (; i < dt.Columns.Count; i++)                                                    // create sub root..
            {
                writer.WriteElementString(dt.Columns[i].ColumnName, dt.Rows[0][i].ToString());
            }
            writer.WriteEndElement();
            writer.WriteEndElement();                                              // end root node
            writer.WriteEndDocument();
        }
    }




Call:

protected void Page_Load(object sender, EventArgs e)
    {
                  WriteXML(createDT());
     }


Output :

my.xml

<?xml version="1.0" encoding="utf-8"?>
<root>
  <title>fafasf</title>
  <metakeyword>dfvvbb</metakeyword>
  <metadescription>qwert</metadescription>
  <heading>vgttt</heading>
  <albumurl>1313</albumurl>
  <noofimg>asdad</noofimg>
  <albumname>opopi</albumname>
  <date>t56647</date>
  <Gallery>
    <imagename>gfgfg</imagename>
    <imageurl>jhkhjk</imageurl>
    <position>kjhjk</position>
    <imagealbumname>etert</imagealbumname>
  </Gallery>
</root>

Create XML manually using XML writer

 XmlWriterSettings settings = new XmlWriterSettings();
        settings.Indent = true;
        using (XmlWriter writer = XmlWriter.Create(MapPath("Products.xml"), settings))
        {
            writer.WriteStartDocument();
            writer.WriteComment("This file is generated by the program.");
            writer.WriteStartElement("Books");
//if u want  foreach()    
             writer.WriteStartElement("Book");
            writer.WriteAttributeString("ISBN", "0553212419");
            writer.WriteElementString("Title", "Sherlock Holmes");
            writer.WriteElementString("Author", "Sir Arhur Conan Doyle");
            writer.WriteEndElement();
//end foreach
            writer.WriteEndElement();
            writer.WriteEndDocument();
            writer.Flush();
        }

It Creates "Products.xml" file as a output,



Product.xml
<?xml version="1.0" encoding="utf-8"?>
<!--This file is generated by the program.-->
<Books>
  <Book ISBN="0553212419">
    <Title>Sherlock Holmes</Title>
    <Author>Sir Arhur Conan Doyle</Author>
  </Book>
</Books>

Create XML file from Datatable with some additonal nodes.

Create Datatable (u can use your datatable)

 private DataTable createDT()
    {
        // Initialise Datatable
        DataTable dt = new DataTable();
        // add columns with their Datatypes
        dt.Columns.Add("Id", Type.GetType("System.String"));                    // decimal type
        dt.Columns.Add("Country_ID", Type.GetType("System.String"));             // string type
        dt.Columns.Add("Name", Type.GetType("System.String"));
        dt.Columns.Add("Description", Type.GetType("System.String"));

        DataRow dr = dt.NewRow();
        dr["Id"] = "323";
        dr["Country_ID"] = "india";
        dr["Name"] = "isaa";
        dr["Description"] = "ewewed";
        dt.Rows.Add(dr);
        return dt;
    }


Create XML file from datatable "dt"

  private void WriteXML(DataTable dt)
    {
        using (XmlWriter writer = XmlWriter.Create(MapPath("employees.xml")))       // creates 'employee.xml' to write data from datatable
        {
            writer.WriteStartDocument();
            writer.WriteStartElement("root");                                        // create root node named 'root'

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                writer.WriteElementString("ID", dt.Rows[i]["Id"].ToString());                        // create childs of the root
                writer.WriteElementString("Country_ID", dt.Rows[i]["Country_ID"].ToString());

                writer.WriteStartElement("Gallery");                                     // create sub root..
                writer.WriteElementString("Name", dt.Rows[i]["Name"].ToString());                  // create sub child nodes..
                writer.WriteElementString("Description", dt.Rows[i]["Description"].ToString());
                writer.WriteEndElement();
            }
            writer.WriteEndElement();                                              // end root node
            writer.WriteEndDocument();
        }
    }


Output : (employees.xml)

<?xml version="1.0" encoding="utf-8"?>
<root>
  <ID>323</ID>
  <Country_ID>india</Country_ID>
  <Gallery>
    <Name>isaa</Name>
    <Description>ewewed</Description>
  </Gallery>
</root>