Using the <i class="emphasis">OleDbDataReader</i> Class

Using the OleDbDataReader Class

The OleDbDataReader class creates a data reader for use with an OLE DB data provider. Here is the inheritance hierarchy of this class:

Object
   MarshalByRefObject
      OleDbDataReader

You can find the more notable public properties of OleDbDataReader objects in Table 22.24 and their more notable methods in Table 22.25. (This class has no non-inherited events.)

Table 22.24: Noteworthy public properties of *OleDbDataReader* objects.
Property	Means
Depth	Gets the current row's nesting depth.
FieldCount	Gets the number of columns in the current row.
IsClosed	Indicates if a data reader is closed.
Item	Gets the value in a field.
RecordsAffected	Gets the number of rows changed, inserted, or deleted by an SQL statement.

Table 22.25: Noteworthy public methods of *OleDbDataReader* objects.
Method	Means
Close	Closes the data reader.
GetBoolean	Gets a field's value as a Boolean.
GetByte	Gets a field's value as a byte.
GetBytes	Reads a stream of bytes.
GetChar	Gets a field's value as a character.
GetChars	Reads a stream of characters.
GetDataTypeName	Gets the name of the source data type.
GetDateTime	Gets a field's value as a DateTime object.
GetDecimal	Gets a field's value as a Decimal object.
GetDouble	Gets a field's value as a double-precision floating point number.
GetFieldType	Gets the Type that is the data type of the object.
GetFloat	Gets a field's value as a single-precision floating point number.
GetGuid	Gets a field's value as a globally unique identifier (GUID).
GetInt16	Gets a field's value as a 16-bit signed integer.
GetInt32	Gets a field's value as a 32-bit signed integer.
GetInt64	Gets a field's value as a 64-bit signed integer.
GetName	Gets the name of the specified column.
GetOrdinal	Gets the column ordinal, given the name of the column.
GetSchemaTable	Returns a schema.
GetString	Gets a field's value as a string.
GetValue	Gets the value of the column in its original format.
GetValues	Gets all the attribute columns in the current row.
IsDBNull	Indicates if a column contains nonexistent (or missing) values.
Read	Advances a data reader to the next record and reads that record.