SqlDataReader Methods

SqlDataReader Methods

 

Namespace:   System.Data.SqlClient
Assembly:  System.Data (in System.Data.dll)

NameDescription
System_CAPS_pubmethodClose()

Closes the SqlDataReader object.(Overrides DbDataReader.Close().)

System_CAPS_pubmethodCreateObjRef(Type)

Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object.(Inherited from MarshalByRefObject.)

System_CAPS_pubmethodDispose()

Releases all resources used by the current instance of the DbDataReader class.(Inherited from DbDataReader.)

System_CAPS_protmethodDispose(Boolean)

Releases the managed resources used by the DbDataReader and optionally releases the unmanaged resources.(Inherited from DbDataReader.)

System_CAPS_pubmethodEquals(Object)

Determines whether the specified object is equal to the current object.(Inherited from Object.)

System_CAPS_protmethodFinalize()

Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.(Inherited from Object.)

System_CAPS_pubmethodGetBoolean(Int32)

Gets the value of the specified column as a Boolean.(Overrides DbDataReader.GetBoolean(Int32).)

System_CAPS_pubmethodGetByte(Int32)

Gets the value of the specified column as a byte.(Overrides DbDataReader.GetByte(Int32).)

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

Reads a stream of bytes from the specified column offset into the buffer an array starting at the given buffer offset.(Overrides DbDataReader.GetBytes(Int32, Int64, Byte[], Int32, Int32).)

System_CAPS_pubmethodGetChar(Int32)

Gets the value of the specified column as a single character.(Overrides DbDataReader.GetChar(Int32).)

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

Reads a stream of characters from the specified column offset into the buffer as an array starting at the given buffer offset.(Overrides DbDataReader.GetChars(Int32, Int64, Char[], Int32, Int32).)

System_CAPS_pubmethodGetData(Int32)

Returns a DbDataReader object for the requested column ordinal.(Inherited from DbDataReader.)

System_CAPS_pubmethodGetDataTypeName(Int32)

Gets a string representing the data type of the specified column.(Overrides DbDataReader.GetDataTypeName(Int32).)

System_CAPS_pubmethodGetDateTime(Int32)

Gets the value of the specified column as a DateTime object.(Overrides DbDataReader.GetDateTime(Int32).)

System_CAPS_pubmethodGetDateTimeOffset(Int32)

Retrieves the value of the specified column as a DateTimeOffset object.

System_CAPS_protmethodGetDbDataReader(Int32)

Returns a DbDataReader object for the requested column ordinal that can be overridden with a provider-specific implementation.(Inherited from DbDataReader.)

System_CAPS_pubmethodGetDecimal(Int32)

Gets the value of the specified column as a Decimal object.(Overrides DbDataReader.GetDecimal(Int32).)

System_CAPS_pubmethodGetDouble(Int32)

Gets the value of the specified column as a double-precision floating point number.(Overrides DbDataReader.GetDouble(Int32).)

System_CAPS_pubmethodGetEnumerator()

Returns an IEnumerator that iterates through the SqlDataReader.(Overrides DbDataReader.GetEnumerator().)

System_CAPS_pubmethodGetFieldType(Int32)

Gets the Type that is the data type of the object.(Overrides DbDataReader.GetFieldType(Int32).)

System_CAPS_pubmethodGetFieldValue<T>(Int32)

Synchronously gets the value of the specified column as a type. GetFieldValueAsync<T> is the asynchronous version of this method.(Overrides DbDataReader.GetFieldValue<T>(Int32).)

System_CAPS_pubmethodGetFieldValueAsync<T>(Int32)

Asynchronously gets the value of the specified column as a type.(Inherited from DbDataReader.)

System_CAPS_pubmethodGetFieldValueAsync<T>(Int32, CancellationToken)

Asynchronously gets the value of the specified column as a type. GetFieldValue<T> is the synchronous version of this method.(Overrides DbDataReader.GetFieldValueAsync<T>(Int32, CancellationToken).)

System_CAPS_pubmethodGetFloat(Int32)

Gets the value of the specified column as a single-precision floating point number.(Overrides DbDataReader.GetFloat(Int32).)

System_CAPS_pubmethodGetGuid(Int32)

Gets the value of the specified column as a globally unique identifier (GUID).(Overrides DbDataReader.GetGuid(Int32).)

System_CAPS_pubmethodGetHashCode()

Serves as the default hash function. (Inherited from Object.)

