| Name | Description | |
|---|---|---|
 | Depth | Overridden. Gets a value that indicates the depth of nesting for the current row. |
| EndOfData | Overridden. Indicates whether the SqlDataReader has been read completely. |
| FieldCount | Overridden. Gets the number of columns in the current row. |
| HasRows | Overridden. Gets a value indicating whether the SqlDataReader contains one or more rows. |
| IsClosed | Overridden. Gets a value that indicates whether the SqlDataReader instance has been closed. |
| Item | Overloaded. Gets the value of the specified column in its native format given the column name. (Inherited from Devart.Common.DbDataReaderBase) |
| RecordsAffected | Overridden. Gets the number of rows changed, inserted, or deleted by execution of the SQL statement. |
| VisibleFieldCount | Overridden. |
SqlDataReader Class Members
In This Topic
The following tables list the members exposed by SqlDataReader.
Public Properties
Public Methods
| Name | Description | |
|---|---|---|
 | Close | Overridden. Closes the SqlDataReader object. |
| CreateObjRef | Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object. (Inherited from System.MarshalByRefObject) |
| GetBoolean | Overloaded. Overridden. Gets the value of the specified column as a Boolean. |
| GetByte | Overloaded. Overridden. Gets the value of the specified column as a byte. |
| GetBytes | Overloaded. Overridden. Reads a stream of bytes from the specified column offset into the buffer as an array starting at the given buffer offset. |
| GetChar | Overloaded. Overridden. Gets the value of the specified column as a single character. |
| GetChars | Overloaded. Overridden. Reads a stream of characters from the specified column offset into the buffer as an array starting at the given buffer offset. |
| GetData | Returns a SqlDataReader object for the requested column ordinal. |
| GetDataTypeName | Overloaded. Overridden. Gets the name of the source data type. |
| GetDateTime | Overloaded. Overridden. Gets the value of the specified column as a System.DateTime object. |
| GetDateTimeOffset | Overloaded. Overridden. Gets the value of the specified column as an System.DateTimeOffset object. |
| GetDecimal | Overloaded. Overridden. Gets the value of the specified column as a System.Decimal object. |
| GetDouble | Overloaded. Overridden. Gets the value of the specified column as a double-precision floating point number. |
| GetFieldType | Overloaded. Overridden. Gets the System.Type that is the data type of the object. |
| GetFloat | Overloaded. Overridden. Gets the value of the specified column as a single-precision floating point number. |
| GetGuid | Overloaded. Overridden. Gets the value of the specified column as a globally-unique identifier (GUID). |
| GetInt16 | Overloaded. Overridden. Gets the value of the specified column as a 16-bit signed integer. |
| GetInt32 | Overloaded. Overridden. Gets the value of the specified column as a 32-bit signed integer. |
| GetInt64 | Overloaded. Overridden. Gets the value of the specified column as a 64-bit signed integer. |
| GetLifetimeService | Retrieves the current lifetime service object that controls the lifetime policy for this instance. (Inherited from System.MarshalByRefObject) |
| GetName | Overridden. Gets the name of the specified column. |
| GetOrdinal | Overridden. Gets the column ordinal, given the name of the column. |
| GetProviderSpecificFieldType | Overloaded. Overridden. Gets the System.Type that is the provider-specific data type of the object. |
| GetProviderSpecificValue | Overloaded. Overridden. Gets the value of the specified column. If possible, a provider-specific type is used. |
| GetProviderSpecificValues | Overridden. Gets all column values for the current row. If possible, a provider-specific type is used. |
| GetSchemaTable | Returns a System.Data.DataTable that describes the column metadata of the Devart.Common.DbDataReaderBase. (Inherited from Devart.Common.DbDataReaderBase) |
| GetSqlBinary | Overloaded. Gets the value of the specified column as a Devart.Data.SqlServer.SqlTypes.SqlBinary object. |
| GetSqlBoolean | Overloaded. Gets the value of the specified column as a Devart.Data.SqlServer.SqlTypes.SqlBoolean object. |
| GetSqlByte | Overloaded. Gets the value of the specified column as a Devart.Data.SqlServer.SqlTypes.SqlByte object. |
| GetSqlBytes | Overloaded. Gets the value of the specified column as a Devart.Data.SqlServer.SqlTypes.SqlBytes object. |
| GetSqlChars | Overloaded. Gets the value of the specified column as a Devart.Data.SqlServer.SqlTypes.SqlChars object. |
| GetSqlDateTime | Overloaded. Gets the value of the specified column as a Devart.Data.SqlServer.SqlTypes.SqlDateTime object. |
| GetSqlDecimal | Overloaded. Gets the value of the specified column as a Devart.Data.SqlServer.SqlTypes.SqlDecimal object. |
| GetSqlDouble | Overloaded. Gets the value of the specified column as a Devart.Data.SqlServer.SqlTypes.SqlDouble object. |
| GetSqlGuid | Overloaded. Gets the value of the specified column as a Devart.Data.SqlServer.SqlTypes.SqlGuid object. |
| GetSqlInt16 | Overloaded. Gets the value of the specified column as a Devart.Data.SqlServer.SqlTypes.SqlInt16 object. |
| GetSqlInt32 | Overloaded. Gets the value of the specified column as a Devart.Data.SqlServer.SqlTypes.SqlInt32 object. |
| GetSqlInt64 | Overloaded. Gets the value of the specified column as a Devart.Data.SqlServer.SqlTypes.SqlInt64 object. |
| GetSqlMoney | Overloaded. Gets the value of the specified column as a Devart.Data.SqlServer.SqlTypes.SqlMoney object. |
| GetSqlSingle | Overloaded. Gets the value of the specified column as a Devart.Data.SqlServer.SqlTypes.SqlSingle object. |
| GetSqlString | Overloaded. Gets the value of the specified column as a Devart.Data.SqlServer.SqlTypes.SqlString object. |
| GetSqlValue | Overloaded. Gets the value of the specified column. If possible, a provider-specific type is used. |
| GetSqlValues | Gets all columns in the collection for the current row. If possible, a provider-specific type is used. |
| GetSqlXml | Overloaded. Gets the value of the specified column as a Devart.Data.SqlServer.SqlTypes.SqlXml object. |
| GetString | Overloaded. Overridden. Gets the value of the specified column as a string. |
| GetTimeSpan | Overloaded. Gets the value of the specified column as a System.TimeSpan. |
| GetValue | Overloaded. Overridden. Gets the value of the specified column in its native format. |
| GetValues | Overridden. Gets all column values for the current row. |
| InitializeLifetimeService | Obtains a lifetime service object to control the lifetime policy for this instance. (Inherited from System.MarshalByRefObject) |
| IsDBNull | Overloaded. Overridden. Gets a value indicating whether the column contains non-existent or missing values. |
| NextResult | Overridden. Advances the data reader to the next result, when reading the results of batch SQL statements. |
| Read | Overridden. Advances the SqlDataReader to the next record. |
See Also