Upgrade your Internet Experience
Microsoft.com
Welcome Sign in
.NET Framework Developer Center
Click to Rate and Give Feedback
MSDN
MSDN Library
.NET Development
Previous Versions
.NET Framework 2.0
SqlDataReader Class
 SqlDataReader Members

  Switch on low bandwidth view
This page is specific to
Microsoft Visual Studio 2005/.NET Framework 2.0

Other versions are also available for the following:
.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 following tables list the members exposed by the SqlDataReader type.

(see also Protected Properties )
  Name Description
Public property Supported by the .NET Compact Framework Depth Overridden. Gets a value that indicates the depth of nesting for the current row.
Public property Supported by the .NET Compact Framework FieldCount Overridden. Gets the number of columns in the current row.
Public property HasRows Overridden. Gets a value that indicates whether the SqlDataReader contains one or more rows.
Public property Supported by the .NET Compact Framework IsClosed Overridden. Retrieves a Boolean value that indicates whether the specified SqlDataReader instance has been closed.
Public property Supported by the .NET Compact Framework Item Overloaded. Overridden. Gets the value of a column in its native format.
Public property Supported by the .NET Compact Framework RecordsAffected Overridden. Gets the number of rows changed, inserted, or deleted by execution of the Transact-SQL statement.
Public property VisibleFieldCount Overridden. Gets the number of fields in the SqlDataReader that are not hidden.
Top
  Name Description
Protected property Connection Gets the SqlConnection associated with the SqlDataReader.
Top
(see also Protected Methods )
  Name Description
