XML / XSL

XmlTextWriter				myXmlTextWriter = new XmlTextWriter ("D:/New Folder/MyXmlff.xml",System.Text.Encoding.UTF8);
		      myXmlTextWriter.Formatting = Formatting.Indented;
			  myXmlTextWriter.WriteStartDocument(false);
			  myXmlTextWriter.WriteStartElement("root");
			  myXmlTextWriter.WriteAttributeString("xmlns","urn:iso:std:iso:20022:tech:xsd:pain.001.001.02"); 
			  myXmlTextWriter.WriteStartElement("pain.001.001.02");
                          myXmlTextWriter.WriteComment("Section A : Group Header");
		          myXmlTextWriter.WriteStartElement("GrpHdr");
		          myXmlTextWriter.WriteStartElement("MsgId");
myXmlTextWriter.Flush();
            myXmlTextWriter.WriteEndElement();
            myXmlTextWriter.WriteEndElement();
			myXmlTextWriter.Close();

<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <connectionStrings>
    <add name="Application.Properties.Settings.DBConnectionString"
      connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\DB.mdb"
      providerName="System.Data.OleDb" />
  </connectionStrings>
</configuration>

<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <connectionStrings>
    <add name="Application.Properties.Settings.DBConnectionString"
      connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\DB.mdb"
      providerName="System.Data.OleDb" />
  </connectionStrings>
</configuration>
<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <connectionStrings>
    <add name="Application.Properties.Settings.DBConnectionString"
      connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\DataBase\DB.mdb"
      providerName="System.Data.OleDb" />
  </connectionStrings>
</configuration>

//xml document object
System.Xml.XmlDocument xdoc = new System.Xml.XmlDocument();

FileStream reader = new FileStream(this._XmlFilePath, FileMode.Open, FileAccess.ReadWrite);

xdoc.XmlResolver = null;

//load the xml file
xdoc.Load(reader);

System.Xml.XmlElement Node = (System.Xml.XmlElement)xdoc.DocumentElement.SelectSingleNode("//configuration/connectionStrings/add[@name=\"Application.Properties.Settings.DBConnectionString\"]");
if (Node != null)
{
    //key found, set the value
    Node.Attributes.GetNamedItem("Source").Value = "C:\DataDabe\DB.mdb";

    //finally, save the new version of the config file
    xdoc.Save(reader);
    reader.Close();
}

void GenericProcedureCompleted(object sender, GenericProcedureCompletedEventArgs e)
		{
			svcClient.GenericProcedureCompleted -= new EventHandler<GenericProcedureCompletedEventArgs>(GenericProcedureCompleted);
			ShowError(e.sErrorMsg);
			if (!string.IsNullOrEmpty(e.Result))
			{
				System.IO.StringReader sr = new System.IO.StringReader(e.Result);
				XDocument xDoc = XDocument.Load(sr);	
				CreateTable(xDoc);
			}
		}

xEl = xDoc.Descendants("XMLData").ToList()[0];
				foreach (XElement xe in xEl.Elements())
				{
					oCol = new CTUI.Data.DataColumn();
					oCol.ColumnName = xe.Name.LocalName;
					oCol.DataType = typeof(string);
					dtData.Columns.Add(oCol);
				}