TraceReader TraceReader TraceReader Class

Definition

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.

public ref class TraceReader : IDisposable, System::Data::IDataReader
[System.Runtime.InteropServices.ComVisible(false)]
public class TraceReader : IDisposable, System.Data.IDataReader
Public Class TraceReader
Implements IDataReader, IDisposable
Inheritance
TraceReaderTraceReaderTraceReader
Derived
Attributes
Implements

Examples

Using SQL Server Profiler

Remarks

The TraceReader class provides trace data reading functionality and access to data that is common to both the TraceServer class, the TraceTable class, and the TraceFile class.

The trace data reading functionality is also available on the TraceReaderWriter class, which is derived from the TraceReader class and is used in the construction of the TraceTable class and TraceFile class.

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are safe for multithreaded operations. Any instance members are not guaranteed to be thread safe.

Constructors

TraceReader() TraceReader() TraceReader()

Initializes a new instance of the TraceReader class.

Fields

currentRow currentRow currentRow

Specifies the current row.

Properties

Depth Depth Depth

Gets the depth value for the trace reader.

FieldCount FieldCount FieldCount

Gets the number of columns in the data.

IsClosed IsClosed IsClosed

Gets the Boolean property value that specifies whether the trace reader is closed.

Item[Int32] Item[Int32] Item[Int32]

Gets the column specified by the index position.

Item[String] Item[String] Item[String]

Gets the column with the specified name.

RecordsAffected RecordsAffected RecordsAffected

Gets the number of records of data.

Methods

Close() Close() Close()

Closes the trace reader.

Dispose() Dispose() Dispose()

Deletes the trace reader information.

GetBoolean(Int32) GetBoolean(Int32) GetBoolean(Int32)

Returns a Boolean value from the record at the specified column position.

GetByte(Int32) GetByte(Int32) GetByte(Int32)

Returns a Byte value from the record at the specified column position.

GetBytes(Int32, Int64, Byte[], Int32, Int32) GetBytes(Int32, Int64, Byte[], Int32, Int32) GetBytes(Int32, Int64, Byte[], Int32, Int32)

Gets a stream of bytes from the specified column offset into the buffer as an array, starting at the given buffer offset.

GetChar(Int32) GetChar(Int32) GetChar(Int32)

Gets a character value of the specified column.

GetChars(Int32, Char[], Int32, Int32, Int32) GetChars(Int32, Char[], Int32, Int32, Int32) GetChars(Int32, Char[], Int32, Int32, Int32)

Gets a character array value from the record at the specified column position.

GetChars(Int32, Int64, Char[], Int32, Int32) GetChars(Int32, Int64, Char[], Int32, Int32) GetChars(Int32, Int64, Char[], Int32, Int32)

Gets a character array value from the record at the specified column position.

GetData(Int32) GetData(Int32) GetData(Int32)

Returns IDataReader object used when the field points to a remote data structure.

GetDataTypeName(Int32) GetDataTypeName(Int32) GetDataTypeName(Int32)

Gets the data type of the data value at the specified column position.

GetDateTime(Int32) GetDateTime(Int32) GetDateTime(Int32)

Gets a DateTime value of the data value at the specified column position.

GetDecimal(Int32) GetDecimal(Int32) GetDecimal(Int32)

Gets a Decimal value of the data value at the specified column position.

GetDouble(Int32) GetDouble(Int32) GetDouble(Int32)

Gets a floating point value of the data value at the specified column position.

GetFieldType(Int32) GetFieldType(Int32) GetFieldType(Int32)

Returns the field type of the data value at the specified column position.

GetFloat(Int32) GetFloat(Int32) GetFloat(Int32)

Gets a floating point value of the data value at the specified column position.

GetGuid(Int32) GetGuid(Int32) GetGuid(Int32)

Gets a Guid system value of the data value at the specified column position.

GetInt16(Int32) GetInt16(Int32) GetInt16(Int32)

Gets a small integer value of the data value at the specified column position.

GetInt32(Int32) GetInt32(Int32) GetInt32(Int32)

Gets an integer value of the data value at the specified column position.

GetInt64(Int32) GetInt64(Int32) GetInt64(Int32)

Gets a long integer value of the data value at the specified column position.

GetName(Int32) GetName(Int32) GetName(Int32)

Gets the name of the field at the specified column position.

GetOrdinal(String) GetOrdinal(String) GetOrdinal(String)

Gets the ordinal value of the data value at the specified column position.

GetSchemaTable() GetSchemaTable() GetSchemaTable()

Gets a table that describes the schema.

GetStream(Int32) GetStream(Int32) GetStream(Int32)

Gets the stream of data.

GetString(Int32) GetString(Int32) GetString(Int32)

Gets a String value at the specified column position.

GetTimeSpan(Int32) GetTimeSpan(Int32) GetTimeSpan(Int32)

Gets a TimeSpan value of the data value at the specified column position.

GetValue(Int32) GetValue(Int32) GetValue(Int32)

Gets a value of the data value at the specified column position.

GetValues(Object[]) GetValues(Object[]) GetValues(Object[])

Gets an array of values from the data value at the specified column position.

IsDBNull(Int32) IsDBNull(Int32) IsDBNull(Int32)

Specifies whether the specified column is set to null.

IsNull(Int32) IsNull(Int32) IsNull(Int32)

Gets a Boolean value that specifies whether value of the data at the specified column position is null.

NextResult() NextResult() NextResult()

Moves to the next result in the trace.

Read() Read() Read()

Reads the trace record.

TranslateSubclass(String, String, Int32) TranslateSubclass(String, String, Int32) TranslateSubclass(String, String, Int32)

Translates the sub class.

Applies to