To create Xml using xmldocument,xmlwriter and xmltextreader
There are various methods of creating an xmldocument and they are as follows
a)using Xmldocument b)using xmlwriter c)Using xmltextwriter
The XmlDocument is a read/write consisting of a tree of XML nodes in memory.
One can perform as many edits as possible anywhere in the document prior to writing it out to a stream,whereas
XmlWriter is a write-only object which helps to write a well-formed XML to a stream.
There are no read capabilities and the write capabilities are forward-only as well
Different Mehtods of creating Xml tags using .net
There are various methods of creating xml tags and the following are mentioned below
a)Using Xmldocument class
b)Using Xml Writer
c)Using xml Text WriterUsing XML Document
Using the xml document is a bit more slow process when compared to either xmlwriter or xmltextwriter and
it involves more object oriented work when compared to xmlwriter,Firstly the xmldocument is instantiated and the root nodes are created
using createelement() method similarly the attributes for the nodes can be created using CreateAttribute() methods,Each time after creating the
node and the attribute it has to appended to the document using the Append() method on the Attributes property.Finally, After creating the nodes the document is
saved using the Save method.Sample Code
The code given below is an example of creating xml using xmldocument
public void createNodes()
{
XmlDocument XDoc = new XmlDocument();
// Create root node.
XmlElement XElemRoot = XDoc.CreateElement("Employee");
//Add the node to the document.
XDoc.AppendChild(XElemRoot);
XmlElement Xsource = XDoc.CreateElement("EmployeeDetails");
XElemRoot.AppendChild(Xsource);
XmlElement XTemp = XDoc.CreateElement("EmpId");
XTemp.InnerText = "1";
Xsource.AppendChild(XTemp);
XTemp = XDoc.CreateElement("EmpName");
XTemp.InnerText = "Test Name";
Xsource.AppendChild(XTemp);
XTemp = XDoc.CreateElement("Designation");
XTemp.InnerText = "Test Desig";
Xsource.AppendChild(XTemp);
XDoc.Save(@"D:\temp\xmlfile.xml");
}Using Xml Writer
Xmlwriter,An abstract class which is used to write xml data from objects in memory,Providing fast,forward
only,non-cached methods of generating files containing XML data.
The xmlwriter is created by initializing it as follows
XmlWriter xmlWriter = XmlWriter.Create("test.xml");
To create the root element the keywords WriteStartDocument(),WriteStartElement("Employees") are used
further,the keyword WriteWhitespace is used which is used to form the tag in the appropriate position
The inner text for each tags were formed using WriteString method
refer the sample code on creating a xml file using xmlwriter
public void createNodeWriter()
{
string sConnection = ConfigurationSettings.AppSettings.Get("Dsn");//reading the connection from the app.configfile
SqlConnection strCon = new SqlConnection(sConnection);
strCon.Open();
SqlDataAdapter da = new SqlDataAdapter("select top 10 name,email,phonenumber,city from tableName order by empid desc", strCon);
DataTable dt = new DataTable();
da.Fill(dt);
strCon.Close();
XmlWriter xmlWriter = XmlWriter.Create("test.xml");
xmlWriter.WriteStartDocument();
xmlWriter.WriteStartElement("EmpDetails");
xmlWriter.WriteWhitespace("\n");
for (int i = 0; i < dt.Rows.Count; i++)
{
xmlWriter.WriteStartElement("EmployeeInfo");
xmlWriter.WriteWhitespace("\n");
//xmlWriter.WriteAttributeString("age", "42");
xmlWriter.WriteStartElement("Name");
xmlWriter.WriteString(dt.Rows[i]["name"].ToString().Trim());
xmlWriter.WriteEndElement();
xmlWriter.WriteWhitespace("\n");
xmlWriter.WriteStartElement("Email");
xmlWriter.WriteString(dt.Rows[i]["email"].ToString().Trim());
xmlWriter.WriteEndElement();
xmlWriter.WriteWhitespace("\n");
xmlWriter.WriteStartElement("Phonenumber");
xmlWriter.WriteString(dt.Rows[i]["phonenumber"].ToString().Trim());
xmlWriter.WriteEndElement();
xmlWriter.WriteWhitespace("\n");
xmlWriter.WriteStartElement("City");
xmlWriter.WriteString(dt.Rows[i]["city"].ToString().Trim());
xmlWriter.WriteEndElement();
xmlWriter.WriteWhitespace("\n");
xmlWriter.WriteEndElement();
xmlWriter.WriteWhitespace("\n");
}
xmlWriter.WriteEndDocument();
xmlWriter.Close();
}Using Xml Text Writer
Both xmlwriter and xmltextwriter are defined in the namespace system.Xml,Besides they do have some diffetences and they are as follows
Xmlwriter is an abstractclass and XmlTextWriter is a specific implementation of XmlWriter.Also,the xmltextwriter is used to create forward
only,non-cached methods of generating files containing XML data
below is the sample code to create xml using xmltextwriter
public void createTextNodeWriter()
{
string sConnection = ConfigurationSettings.AppSettings.Get("defaultDsn");
SqlConnection strCon = new SqlConnection(sConnection);
strCon.Open();
SqlDataAdapter da = new SqlDataAdapter("select top 10 name,email,phonenumber,city from TableName order by empid desc", strCon);
DataTable dt = new DataTable();
da.Fill(dt);
strCon.Close();
using (XmlTextWriter xmlTxtWriter = new XmlTextWriter("C:\\temp\\Test.xml", null))
{
xmlTxtWriter.WriteStartDocument();
xmlTxtWriter.WriteStartElement("EmpDetails");
xmlTxtWriter.WriteWhitespace("\n");
for (int i = 0; i < dt.Rows.Count; i++)
{
xmlTxtWriter.WriteStartElement("EmployeeInfo");
xmlTxtWriter.WriteWhitespace("\n");
xmlTxtWriter.WriteStartElement("Name");
xmlTxtWriter.WriteString(dt.Rows[i]["name"].ToString().Trim());
xmlTxtWriter.WriteEndElement();
xmlTxtWriter.WriteWhitespace("\n");
xmlTxtWriter.WriteStartElement("Email");
xmlTxtWriter.WriteString(dt.Rows[i]["email"].ToString().Trim());
xmlTxtWriter.WriteEndElement();
xmlTxtWriter.WriteWhitespace("\n");
xmlTxtWriter.WriteStartElement("Phonenumber");
xmlTxtWriter.WriteString(dt.Rows[i]["phonenumber"].ToString().Trim());
xmlTxtWriter.WriteEndElement();
xmlTxtWriter.WriteWhitespace("\n");
xmlTxtWriter.WriteStartElement("City");
xmlTxtWriter.WriteString(dt.Rows[i]["city"].ToString().Trim());
xmlTxtWriter.WriteEndElement();
xmlTxtWriter.WriteWhitespace("\n");
xmlTxtWriter.WriteEndElement();
xmlTxtWriter.WriteWhitespace("\n");
}
xmlTxtWriter.WriteEndDocument();
xmlTxtWriter.Close();
}
}
Difference between XmlDocument vs XmlWriter
The XmlDocument is a read/write consisting of a tree of XML nodes in memory.
One can perform as many edits as possible anywhere in the document prior to writing it out to a stream,whereas
XmlWriter is a write-only object which helps to write a well-formed XML to a stream.
There are no read capabilities and the write capabilities are forward-only as well