OdbcDataReader Class
Provides a way of reading a forward-only stream of data rows from a data source. This class cannot be inherited.
System::MarshalByRefObject
System.Data.Common::DbDataReader
System.Data.Odbc::OdbcDataReader
Assembly: System.Data (in System.Data.dll)
The OdbcDataReader type exposes the following members.
| Name | Description | |
|---|---|---|
![]() | Depth | Gets a value that indicates the depth of nesting for the current row. (Overrides DbDataReader::Depth.) |
![]() | FieldCount | Gets the number of columns in the current row. (Overrides DbDataReader::FieldCount.) |
![]() | HasRows | Gets a value that indicates whether the OdbcDataReader contains one or more rows. (Overrides DbDataReader::HasRows.) |
![]() | IsClosed | Indicates whether the OdbcDataReader is closed. (Overrides DbDataReader::IsClosed.) |
![]() | Item[Int32] | Gets the value of the specified column in its native format given the column ordinal. (Overrides DbDataReader::Item[Int32].) |
![]() | Item[String] | Gets the value of the specified column in its native format given the column name. (Overrides DbDataReader::Item[String].) |
![]() | RecordsAffected | Gets the number of rows changed, inserted, or deleted by execution of the SQL statement. (Overrides DbDataReader::RecordsAffected.) |
![]() | VisibleFieldCount | Gets the number of fields in the DbDataReader that are not hidden. (Inherited from DbDataReader.) |
| Name | Description | |
|---|---|---|
![]() | Close | Closes the OdbcDataReader object. (Overrides DbDataReader::Close().) |
![]() | CreateObjRef | Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object. (Inherited from MarshalByRefObject.) |
![]() | Dispose() | Releases all resources used by the current instance of the DbDataReader class. (Inherited from DbDataReader.) |
![]() | Dispose(Boolean) | Releases the managed resources used by the DbDataReader and optionally releases the unmanaged resources. (Inherited from DbDataReader.) |
![]() | Equals(Object) | Determines whether the specified Object is equal to the current Object. (Inherited from Object.) |
![]() | Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.) |
![]() | GetBoolean | Gets the value of the specified column as a Boolean. (Overrides DbDataReader::GetBoolean(Int32).) |
![]() | GetByte | Gets the value of the specified column as a byte. (Overrides DbDataReader::GetByte(Int32).) |
![]() | GetBytes | Reads a stream of bytes from the specified column offset into the buffer as an array, starting at the particular buffer offset. (Overrides DbDataReader::GetBytes(Int32, Int64, array<Byte>, Int32, Int32).) |
![]() | GetChar | Gets the value of the specified column as a character. (Overrides DbDataReader::GetChar(Int32).) |
![]() | GetChars | Reads a stream of characters from the specified column offset into the buffer as an array, starting at the particular buffer offset. (Overrides DbDataReader::GetChars(Int32, Int64, array<Char>, Int32, Int32).) |
![]() | GetData | Returns a DbDataReader object for the requested column ordinal. (Inherited from DbDataReader.) |
![]() | GetDataTypeName | Gets the name of the source data type. (Overrides DbDataReader::GetDataTypeName(Int32).) |
![]() | GetDate | Gets the value of the specified column as a DateTime object. |
![]() | GetDateTime | Gets the value of the specified column as a DateTime object. (Overrides DbDataReader::GetDateTime(Int32).) |
![]() | GetDbDataReader | Returns a DbDataReader object for the requested column ordinal that can be overridden with a provider-specific implementation. (Inherited from DbDataReader.) |
![]() | GetDecimal | Gets the value of the specified column as a Decimal object. (Overrides DbDataReader::GetDecimal(Int32).) |
![]() | GetDouble | Gets the value of the specified column as a double-precision floating-point number. (Overrides DbDataReader::GetDouble(Int32).) |
![]() | GetEnumerator | Returns an IEnumerator that can be used to iterate through the rows in the data reader. (Overrides DbDataReader::GetEnumerator().) |
![]() | GetFieldType | Gets the Type that is the data type of the object. (Overrides DbDataReader::GetFieldType(Int32).) |
![]() | GetFloat | Gets the value of the specified column as a single-precision floating-point number. (Overrides DbDataReader::GetFloat(Int32).) |
![]() | GetGuid | Gets the value of the specified column as a globally unique identifier (GUID). (Overrides DbDataReader::GetGuid(Int32).) |
![]() | GetHashCode | Serves as a hash function for a particular type. (Inherited from Object.) |
![]() | GetInt16 | Gets the value of the specified column as a 16-bit signed integer. (Overrides DbDataReader::GetInt16(Int32).) |
![]() | GetInt32 | Gets the value of the specified column as a 32-bit signed integer. (Overrides DbDataReader::GetInt32(Int32).) |
![]() | GetInt64 | Gets the value of the specified column as a 64-bit signed integer. (Overrides DbDataReader::GetInt64(Int32).) |
![]() | GetLifetimeService | Retrieves the current lifetime service object that controls the lifetime policy for this instance. (Inherited from MarshalByRefObject.) |
![]() | GetName | Gets the name of the specified column. (Overrides DbDataReader::GetName(Int32).) |
![]() | GetOrdinal | Gets the column ordinal, given the name of the column. (Overrides DbDataReader::GetOrdinal(String).) |
![]() | GetProviderSpecificFieldType | Returns the provider-specific field type of the specified column. (Inherited from DbDataReader.) |
![]() | GetProviderSpecificValue | Gets the value of the specified column as an instance of Object. (Inherited from DbDataReader.) |
![]() | GetProviderSpecificValues | Gets all provider-specific attribute columns in the collection for the current row. (Inherited from DbDataReader.) |
![]() | GetSchemaTable | Returns a DataTable that describes the column metadata of the OdbcDataReader. (Overrides DbDataReader::GetSchemaTable().) |
![]() | GetString | Gets the value of the specified column as a String. (Overrides DbDataReader::GetString(Int32).) |
![]() | GetTime | Gets the value of the specified column as a TimeSpan object. |
![]() | GetType | Gets the Type of the current instance. (Inherited from Object.) |
![]() | GetValue | Gets the value of the column at the specified ordinal in its native format. (Overrides DbDataReader::GetValue(Int32).) |
![]() | GetValues | Populates an array of objects with the column values of the current row. (Overrides DbDataReader::GetValues(array<Object>).) |
![]() | InitializeLifetimeService | Obtains a lifetime service object to control the lifetime policy for this instance. (Inherited from MarshalByRefObject.) |
![]() | IsDBNull | Gets a value that indicates whether the column contains nonexistent or missing values. (Overrides DbDataReader::IsDBNull(Int32).) |
![]() | MemberwiseClone() | Creates a shallow copy of the current Object. (Inherited from Object.) |
![]() | MemberwiseClone(Boolean) | Creates a shallow copy of the current MarshalByRefObject object. (Inherited from MarshalByRefObject.) |
![]() | NextResult | Advances the OdbcDataReader to the next result when reading the results of batch SQL statements. (Overrides DbDataReader::NextResult().) |
![]() | Read | Advances the OdbcDataReader to the next record. (Overrides DbDataReader::Read().) |
![]() | ToString | Returns a string that represents the current object. (Inherited from Object.) |
| Name | Description | |
|---|---|---|
![]() ![]() | IDataRecord::GetData | For a description of this member, see IDataRecord::GetData. (Inherited from DbDataReader.) |
To create an OdbcDataReader, you must call the ExecuteReader method of the OdbcCommand object, instead of directly using a constructor.
While the OdbcDataReader is being used, the associated OdbcConnection is busy serving the OdbcDataReader, and no other operations can be performed on the OdbcConnection other than closing it. This is the case until the Close method of the OdbcDataReader is called. For example, you cannot retrieve output parameters until after you call Close.
Changes made to a result set by another process or thread while data is being read may be visible to the user of the OdbcDataReader. However, the precise behavior is both driver and timing dependent.
IsClosed and RecordsAffected are the only properties that you can call after the OdbcDataReader is closed. Sometimes, you must call Close before you can call RecordsAffected.
The following example creates an OdbcConnection, an OdbcCommand, and an OdbcDataReader. The example reads through the data, writing it out to the console. Finally, the example closes the OdbcDataReader, and then the OdbcConnection.
Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows XP SP2 x64 Edition, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.
