C#

private void Form1_Closing(object sender, FormClosedEventArgs e)<br />
     <br />
        {<br />
            MessageBox.Show("Closing Form");<br />
<br />
            string _userName = Environment.UserName;<br />
            string _date = DateTime.Now.ToString("yyyy-MM-dd-HH:mm:ss");<br />
            string _eventType = "Logged Off";<br />
            RegistryKey _regKey = Registry.LocalMachine;<br />
            RegistryKey _subRegKey = _regKey.OpenSubKey("Software\\LAT_Systray");<br />
            string _fileName = Convert.ToString(_subRegKey.GetValue("File_Name"));<br />
<br />
            XmlDocument _xmlDoc = new XmlDocument();<br />
<br />
            _xmlDoc.Load(_fileName);<br />
<br />
            //Create new Event Node in XML file<br />
            XmlElement _newEvent = _xmlDoc.CreateElement("Event");<br />
<br />
            //Create new Element time stamp in XML file "Event" node<br />
            XmlElement _newDateNode = _xmlDoc.CreateElement("EventTime");<br />
            _newDateNode.InnerText = _date;<br />
            _newEvent.AppendChild(_newDateNode);<br />
<br />
            //Create new Element UserName in XML file "Event" node<br />
            XmlElement _newUserNode = _xmlDoc.CreateElement("UserName");<br />
            _newUserNode.InnerText = Environment.UserName;<br />
            _newEvent.AppendChild(_newUserNode);<br />
<br />
            //Create new Element EventType in XML file "Event" node<br />
            XmlElement _newTypeNode = _xmlDoc.CreateElement("EventType");<br />
            _newTypeNode.InnerText = _eventType;<br />
            _newEvent.AppendChild(_newTypeNode);<br />
<br />
            //Insert after last child "Event" node in file<br />
            _xmlDoc.DocumentElement.InsertAfter(_newEvent, _xmlDoc.DocumentElement.LastChild);<br />
<br />
            //closes the file<br />
            FileStream _fsxml = new FileStream(_fileName, FileMode.Truncate, FileAccess.Write, FileShare.ReadWrite);<br />
            _xmlDoc.Save(_fsxml);<br />
            _fsxml.Close();<br />
<br />
        }

using (TransactionScope ts = new TransactionScope())
{
    //Create and open the SQL connection.  The work done on this connection will be a part of the transaction created by the TransactionScope
    SqlConnection myConnection = new SqlConnection("server=(local)\\SQLExpress;Integrated Security=SSPI;database=northwind");
    SqlCommand myCommand = new SqlCommand();
    myConnection.Open();
    myCommand.Connection = myConnection;

    //Restore database to near it's original condition so sample will work correctly.
    myCommand.CommandText = "DELETE FROM Region WHERE (RegionID = 100) OR (RegionID = 101)";
    myCommand.ExecuteNonQuery();

    //Insert the first record.
    myCommand.CommandText = "Insert into Region (RegionID, RegionDescription) VALUES (100, 'MidWestern')";
    myCommand.ExecuteNonQuery();

    //Insert the second record.
    myCommand.CommandText = "Insert into Region (RegionID, RegionDescription) VALUES (101, 'MidEastern')";
    myCommand.ExecuteNonQuery();

    myConnection.Close();

                    //Call complete on the TransactionScope or not based on input
    ConsoleKeyInfo c;
    while (true)
    {
                            Console.Write("Complete the transaction scope? [Y|N] ");
        c = Console.ReadKey();
        Console.WriteLine();

        if ((c.KeyChar == 'Y') || (c.KeyChar == 'y'))
        {
            // Commit the transaction
            ts.Complete();
            break;
        }
        else if ((c.KeyChar == 'N') || (c.KeyChar == 'n'))
        {
            break;
        }
    }
}