C # Read and Write xml files

C # Read and Write XML files

* *************************** Phone. xml ****************************

<? Xml version = "1.0" encoding = "UTF-8"?>
<PhoneBook>
<Phone id = "001">
<Name> Garfield </Name>
<Number> 5555555 </Number>
<City> New York </City>
<DateOfBirth> 26/10/1978 </DateOfBirth>
</Phone>
<Phone id = "002">
<Name> Mike </Name>
<Number> 6666666 </Number>
<City> New York </City>
<DateOfBirth> 12/02/1978 </DateOfBirth>
</Phone>
</PhoneBook>

**************************************** *****************************

· Use Document to read and write XML data

Private void xmlfun ()
{
XmlDocument doc = new XmlDocument ();
Doc. Load (Server. MapPath ("phone. xml "));

XmlElement node = doc. CreateElement ("phone ");
XmlAttribute recognition = doc. CreateAttribute ("id ");
Recognition. InnerText = "003 ";
Node. Attributes. Append (ASD );

XmlNode xnode = (XmlNode) doc. CreateElement ("Name ");
Xnode. InnerText = "testName ";
Node. AppendChild (xnode );

Xnode = (XmlNode) doc. CreateElement ("Number ");
Xnode. InnerText = "119 ";
Node. AppendChild (xnode );
Xnode = (XmlNode) doc. CreateElement ("City ");
Xnode. InnerText = "cs ";
Node. AppendChild (xnode );
Xnode = (XmlNode) doc. CreateElement ("DateOfBirth ");
Xnode. InnerText = "12/02/1978 ";
Node. AppendChild (xnode );
Doc. DocumentElement. InsertAfter (node, doc. DocumentElement. LastChild );

Doc. Save (Server. MapPath ("phone1.xml "));//Different files must be saved.

}

 

· XML writing using XmlTextWriter

Private void xmlwriter ()
{
XmlTextWriter writer = new XmlTextWriter (Server. MapPath ("phone4.xml"), null );
Writer. Formatting = Formatting. Indented; // indent format
Writer. Indentation = 4;

Writer. WriteStartDocument ();

Writer. WriteStartElement ("Person ");

Writer. WriteStartAttribute ("ID", null );
Writer. WriteString ("004 ");
Writer. WriteEndAttribute ();

Writer. WriteStartElement ("Name ");
Writer. WriteString ("testWriterName ");
Writer. WriteEndElement ();

Writer. WriteStartElement ("Number ");
Writer. WriteString ("88888 ");
Writer. WriteEndElement ();

Writer. WriteStartElement ("City ");
Writer. WriteString ("testWriterCity ");
Writer. WriteEndElement ();

Writer. Flush ();
Writer. Close ();

}

 

· Use XmlTextReader to read XML

Private void xmlread ()
{
XmlTextReader reader = new XmlTextReader (Server. MapPath ("phone. xml "));
While (reader. Read ())
{
If (reader. LocalName. Equals ("Name") | reader. LocalName. Equals ("Number "))
{
This. Label1.Text + = reader. ReadString () + "" t ";
}

 

· Function SqlCommand. ExecuteXmlReader () to retrieve XML

SqlConnecting conn = new SqlConnection (CONNSTR );
SqlCommand cmd = new SqlCommand ("select fname from employeeFor xml auto", Conn );
Conn. open ();
XmlReader reader = cmd. ExecuteXmlReader (); TEST