共用方式為

SqlCeDataReader Members

  • 發行項

Provides a way of reading a forward-only stream of data rows from a data source. This class cannot be inherited.

The following tables list the members exposed by the SqlCeDataReader type.

Public Properties

  Name Description
Public property Supported by the .NET Compact Framework Depth Overridden. Gets a value indicating 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 Supported by the .NET Compact Framework HasRows Overridden. Gets a value that indicates whether the SqlCeDataReader contains one or more rows
Public property Supported by the .NET Compact Framework HiddenFieldCount  
Public property Supported by the .NET Compact Framework IsClosed Overridden. Indicates whether the data reader is 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 SQL statement.
Public property Supported by the .NET Compact Framework VisibleFieldCount  Gets the number of fields in the DbDataReader that are not hidden.(inherited from DbDataReader)

Top

Public Methods

(see also Protected Methods )

  Name Description
Public method Supported by the .NET Compact Framework Close Overridden. Closes the SqlCeDataReader 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 Supported by the .NET Compact Framework Dispose Overloaded.  
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 as an array starting at the given buffer offset.
Public method Supported by the .NET Compact Framework GetChar Overridden. Not supported in the .NET Compact Framework Data Provider for SQL Server Compact Edition.
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 Supported by the .NET Compact Framework GetEnumerator Overridden.  
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. (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 Supported by the .NET Compact Framework GetProviderSpecificFieldType Overridden. Gets a Object that is a representation of the underlying provider-specific field type.
Public method Supported by the .NET Compact Framework GetProviderSpecificValue  Gets the value of the specified column as an instance of Object. (inherited from DbDataReader)
Public method Supported by the .NET Compact Framework GetProviderSpecificValues  Gets all provider-specific attribute columns in the collection for the current row. (inherited from DbDataReader)
Public method Supported by the .NET Compact Framework GetSchemaTable Overridden. Returns a DataTable that describes the column metadata of the SqlCeDataReader.
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 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 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 column at the specified ordinal in its native format.
Public method Supported by the .NET Compact Framework GetValues Overridden. Gets all the attribute columns in 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 indicating whether the column contains nonexistent or missing values.
Public method Supported by the .NET Compact Framework NextResult Overridden. Not supported in the .NET Compact Framework Data Provider for SQL Server Compact Edition.
Public method Supported by the .NET Compact Framework Read Overridden. Advances SqlCeDataReader 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 Seek Places the SqlCeDataReader on the record with indexed values that match the specified parameters.
Public method Supported by the .NET Compact Framework ToString  Returns a String that represents the current Object. (inherited from Object)

Top

Protected Methods

  Name Description
Protected method Supported by the .NET Compact Framework Dispose  Overloaded. Releases the resources used by the DbDataReader and calls Close. (inherited from DbDataReader)
Protected method Supported by the .NET Compact Framework Finalize Overridden. Releases unmanaged resources and performs other cleanup operations before the SqlCeDataReader is reclaimed by garbage collection.
Protected method Supported by the .NET Compact Framework GetDbDataReader  Returns a DbDataReader object for the requested column ordinal that can be overridden with a provider-specific implementation. (inherited from DbDataReader)
Protected method Supported by the .NET Compact Framework MemberwiseClone  Overloaded. (inherited from MarshalByRefObject)
Protected method Supported by the .NET Compact Framework OnMove  

Top

Explicit Interface Implementations

  Name Description
Explicit interface implementation Method Supported by the .NET Compact Framework System.Data.IDataRecord.GetData  

Top

See Also

Reference

SqlCeDataReader Class
System.Data.SqlServerCe Namespace