System_CAPS_pubmethodGetInt16(Int32)

Gets the value of the specified column as a 16-bit signed integer.(Overrides DbDataReader.GetInt16(Int32).)

System_CAPS_pubmethodGetInt32(Int32)

Gets the value of the specified column as a 32-bit signed integer.(Overrides DbDataReader.GetInt32(Int32).)

System_CAPS_pubmethodGetInt64(Int32)

Gets the value of the specified column as a 64-bit signed integer.(Overrides DbDataReader.GetInt64(Int32).)

System_CAPS_pubmethodGetLifetimeService()

Retrieves the current lifetime service object that controls the lifetime policy for this instance.(Inherited from MarshalByRefObject.)

System_CAPS_pubmethodGetName(Int32)

Gets the name of the specified column.(Overrides DbDataReader.GetName(Int32).)

System_CAPS_pubmethodGetOrdinal(String)

Gets the column ordinal, given the name of the column.(Overrides DbDataReader.GetOrdinal(String).)

System_CAPS_pubmethodGetProviderSpecificFieldType(Int32)

Gets an Object that is a representation of the underlying provider-specific field type.(Overrides DbDataReader.GetProviderSpecificFieldType(Int32).)

System_CAPS_pubmethodGetProviderSpecificValue(Int32)

Gets an Object that is a representation of the underlying provider specific value.(Overrides DbDataReader.GetProviderSpecificValue(Int32).)

System_CAPS_pubmethodGetProviderSpecificValues(Object[])

Gets an array of objects that are a representation of the underlying provider specific values.(Overrides DbDataReader.GetProviderSpecificValues(Object[]).)

System_CAPS_pubmethodGetSchemaTable()

Returns a DataTable that describes the column metadata of the SqlDataReader.(Overrides DbDataReader.GetSchemaTable().)

System_CAPS_pubmethodGetSqlBinary(Int32)

Gets the value of the specified column as a SqlBinary.

System_CAPS_pubmethodGetSqlBoolean(Int32)

Gets the value of the specified column as a SqlBoolean.

System_CAPS_pubmethodGetSqlByte(Int32)

Gets the value of the specified column as a SqlByte.

System_CAPS_pubmethodGetSqlBytes(Int32)

Gets the value of the specified column as SqlBytes.

System_CAPS_pubmethodGetSqlChars(Int32)

Gets the value of the specified column as SqlChars.

System_CAPS_pubmethodGetSqlDateTime(Int32)

Gets the value of the specified column as a SqlDateTime.

System_CAPS_pubmethodGetSqlDecimal(Int32)

Gets the value of the specified column as a SqlDecimal.

System_CAPS_pubmethodGetSqlDouble(Int32)

Gets the value of the specified column as a SqlDouble.

System_CAPS_pubmethodGetSqlGuid(Int32)

Gets the value of the specified column as a SqlGuid.

System_CAPS_pubmethodGetSqlInt16(Int32)

Gets the value of the specified column as a SqlInt16.

System_CAPS_pubmethodGetSqlInt32(Int32)

Gets the value of the specified column as a SqlInt32.

System_CAPS_pubmethodGetSqlInt64(Int32)

Gets the value of the specified column as a SqlInt64.

System_CAPS_pubmethodGetSqlMoney(Int32)

Gets the value of the specified column as a SqlMoney.

System_CAPS_pubmethodGetSqlSingle(Int32)

Gets the value of the specified column as a SqlSingle.

System_CAPS_pubmethodGetSqlString(Int32)

Gets the value of the specified column as a SqlString.

System_CAPS_pubmethodGetSqlValue(Int32)

Returns the data value in the specified column as a SQL Server type.

System_CAPS_pubmethodGetSqlValues(Object[])

Fills an array of Object that contains the values for all the columns in the record, expressed as SQL Server types.

System_CAPS_pubmethodGetSqlXml(Int32)

Gets the value of the specified column as an XML value.

System_CAPS_pubmethodGetStream(Int32)

Retrieves binary, image, varbinary, UDT, and variant data types as a Stream.(Overrides DbDataReader.GetStream(Int32).)

System_CAPS_pubmethodGetString(Int32)

Gets the value of the specified column as a string.(Overrides DbDataReader.GetString(Int32).)

System_CAPS_pubmethodGetTextReader(Int32)

Retrieves Char, NChar, NText, NVarChar, text, varChar, and Variant data types as a TextReader.(Overrides DbDataReader.GetTextReader(Int32).)

