Export (0) Print
Expand All

SqlDataReader Members

SqlDataReader overview

Public Properties

public propertyDepth

Supported by the .NET Compact Framework.

Gets a value indicating the depth of nesting for the current row.
public propertyFieldCount

Supported by the .NET Compact Framework.

Gets the number of columns in the current row.
public propertyHasRows Gets a value indicating whether the SqlDataReader contains one or more rows.
public propertyIsClosed

Supported by the .NET Compact Framework.

Gets a value indicating whether the data reader is closed.
public propertyItem Overloaded. Gets the value of a column in its native format.

In C#, this property is the indexer for the SqlDataReader class.

public propertyRecordsAffected

Supported by the .NET Compact Framework.

Gets the number of rows changed, inserted, or deleted by execution of the Transact-SQL statement.

Public Methods

public methodClose

Supported by the .NET Compact Framework.

Closes the SqlDataReader object.
public methodCreateObjRef (inherited from MarshalByRefObject) Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object.
public methodEquals (inherited from Object)

Supported by the .NET Compact Framework.

Overloaded. Determines whether two Object instances are equal.
public methodGetBoolean

Supported by the .NET Compact Framework.

Gets the value of the specified column as a Boolean.
public methodGetByte

Supported by the .NET Compact Framework.

Gets the value of the specified column as a byte.
public methodGetBytes

Supported by the .NET Compact Framework.

Reads a stream of bytes from the specified column offset into the buffer an array starting at the given buffer offset.
public methodGetChar

Supported by the .NET Compact Framework.

Gets the value of the specified column as a single character.
public methodGetChars

Supported by the .NET Compact Framework.

Reads a stream of characters from the specified column offset into the buffer as an array starting at the given buffer offset.
public methodGetDataTypeName

Supported by the .NET Compact Framework.

Gets the name of the source data type.
public methodGetDateTime

Supported by the .NET Compact Framework.

Gets the value of the specified column as a DateTime object.
public methodGetDecimal

Supported by the .NET Compact Framework.

Gets the value of the specified column as a Decimal object.
public methodGetDouble

Supported by the .NET Compact Framework.

Gets the value of the specified column as a double-precision floating point number.
public methodGetFieldType

Supported by the .NET Compact Framework.

Gets the Type that is the data type of the object.
public methodGetFloat

Supported by the .NET Compact Framework.

Gets the value of the specified column as a single-precision floating point number.
public methodGetGuid

Supported by the .NET Compact Framework.

Gets the value of the specified column as a globally-unique identifier (GUID).
public methodGetHashCode (inherited from Object)

Supported by the .NET Compact Framework.

Serves as a hash function for a particular type, suitable for use in hashing algorithms and data structures like a hash table.
public methodGetInt16

Supported by the .NET Compact Framework.

Gets the value of the specified column as a 16-bit signed integer.
public methodGetInt32

Supported by the .NET Compact Framework.

Gets the value of the specified column as a 32-bit signed integer.
public methodGetInt64

Supported by the .NET Compact Framework.

Gets the value of the specified column as a 64-bit signed integer.
public methodGetLifetimeService (inherited from MarshalByRefObject) Retrieves the current lifetime service object that controls the lifetime policy for this instance.
public methodGetName

Supported by the .NET Compact Framework.

Gets the name of the specified column.
public methodGetOrdinal

Supported by the .NET Compact Framework.

Gets the column ordinal, given the name of the column.
public methodGetSchemaTable

Supported by the .NET Compact Framework.

Returns a DataTable that describes the column metadata of the SqlDataReader.
public methodGetSqlBinary

Supported by the .NET Compact Framework.

Gets the value of the specified column as a SqlBinary.
public methodGetSqlBoolean

Supported by the .NET Compact Framework.

Gets the value of the specified column as a SqlBoolean.
public methodGetSqlByte

Supported by the .NET Compact Framework.

Gets the value of the specified column as a SqlByte.
public methodGetSqlDateTime

Supported by the .NET Compact Framework.

Gets the value of the specified column as a SqlDateTime.
public methodGetSqlDecimal

Supported by the .NET Compact Framework.

Gets the value of the specified column as a SqlDecimal.
public methodGetSqlDouble

Supported by the .NET Compact Framework.

Gets the value of the specified column as a SqlDouble.
public methodGetSqlGuid

Supported by the .NET Compact Framework.

Gets the value of the specified column as a SqlGuid.
public methodGetSqlInt16

Supported by the .NET Compact Framework.

Gets the value of the specified column as a SqlInt16.
public methodGetSqlInt32

Supported by the .NET Compact Framework.

Gets the value of the specified column as a SqlInt32.
public methodGetSqlInt64

Supported by the .NET Compact Framework.

Gets the value of the specified column as a SqlInt64.
public methodGetSqlMoney

Supported by the .NET Compact Framework.

Gets the value of the specified column as a SqlMoney.
public methodGetSqlSingle

Supported by the .NET Compact Framework.

Gets the value of the specified column as a SqlSingle.
public methodGetSqlString

Supported by the .NET Compact Framework.

Gets the value of the specified column as a SqlString.
public methodGetSqlValue

Supported by the .NET Compact Framework.

Gets an Object that is a representation of the underlying SqlDbType Variant.
public methodGetSqlValues

Supported by the .NET Compact Framework.

Gets all the attribute columns in the current row.
public methodGetString

Supported by the .NET Compact Framework.

Gets the value of the specified column as a string.
public methodGetType (inherited from Object)

Supported by the .NET Compact Framework.

Gets the Type of the current instance.
public methodGetValue

Supported by the .NET Compact Framework.

Gets the value of the specified column in its native format.
public methodGetValues

Supported by the .NET Compact Framework.

Gets all attribute columns in the collection for the current row.
public methodInitializeLifetimeService (inherited from MarshalByRefObject) Obtains a lifetime service object to control the lifetime policy for this instance.
public methodIsDBNull

Supported by the .NET Compact Framework.

Gets a value indicating whether the column contains non-existent or missing values.
public methodNextResult

Supported by the .NET Compact Framework.

Advances the data reader to the next result, when reading the results of batch Transact-SQL statements.
public methodRead

Supported by the .NET Compact Framework.

Advances the SqlDataReader to the next record.
public methodToString (inherited from Object)

Supported by the .NET Compact Framework.

Returns a String that represents the current Object.

Protected Methods

protected methodFinalize (inherited from Object)

Supported by the .NET Compact Framework.

Overridden. Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection.

In C# and C++, finalizers are expressed using destructor syntax.

protected methodMemberwiseClone (inherited from Object)

Supported by the .NET Compact Framework.

Creates a shallow copy of the current Object.

Explicit Interface Implementations

IEnumerable.GetEnumerator This member supports the .NET Framework infrastructure and is not intended to be used directly from your code.

See Also

SqlDataReader Class | System.Data.SqlClient Namespace

Show:
© 2014 Microsoft