XML / XSL

<?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);
				}

<?xml version="1.0" ?> 
- <WEB_SITE>
- <RECORD>
  <Name>Homepage</Name> 
  <Address>http://www.google.com</Address> 
  </RECORD>
  </WEB_SITE>

string strtmpName = string.Empty;
            string strtmpAddress = string.Empty;

            XmlTextReader reader = null;
            XDocument xmlDoc = new XDocument();
            reader = new XmlTextReader(cv.StrIndivPath1 + strLANID + cv.StrIndivPath2 + "Website.xml");
            xmlDoc = XDocument.Load(reader);
            reader.Close();
            XElement Results = XElement.Parse(xmlDoc.ToString());

            foreach (XElement xe in Results.Elements("RECORD").Descendants())
            {
                switch (xe.Name.ToString())
                {
                    case "Name":
                        if (xe.Value.ToLower() == "homepage")
                        {
                            strtmpAddress = Results.Elements("RECORD").Descendants("Address").ToString();
                            MessageBox.Show(strtmpAddress);
                        }                        
                        break;
                    //case "Address":
                    //    strtmpAddress = xe.Value;
                    //    if (txtAddress.Text == strtmpAddress)
                    //    {
                    //        AddressFlag = true;
                    //    }
                    //    break;
                    default:
                        break;
                }
            }