System_CAPS_pubmethodGetTimeSpan(Int32)

Retrieves the value of the specified column as a TimeSpan object.

System_CAPS_pubmethodGetType()

Gets the Type of the current instance.(Inherited from Object.)

System_CAPS_pubmethodGetValue(Int32)

Gets the value of the specified column in its native format.(Overrides DbDataReader.GetValue(Int32).)

System_CAPS_pubmethodGetValues(Object[])

Populates an array of objects with the column values of the current row.(Overrides DbDataReader.GetValues(Object[]).)

System_CAPS_pubmethodGetXmlReader(Int32)

Retrieves data of type XML as an XmlReader.

System_CAPS_pubmethodInitializeLifetimeService()

Obtains a lifetime service object to control the lifetime policy for this instance.(Inherited from MarshalByRefObject.)

System_CAPS_protmethodIsCommandBehavior(CommandBehavior)

Determines whether the specified CommandBehavior matches that of the SqlDataReader .

System_CAPS_pubmethodIsDBNull(Int32)

Gets a value that indicates whether the column contains non-existent or missing values.(Overrides DbDataReader.IsDBNull(Int32).)

System_CAPS_pubmethodIsDBNullAsync(Int32)

An asynchronous version of IsDBNull, which gets a value that indicates whether the column contains non-existent or missing values.(Inherited from DbDataReader.)

System_CAPS_pubmethodIsDBNullAsync(Int32, CancellationToken)

An asynchronous version of IsDBNull, which gets a value that indicates whether the column contains non-existent or missing values.

The cancellation token can be used to request that the operation be abandoned before the command timeout elapses. Exceptions will be reported via the returned Task object.(Overrides DbDataReader.IsDBNullAsync(Int32, CancellationToken).)

System_CAPS_protmethodMemberwiseClone()

Creates a shallow copy of the current Object.(Inherited from Object.)

System_CAPS_protmethodMemberwiseClone(Boolean)

Creates a shallow copy of the current MarshalByRefObject object.(Inherited from MarshalByRefObject.)

System_CAPS_pubmethodNextResult()

Advances the data reader to the next result, when reading the results of batch Transact-SQL statements.(Overrides DbDataReader.NextResult().)

System_CAPS_pubmethodNextResultAsync()

An asynchronous version of NextResult, which advances the reader to the next result when reading the results of a batch of statements.

Invokes NextResultAsync with CancellationToken.None.(Inherited from DbDataReader.)

System_CAPS_pubmethodNextResultAsync(CancellationToken)

An asynchronous version of NextResult, which advances the data reader to the next result, when reading the results of batch Transact-SQL statements.

The cancellation token can be used to request that the operation be abandoned before the command timeout elapses. Exceptions will be reported via the returned Task object.(Overrides DbDataReader.NextResultAsync(CancellationToken).)

System_CAPS_pubmethodRead()

Advances the SqlDataReader to the next record.(Overrides DbDataReader.Read().)

System_CAPS_pubmethodReadAsync()

An asynchronous version of Read, which advances the reader to the next record in a result set. This method invokes ReadAsync with CancellationToken.None.(Inherited from DbDataReader.)

System_CAPS_pubmethodReadAsync(CancellationToken)

An asynchronous version of Read, which advances the SqlDataReader to the next record.

The cancellation token can be used to request that the operation be abandoned before the command timeout elapses. Exceptions will be reported via the returned Task object.(Overrides DbDataReader.ReadAsync(CancellationToken).)

System_CAPS_pubmethodToString()

Returns a string that represents the current object.(Inherited from Object.)

NameDescription
System_CAPS_pubmethodAsParallel()

Overloaded. Enables parallelization of a query.(Defined by ParallelEnumerable.)

System_CAPS_pubmethodAsQueryable()

Overloaded. Converts an IEnumerable to an IQueryable.(Defined by Queryable.)

System_CAPS_pubmethodCast<TResult>()

Casts the elements of an IEnumerable to the specified type.(Defined by Enumerable.)

System_CAPS_pubmethodOfType<TResult>()

Filters the elements of an IEnumerable based on a specified type.(Defined by Enumerable.)

NameDescription
System_CAPS_pubinterfaceSystem_CAPS_privmethodIDataRecord.GetData(Int32)

Returns an IDataReader for the specified column ordinal.

Return to top
Show:
© 2016 Microsoft