C#

EventClass : Audit Logout
TextData :
ApplicationName : LoadTestRun1
NTUserName : NETWORK SERVICE
LoginName : sa
CPU : 0
Reads : 10
Writes : 0
Duration : 459920
ClientProcessID : 0
Spid : 2969
StartTime : 2006-02-01 15:16:12.987

public static DataSet ExecuteSqlCommand(SqlCommand command, string dataSetName)
{
 //argument validation
 if (command == null)
 {
  throw new ArgumentNullException("command");
 }

 if (dataSetName == null)
 {
  throw new ArgumentNullException("dataSetName");
 }

 //set dataset values
 DataSet returnDataSet = new DataSet();
 returnDataSet.DataSetName = dataSetName;
 returnDataSet.Locale = CultureInfo.InvariantCulture;

 try
 {
  SqlDataAdapter sda = new SqlDataAdapter(command);
  sda.Fill(returnDataSet);
  sda.Dispose();
  sda = null;

  return returnDataSet;
 }
 catch
 {
  throw;
 }
 finally
 {
  //cleanup resources and connections
  if (command.Connection.State != ConnectionState.Closed)
  {
   command.Connection.Close();
  }

  command.Connection.Dispose();
  command.Connection = null;
  command.Dispose();
  command = null;
 }
}

<br />
		public void OnCreateMessage(string TermID, string AddressLine, string MessageText)<br />
		{<br />
		private byte[] HeaderBegin = new byte[]{0xFF, 0x00, 0xAA, 0x55, 0x00, 0x1E, 0x48, 0x02, 0x00, 0x01, <br />
									   0x4C, 0x00, 0x00, 0x00, 0x00, 0x00, 0x00, 0x00, 0x00, 0x00, <br />
									   0x08, 0xD2, 0x00, 0x00, 0x00, 0x00};<br />
		private byte[] HeaderEnd = new byte[]{0x55, 0xAA, 0x00, 0xFF};<br />
<br />
			Encoding enc = Encoding.ASCII;<br />
			uint nTermID = (uint)Encoding.ASCII.GetByteCount(TermID);<br />
			uint nAddressLine = (uint)Encoding.ASCII.GetByteCount(AddressLine);<br />
			uint nMessageText = (uint)Encoding.ASCII.GetByteCount(MessageText);<br />
			string sMyMsg = TermID+ASCII.CR+ASCII.LF+AddressLine+ASCII.CR+ASCII.LF+MessageText;<br />
			byte[] myBytes = enc.GetBytes(sMyMsg);<br />
			byte[] MyMsg = new byte[30+nTermID+nAddressLine+nMessageText+4];<br />
<br />
			MyMsg = HeaderBegin;<br />
			myBytes.CopyTo(MyMsg, 26);<br />
			HeaderEnd.CopyTo(MyMsg, MyMsg.Length);<br />