dotConnect for SQL Server Documentation
Devart.Data.SqlServer Namespace / SqlDataReader Class
Properties Methods

In This Topic
    SqlDataReader Class Members
    In This Topic

    The following tables list the members exposed by SqlDataReader.

    Public Properties
     NameDescription
    Public PropertyOverridden. Gets a value that indicates the depth of nesting for the current row.  
    Public PropertyOverridden. Indicates whether the SqlDataReader has been read completely.  
    Public PropertyOverridden. Gets the number of columns in the current row.  
    Public PropertyOverridden. Gets a value indicating whether the SqlDataReader contains one or more rows.  
    Public PropertyOverridden. Gets a value that indicates whether the SqlDataReader instance has been closed.  
    Public PropertyOverloaded. Gets the value of the specified column in its native format given the column name. (Inherited from Devart.Common.DbDataReaderBase)
    Public PropertyOverridden. Gets the number of rows changed, inserted, or deleted by execution of the SQL statement.  
    Public PropertyOverridden.   
    Top
    Public Methods
     NameDescription
    Public MethodOverridden. Closes the SqlDataReader object.  
    Public MethodCreates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object. (Inherited from System.MarshalByRefObject)
    Public MethodOverloaded. Overridden. Gets the value of the specified column as a Boolean.  
    Public MethodOverloaded. Overridden. Gets the value of the specified column as a byte.  
    Public MethodOverloaded. Overridden. Reads a stream of bytes from the specified column offset into the buffer as an array starting at the given buffer offset.  
    Public MethodOverloaded. Overridden. Gets the value of the specified column as a single character.  
    Public MethodOverloaded. Overridden. Reads a stream of characters from the specified column offset into the buffer as an array starting at the given buffer offset.  
    Public MethodReturns a SqlDataReader object for the requested column ordinal.  
    Public MethodOverloaded. Overridden. Gets the name of the source data type.  
    Public MethodOverloaded. Overridden. Gets the value of the specified column as a System.DateTime object.  
    Public MethodOverloaded. Overridden. Gets the value of the specified column as an System.DateTimeOffset object.  
    Public MethodOverloaded. Overridden. Gets the value of the specified column as a System.Decimal object.  
    Public MethodOverloaded. Overridden. Gets the value of the specified column as a double-precision floating point number.  
    Public MethodOverloaded. Overridden. Gets the System.Type that is the data type of the object.  
    Public MethodOverloaded. Overridden. Gets the value of the specified column as a single-precision floating point number.  
    Public MethodOverloaded. Overridden. Gets the value of the specified column as a globally-unique identifier (GUID).  
    Public MethodOverloaded. Overridden. Gets the value of the specified column as a 16-bit signed integer.  
    Public MethodOverloaded. Overridden. Gets the value of the specified column as a 32-bit signed integer.  
    Public MethodOverloaded. Overridden. Gets the value of the specified column as a 64-bit signed integer.  
    Public MethodRetrieves the current lifetime service object that controls the lifetime policy for this instance. (Inherited from System.MarshalByRefObject)
    Public MethodOverridden. Gets the name of the specified column.  
    Public MethodOverridden. Gets the column ordinal, given the name of the column.  
    Public MethodOverloaded. Overridden. Gets the System.Type that is the provider-specific data type of the object.  
    Public MethodOverloaded. Overridden. Gets the value of the specified column. If possible, a provider-specific type is used.  
    Public MethodOverridden. Gets all column values for the current row. If possible, a provider-specific type is used.  
    Public MethodReturns a System.Data.DataTable that describes the column metadata of the Devart.Common.DbDataReaderBase. (Inherited from Devart.Common.DbDataReaderBase)
    Public MethodOverloaded. Gets the value of the specified column as a Devart.Data.SqlServer.SqlTypes.SqlBinary object.  
    Public MethodOverloaded. Gets the value of the specified column as a Devart.Data.SqlServer.SqlTypes.SqlBoolean object.  
    Public MethodOverloaded. Gets the value of the specified column as a Devart.Data.SqlServer.SqlTypes.SqlByte object.  
    Public MethodOverloaded. Gets the value of the specified column as a Devart.Data.SqlServer.SqlTypes.SqlBytes object.  
    Public MethodOverloaded. Gets the value of the specified column as a Devart.Data.SqlServer.SqlTypes.SqlChars object.  
    Public MethodOverloaded. Gets the value of the specified column as a Devart.Data.SqlServer.SqlTypes.SqlDateTime object.  
    Public MethodOverloaded. Gets the value of the specified column as a Devart.Data.SqlServer.SqlTypes.SqlDecimal object.  
    Public MethodOverloaded. Gets the value of the specified column as a Devart.Data.SqlServer.SqlTypes.SqlDouble object.  
    Public MethodOverloaded. Gets the value of the specified column as a Devart.Data.SqlServer.SqlTypes.SqlGuid object.  
    Public MethodOverloaded. Gets the value of the specified column as a Devart.Data.SqlServer.SqlTypes.SqlInt16 object.  
    Public MethodOverloaded. Gets the value of the specified column as a Devart.Data.SqlServer.SqlTypes.SqlInt32 object.  
    Public MethodOverloaded. Gets the value of the specified column as a Devart.Data.SqlServer.SqlTypes.SqlInt64 object.  
    Public MethodOverloaded. Gets the value of the specified column as a Devart.Data.SqlServer.SqlTypes.SqlMoney object.  
    Public MethodOverloaded. Gets the value of the specified column as a Devart.Data.SqlServer.SqlTypes.SqlSingle object.  
    Public MethodOverloaded. Gets the value of the specified column as a Devart.Data.SqlServer.SqlTypes.SqlString object.  
    Public MethodOverloaded. Gets the value of the specified column. If possible, a provider-specific type is used.  
    Public MethodGets all columns in the collection for the current row. If possible, a provider-specific type is used.  
    Public MethodOverloaded. Gets the value of the specified column as a Devart.Data.SqlServer.SqlTypes.SqlXml object.  
    Public MethodOverloaded. Overridden. Gets the value of the specified column as a string.  
    Public MethodOverloaded. Gets the value of the specified column as a System.TimeSpan.  
    Public MethodOverloaded. Overridden. Gets the value of the specified column in its native format.  
    Public MethodOverridden. Gets all column values for the current row.  
    Public MethodObtains a lifetime service object to control the lifetime policy for this instance. (Inherited from System.MarshalByRefObject)
    Public MethodOverloaded. Overridden. Gets a value indicating whether the column contains non-existent or missing values.  
    Public MethodOverridden. Advances the data reader to the next result, when reading the results of batch SQL statements.  
    Public MethodOverridden. Advances the SqlDataReader to the next record.  
    Top
    See Also