TraceReader Members

  • Article

The TraceReader class is an abstract Trace Object class that is used in the construction of the TraceServer class, the TraceTable class, and the TraceFile class.

The following tables list the members exposed by the TraceReader type.

Public Constructors

  Name Description
TraceReader Initializes a new instance of the TraceReader class.

Top

Protected Fields

  Name Description
ms220877.protfield(en-US,SQL.90).gif currentRow Specifies the current row.

Top

Public Properties

  Name Description
ms220877.pubproperty(en-US,SQL.90).gif Depth Gets the depth value for the trace reader.
ms220877.pubproperty(en-US,SQL.90).gif FieldCount Gets the number of columns in the data.
ms220877.pubproperty(en-US,SQL.90).gif IsClosed Gets the Boolean property value that specifies whether the trace reader is closed.
ms220877.pubproperty(en-US,SQL.90).gif Item Overloaded. Gets the specified column.
ms220877.pubproperty(en-US,SQL.90).gif RecordsAffected Gets the number of records of data.

Top

Public Methods

(see also Protected Methods )

  Name Description
ms220877.pubmethod(en-US,SQL.90).gif Close Closes the trace reader.
ms220877.pubmethod(en-US,SQL.90).gif Dispose Deletes the trace reader information.
ms220877.pubmethod(en-US,SQL.90).gif Equals  Overloaded. (inherited from Object )
ms220877.pubmethod(en-US,SQL.90).gif GetBoolean Returns a Boolean value from the record at the specified column position.
ms220877.pubmethod(en-US,SQL.90).gif GetByte Returns a Byte value from the record at the specified column position.
ms220877.pubmethod(en-US,SQL.90).gif GetBytes Gets a stream of bytes from the specified column offset into the buffer as an array, starting at the given buffer offset.
ms220877.pubmethod(en-US,SQL.90).gif GetChar Gets a character value of the specified column.
ms220877.pubmethod(en-US,SQL.90).gif GetChars Overloaded. Gets a character array value from the specified column position, starting at the buffer offset.
ms220877.pubmethod(en-US,SQL.90).gif GetData Returns IDataReader object used when the field points to a remote data structure.
ms220877.pubmethod(en-US,SQL.90).gif GetDataTypeName Gets the data type of the data value at the specified column position.
ms220877.pubmethod(en-US,SQL.90).gif GetDateTime Gets a DateTime value of the data value at the specified column position.
ms220877.pubmethod(en-US,SQL.90).gif GetDecimal Gets a Decimal value of the data value at the specified column position.
ms220877.pubmethod(en-US,SQL.90).gif GetDouble Gets a floating point value of the data value at the specified column position.
ms220877.pubmethod(en-US,SQL.90).gif GetFieldType Returns the field type of the data value at the specified column position.
ms220877.pubmethod(en-US,SQL.90).gif GetFloat Gets a floating point value of the data value at the specified column position.
ms220877.pubmethod(en-US,SQL.90).gif GetGuid Gets a Guid system value of the data value at the specified column position.
ms220877.pubmethod(en-US,SQL.90).gif GetHashCode  (inherited from Object )
ms220877.pubmethod(en-US,SQL.90).gif GetInt16 Gets a small integer value of the data value at the specified column position.
ms220877.pubmethod(en-US,SQL.90).gif GetInt32 Gets an integer value of the data value at the specified column position.
ms220877.pubmethod(en-US,SQL.90).gif GetInt64 Gets a long integer value of the data value at the specified column position.
ms220877.pubmethod(en-US,SQL.90).gif GetName Gets the name of the field at the specified column position.
ms220877.pubmethod(en-US,SQL.90).gif GetOrdinal Gets the ordinal value of the data value at the specified column position.
ms220877.pubmethod(en-US,SQL.90).gif GetSchemaTable Gets a table that describes the schema.
ms220877.pubmethod(en-US,SQL.90).gif GetStream Gets the stream of data.
ms220877.pubmethod(en-US,SQL.90).gif GetString Gets a String value at the specified column position.
ms220877.pubmethod(en-US,SQL.90).gif GetTimeSpan Gets a TimeSpan value of the data value at the specified column position.
ms220877.pubmethod(en-US,SQL.90).gif GetType  (inherited from Object )
ms220877.pubmethod(en-US,SQL.90).gif GetValue Gets a value of the data value at the specified column position.
ms220877.pubmethod(en-US,SQL.90).gif GetValues Gets an array of values from the data value at the specified column position.
ms220877.pubmethod(en-US,SQL.90).gif IsDBNull Specifies whether the specified column is set to null.
ms220877.pubmethod(en-US,SQL.90).gif IsNull Gets a Boolean value that specifies whether value of the data at the specified column position is null.
ms220877.pubmethod(en-US,SQL.90).gif NextResult Moves to the next result in the trace.
ms220877.pubmethod(en-US,SQL.90).gif Read Reads the trace record.
ms220877.pubmethod(en-US,SQL.90).gifms220877.static(en-US,SQL.90).gif ReferenceEquals  (inherited from Object )
ms220877.pubmethod(en-US,SQL.90).gif ToString  (inherited from Object )
ms220877.pubmethod(en-US,SQL.90).gif TranslateSubclass Translates the sub class.

Top

Protected Methods

  Name Description
ms220877.protmethod(en-US,SQL.90).gif Finalize  (inherited from Object )
ms220877.protmethod(en-US,SQL.90).gif MemberwiseClone  (inherited from Object )

Top

See Also

Reference

TraceReader Class
Microsoft.SqlServer.Management.Trace Namespace

Other Resources

Trace Flags (Transact-SQL)
Using SQL Server Profiler