.NET Framework Class Library
SqlDataReader Members

Provides a way of reading a forward-only stream of rows from a SQL Server database. This class cannot be inherited.

The SqlDataReader type exposes the following members.

Methods
  NameDescription
Public methodSupported by the .NET Compact FrameworkCloseCloses the SqlDataReader object. (Overrides DbDataReader..::.Close()()().)
Public methodCreateObjRefCreates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object. (Inherited from MarshalByRefObject.)
Public methodDisposeOverloaded. Releases the resources used by the DbDataReader and calls Close.
Public methodSupported by the .NET Compact FrameworkEqualsDetermines whether the specified Object is equal to the current Object. (Inherited from Object.)
Protected methodSupported by the .NET Compact FrameworkFinalizeAllows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection. (Inherited from Object.)
Public methodSupported by the .NET Compact FrameworkGetBooleanGets the value of the specified column as a Boolean. (Overrides DbDataReader..::.GetBoolean(Int32).)
Public methodSupported by the .NET Compact FrameworkGetByteGets the value of the specified column as a byte. (Overrides DbDataReader..::.GetByte(Int32).)
Public methodSupported by the .NET Compact FrameworkGetBytesReads 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, array<Byte>[]()[], Int32, Int32).)
Public methodSupported by the .NET Compact FrameworkGetCharGets the value of the specified column as a single character. (Overrides DbDataReader..::.GetChar(Int32).)
Public methodSupported by the .NET Compact FrameworkGetCharsReads 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, array<Char>[]()[], Int32, Int32).)
Public methodSupported by the .NET Compact FrameworkGetDataOverloaded.
Public methodSupported by the .NET Compact FrameworkGetDataTypeNameGets a string representing the data type of the specified column. (Overrides DbDataReader..::.GetDataTypeName(Int32).)
Public methodSupported by the .NET Compact FrameworkGetDateTimeGets the value of the specified column as a DateTime object. (Overrides DbDataReader..::.GetDateTime(Int32).)
Public methodGetDateTimeOffsetRetrieves the value of the specified column as a DateTimeOffset object.
Protected methodGetDbDataReaderReturns a DbDataReader object for the requested column ordinal that can be overridden with a provider-specific implementation. (Inherited from DbDataReader.)
Public methodSupported by the .NET Compact FrameworkGetDecimalGets the value of the specified column as a Decimal object. (Overrides DbDataReader..::.GetDecimal(Int32).)
Public methodSupported by the .NET Compact FrameworkGetDoubleGets the value of the specified column as a double-precision floating point number. (Overrides DbDataReader..::.GetDouble(Int32).)
Public methodGetEnumeratorReturns an IEnumerator that iterates through the SqlDataReader. (Overrides DbDataReader..::.GetEnumerator()()().)
Public methodSupported by the .NET Compact FrameworkGetFieldTypeGets the Type that is the data type of the object. (Overrides DbDataReader..::.GetFieldType(Int32).)
Public methodSupported by the .NET Compact FrameworkGetFloatGets the value of the specified column as a single-precision floating point number. (Overrides DbDataReader..::.GetFloat(Int32).)
Public methodSupported by the .NET Compact FrameworkGetGuidGets the value of the specified column as a globally unique identifier (GUID). (Overrides DbDataReader..::.GetGuid(Int32).)
Public methodSupported by the .NET Compact FrameworkGetHashCodeServes as a hash function for a particular type. (Inherited from Object.)
Public methodSupported by the .NET Compact FrameworkGetInt16Gets the value of the specified column as a 16-bit signed integer. (Overrides DbDataReader..::.GetInt16(Int32).)
Public methodSupported by the .NET Compact FrameworkGetInt32Gets the value of the specified column as a 32-bit signed integer. (Overrides DbDataReader..::.GetInt32(Int32).)
Public methodSupported by the .NET Compact FrameworkGetInt64Gets the value of the specified column as a 64-bit signed integer. (Overrides DbDataReader..::.GetInt64(Int32).)
Public methodGetLifetimeServiceRetrieves the current lifetime service object that controls the lifetime policy for this instance. (Inherited from MarshalByRefObject.)
Public methodSupported by the .NET Compact FrameworkGetNameGets the name of the specified column. (Overrides DbDataReader..::.GetName(Int32).)
Public methodSupported by the .NET Compact FrameworkGetOrdinalGets the column ordinal, given the name of the column. (Overrides DbDataReader..::.GetOrdinal(String).)
Public methodGetProviderSpecificFieldTypeGets an Object that is a representation of the underlying provider-specific field type. (Overrides DbDataReader..::.GetProviderSpecificFieldType(Int32).)
Public methodGetProviderSpecificValueGets an Object that is a representation of the underlying provider specific value. (Overrides DbDataReader..::.GetProviderSpecificValue(Int32).)
Public methodGetProviderSpecificValuesGets an array of objects that are a representation of the underlying provider specific values. (Overrides DbDataReader..::.GetProviderSpecificValues(array<Object>[]()[]).)
Public methodSupported by the .NET Compact FrameworkGetSchemaTableReturns a DataTable that describes the column metadata of the SqlDataReader. (Overrides DbDataReader..::.GetSchemaTable()()().)
Public methodSupported by the .NET Compact FrameworkGetSqlBinaryGets the value of the specified column as a SqlBinary.
Public methodSupported by the .NET Compact FrameworkGetSqlBooleanGets the value of the specified column as a SqlBoolean.
Public methodSupported by the .NET Compact FrameworkGetSqlByteGets the value of the specified column as a SqlByte.
Public methodGetSqlBytesGets the value of the specified column as SqlBytes.
Public methodGetSqlCharsGets the value of the specified column as SqlChars.
Public methodSupported by the .NET Compact FrameworkGetSqlDateTimeGets the value of the specified column as a SqlDateTime.
Public methodSupported by the .NET Compact FrameworkGetSqlDecimalGets the value of the specified column as a SqlDecimal.
Public methodSupported by the .NET Compact FrameworkGetSqlDoubleGets the value of the specified column as a SqlDouble.
Public methodSupported by the .NET Compact FrameworkGetSqlGuidGets the value of the specified column as a SqlGuid.
Public methodSupported by the .NET Compact FrameworkGetSqlInt16Gets the value of the specified column as a SqlInt16.
Public methodSupported by the .NET Compact FrameworkGetSqlInt32Gets the value of the specified column as a SqlInt32.
Public methodSupported by the .NET Compact FrameworkGetSqlInt64Gets the value of the specified column as a SqlInt64.
Public methodSupported by the .NET Compact FrameworkGetSqlMoneyGets the value of the specified column as a SqlMoney.
Public methodSupported by the .NET Compact FrameworkGetSqlSingleGets the value of the specified column as a SqlSingle.
Public methodSupported by the .NET Compact FrameworkGetSqlStringGets the value of the specified column as a SqlString.
Public methodSupported by the .NET Compact FrameworkGetSqlValueReturns the data value in the specified column as a SQL Server type.
Public methodSupported by the .NET Compact FrameworkGetSqlValuesFills an array of Object that contains the values for all the columns in the record, expressed as SQL Server types.
Public methodGetSqlXmlGets the value of the specified column as an XML value.
Public methodSupported by the .NET Compact FrameworkGetStringGets the value of the specified column as a string. (Overrides DbDataReader..::.GetString(Int32).)
Public methodGetTimeSpanRetrieves the value of the specified column as a TimeSpan object.
Public methodSupported by the .NET Compact FrameworkGetTypeGets the Type of the current instance. (Inherited from Object.)
Public methodSupported by the .NET Compact FrameworkGetValueGets the value of the specified column in its native format. (Overrides DbDataReader..::.GetValue(Int32).)
Public methodSupported by the .NET Compact FrameworkGetValuesPopulates an array of objects with the column values of the current row. (Overrides DbDataReader..::.GetValues(array<Object>[]()[]).)
Public methodInitializeLifetimeServiceObtains a lifetime service object to control the lifetime policy for this instance. (Inherited from MarshalByRefObject.)
Protected methodIsCommandBehaviorDetermines whether the specified CommandBehavior matches that of the SqlDataReader .
Public methodSupported by the .NET Compact FrameworkIsDBNullGets a value that indicates whether the column contains non-existent or missing values. (Overrides DbDataReader..::.IsDBNull(Int32).)
Protected methodSupported by the .NET Compact FrameworkMemberwiseCloneOverloaded.
Public methodSupported by the .NET Compact FrameworkNextResultAdvances the data reader to the next result, when reading the results of batch Transact-SQL statements. (Overrides DbDataReader..::.NextResult()()().)
Public methodSupported by the .NET Compact FrameworkReadAdvances the SqlDataReader to the next record. (Overrides DbDataReader..::.Read()()().)
Public methodSupported by the .NET Compact FrameworkToStringReturns a String that represents the current Object. (Inherited from Object.)
Top
Extension Methods
  NameDescription