Public method Supported by the .NET Compact Framework Close Overridden. Closes the SqlDataReader object.
Public method 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.)
Public method Dispose  Overloaded. Releases the resources used by the DbDataReader. (Inherited from DbDataReader.)
Public method Supported by the .NET Compact Framework Equals  Overloaded. Determines whether two Object instances are equal. (Inherited from Object.)
Public method Supported by the .NET Compact Framework GetBoolean Overridden. Gets the value of the specified column as a Boolean.
Public method Supported by the .NET Compact Framework GetByte Overridden. Gets the value of the specified column as a byte.
Public method Supported by the .NET Compact Framework GetBytes Overridden. Reads a stream of bytes from the specified column offset into the buffer an array starting at the given buffer offset.
Public method Supported by the .NET Compact Framework GetChar Overridden. Gets the value of the specified column as a single character.
Public method Supported by the .NET Compact Framework GetChars Overridden. Reads a stream of characters from the specified column offset into the buffer as an array starting at the given buffer offset.
Public method Supported by the .NET Compact Framework GetData  Returns a DbDataReader object for the requested column ordinal. (Inherited from DbDataReader.)
Public method Supported by the .NET Compact Framework GetDataTypeName Overridden. Gets the name of the source data type.
Public method Supported by the .NET Compact Framework GetDateTime Overridden. Gets the value of the specified column as a DateTime object.
Public method Supported by the .NET Compact Framework GetDecimal Overridden. Gets the value of the specified column as a Decimal object.
Public method Supported by the .NET Compact Framework GetDouble Overridden. Gets the value of the specified column as a double-precision floating point number.
Public method GetEnumerator Overridden. Returns an IEnumerator that iterates through the SqlDataReader.
Public method Supported by the .NET Compact Framework GetFieldType Overridden. Gets the Type that is the data type of the object.
Public method Supported by the .NET Compact Framework GetFloat Overridden. Gets the value of the specified column as a single-precision floating point number.
Public method Supported by the .NET Compact Framework GetGuid Overridden. Gets the value of the specified column as a globally unique identifier (GUID).
Public method Supported by the .NET Compact Framework GetHashCode  Serves as a hash function for a particular type. GetHashCode is suitable for use in hashing algorithms and data structures like a hash table. (Inherited from Object.)
Public method Supported by the .NET Compact Framework GetInt16 Overridden. Gets the value of the specified column as a 16-bit signed integer.
Public method Supported by the .NET Compact Framework GetInt32 Overridden. Gets the value of the specified column as a 32-bit signed integer.
Public method Supported by the .NET Compact Framework GetInt64 Overridden. Gets the value of the specified column as a 64-bit signed integer.
Public method GetLifetimeService  Retrieves the current lifetime service object that controls the lifetime policy for this instance. (Inherited from MarshalByRefObject.)
Public method Supported by the .NET Compact Framework GetName Overridden. Gets the name of the specified column.
Public method Supported by the .NET Compact Framework GetOrdinal Overridden. Gets the column ordinal, given the name of the column.
Public method GetProviderSpecificFieldType Overridden. Gets an Object that is a representation of the underlying provider-specific field type.
Public method GetProviderSpecificValue Overridden. Gets an Object that is a representation of the underlying provider specific value.
Public method GetProviderSpecificValues Overridden. Gets an array of objects that are a representation of the underlying provider specific values.
Public method Supported by the .NET Compact Framework GetSchemaTable Overridden. Returns a DataTable that describes the column metadata of the SqlDataReader.
Public method Supported by the .NET Compact Framework GetSqlBinary Gets the value of the specified column as a SqlBinary.
Public method Supported by the .NET Compact Framework GetSqlBoolean Gets the value of the specified column as a SqlBoolean.
Public method Supported by the .NET Compact Framework GetSqlByte Gets the value of the specified column as a SqlByte.
Public method GetSqlBytes Gets the value of the specified column as SqlBytes.
Public method GetSqlChars Gets the value of the specified column as SqlChars.
Public method Supported by the .NET Compact Framework GetSqlDateTime Gets the value of the specified column as a SqlDateTime.
Public method Supported by the .NET Compact Framework GetSqlDecimal Gets the value of the specified column as a SqlDecimal.
Public method Supported by the .NET Compact Framework GetSqlDouble Gets the value of the specified column as a SqlDouble.
Public method Supported by the .NET Compact Framework GetSqlGuid Gets the value of the specified column as a SqlGuid.
Public method Supported by the .NET Compact Framework GetSqlInt16 Gets the value of the specified column as a SqlInt16.
Public method Supported by the .NET Compact Framework GetSqlInt32 Gets the value of the specified column as a SqlInt32.
Public method Supported by the .NET Compact Framework GetSqlInt64 Gets the value of the specified column as a SqlInt64.
Public method Supported by the .NET Compact Framework GetSqlMoney Gets the value of the specified column as a SqlMoney.
Public method Supported by the .NET Compact Framework GetSqlSingle Gets the value of the specified column as a SqlSingle.
Public method Supported by the .NET Compact Framework GetSqlString Gets the value of the specified column as a SqlString.
Public method Supported by the .NET Compact Framework GetSqlValue Gets an Object that is a representation of the underlying SqlDbType Variant.
Public method Supported by the .NET Compact Framework GetSqlValues Gets all the attribute columns in the current row.
Public method GetSqlXml Gets the value of the specified column as an XML value.
Public method Supported by the .NET Compact Framework GetString Overridden. Gets the value of the specified column as a string.
Public method Supported by the .NET Compact Framework GetType  Gets the Type of the current instance. (Inherited from Object.)
Public method Supported by the .NET Compact Framework GetValue Overridden. Gets the value of the specified column in its native format.
Public method Supported by the .NET Compact Framework GetValues Overridden. Gets all attribute columns in the collection for the current row.
Public method InitializeLifetimeService  Obtains a lifetime service object to control the lifetime policy for this instance. (Inherited from MarshalByRefObject.)
Public method Supported by the .NET Compact Framework IsDBNull Overridden. Gets a value that indicates whether the column contains non-existent or missing values.
Public method Supported by the .NET Compact Framework NextResult Overridden. Advances the data reader to the next result, when reading the results of batch Transact-SQL statements.
Public method Supported by the .NET Compact Framework Read Overridden. Advances the SqlDataReader to the next record.
Public method Static Supported by the .NET Compact Framework ReferenceEquals  Determines whether the specified Object instances are the same instance. (Inherited from Object.)
Public method Supported by the .NET Compact Framework ToString  Returns a String that represents the current Object. (Inherited from Object.)
Top
  Name Description
Protected method Dispose  Overloaded. Releases the resources used by the DbDataReader. (Inherited from DbDataReader.)
Protected method Supported by the .NET Compact Framework Finalize  Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection. (Inherited from Object.)
Protected method GetDbDataReader  Returns a DbDataReader object for the requested column ordinal that can be overridden with a provider-specific implementation. (Inherited from DbDataReader.)
Protected method IsCommandBehavior Determines whether the specified CommandBehavior matches that of the SqlDataReader .
Protected method Supported by the .NET Compact Framework MemberwiseClone  Overloaded. (Inherited from MarshalByRefObject.)
Top
Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
© 2009 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Page view tracker