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