Public Extension MethodCastConverts the elements of an IEnumerable to the specified type. (Defined by Enumerable.)
Public Extension MethodOfTypeFilters the elements of an IEnumerable based on a specified type. (Defined by Enumerable.)
Top
Properties
  NameDescription
Protected propertyConnectionGets the SqlConnection associated with the SqlDataReader.
Public propertySupported by the .NET Compact FrameworkDepthGets a value that indicates the depth of nesting for the current row. (Overrides DbDataReader..::.Depth.)
Public propertySupported by the .NET Compact FrameworkFieldCountGets the number of columns in the current row. (Overrides DbDataReader..::.FieldCount.)
Public propertyHasRowsGets a value that indicates whether the SqlDataReader contains one or more rows. (Overrides DbDataReader..::.HasRows.)
Public propertySupported by the .NET Compact FrameworkIsClosedRetrieves a Boolean value that indicates whether the specified SqlDataReader instance has been closed. (Overrides DbDataReader..::.IsClosed.)
Public propertySupported by the .NET Compact FrameworkItemOverloaded. Gets the value of a column in its native format.
Public propertySupported by the .NET Compact FrameworkRecordsAffectedGets the number of rows changed, inserted, or deleted by execution of the Transact-SQL statement. (Overrides DbDataReader..::.RecordsAffected.)
Public propertyVisibleFieldCountGets the number of fields in the SqlDataReader that are not hidden. (Overrides DbDataReader..::.VisibleFieldCount.)
Top
Explicit Interface Implementations
  NameDescription
Explicit interface implemetationPrivate methodSupported by the .NET Compact FrameworkIDisposable..::.Dispose
Explicit interface implemetationPrivate methodIDataRecord..::.GetData
Explicit interface implemetationPrivate methodSupported by the .NET Compact FrameworkIEnumerable..::.GetEnumerator
Top
See Also

Reference

SqlDataReader Class
System.Data.SqlClient Namespace
Tags :


Page view tracker