SqlCeResultSet Members
.NET Framework 2.0
An updateable, scrollable, and bindable cursor.
The following tables list the members exposed by the SqlCeResultSet type.
| Name | Description | |
|---|---|---|
| SqlCeResultSet | Do not use. To create a SqlCeResultSet, you must call the ExecuteResultSet method of the SqlCeCommand. |
(see also
Protected Properties
)
Top
| Name | Description | |
|---|---|---|
| Depth | Gets a value indicating the depth of nesting for the current row.(Inherited from SqlCeDataReader.) |
| FieldCount | Gets the number of columns in the current row.(Inherited from SqlCeDataReader.) |
| HasRows | (Inherited from SqlCeDataReader.) |
| HiddenFieldCount | (Inherited from SqlCeDataReader.) |
| IsClosed | Indicates whether the data reader is closed.(Inherited from SqlCeDataReader.) |
| Item | Overloaded. Overridden. Serves as an indexer for the SqlCeResultSet. |
| RecordsAffected | Gets the number of rows changed, inserted, or deleted by execution of the SQL statement.(Inherited from SqlCeDataReader.) |
| ResultSetView | Used when data binding a ResultSet to a control. |
| Scrollable | Determines whether the ResultSet is scrollable. |
| Sensitivity | Determines the sensitivity of the ResultSet. |
| Updatable | Determines whether values within the ResultSet can be modified. |
| VisibleFieldCount | Gets the number of fields in the DbDataReader that are not hidden.(Inherited from DbDataReader.) |
(see also
Protected Methods
)
Top
| Name | Description | |
|---|---|---|
| Close | Closes the SqlCeDataReader object. (Inherited from SqlCeDataReader.) |
| CreateRecord | Creates a new row on the server and returns a SqlCeUpdatableRecord object. |
| Delete | Deletes the current record from the data source on the server. |
| Dispose | Overloaded. (Inherited from SqlCeDataReader.) |
| Equals | Overloaded. Determines whether two Object instances are equal. (Inherited from Object.) |
| GetBoolean | Overridden. Returns the value of the column at the specified index as a Boolean value. |
| GetByte | Overridden. Returns the value of the column at the specified index as a byte. |
| GetBytes | Overridden. Copies a length of bytes into the buffer, starting at a specified position in the specified field. |
| GetChar | Not supported in the .NET Compact Framework Data Provider for SQL Server Mobile. (Inherited from SqlCeDataReader.) |
| GetChars | Overridden. Copies a length of chars into the buffer, starting at a specified position in the specified field. |
| GetData | Returns a DbDataReader object for the requested column ordinal. (Inherited from DbDataReader.) |
| GetDataTypeName | Gets the name of the source data type. (Inherited from SqlCeDataReader.) |
| GetDateTime | Overridden. Returns the value of the column at the specified index as a DateTime. |
| GetDecimal | Overridden. Returns the value of the column at the specified index as a Double. |
| GetDouble | Overridden. Returns the value of the column at the specified index as a Double. |
| GetEnumerator | Overridden. |
| GetFieldType | Gets the Type that is the data type of the object. (Inherited from SqlCeDataReader.) |
| GetFloat | Overridden. Returns the value of the column at the specified index as a Float. |
| GetGuid | Overridden. Returns the value of the column at the specified index as a GUID. |
| 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.) |
| GetInt16 | Overridden. Returns the value of the column at the specified index as an Int16. |
| GetInt32 | Overridden. Returns the value of the column at the specified index as an Int32. |
| GetInt64 | Overridden. Returns the value of the column at the specified index as an Int64. |
| GetName | Gets the name of the specified column. (Inherited from SqlCeDataReader.) |
| GetOrdinal | Gets the column ordinal, given the name of the column. (Inherited from SqlCeDataReader.) |
| GetProviderSpecificFieldType | (Inherited from SqlCeDataReader.) |
| GetProviderSpecificValue | Gets the value of the specified column as an instance of Object. (Inherited from DbDataReader.) |
| GetProviderSpecificValues | Gets all provider-specific attribute columns in the collection for the current row. (Inherited from DbDataReader.) |
| GetSchemaTable | Returns a DataTable that describes the column metadata of the SqlCeDataReader. (Inherited from SqlCeDataReader.) |
| GetSqlBinary | Overridden. Returns the value of the column at the specified index as type SqlBinary. |
| GetSqlBoolean | Overridden. Returns the value of the column at the specified index as type SqlBoolean. |
| GetSqlByte | Overridden. Returns the value of the column at the specified index as type SqlByte. |
| GetSqlDateTime | Overridden. Returns the value of the column at the specified index as type SqlDateTime. |
| GetSqlDecimal | Overridden. Returns the value of the column at the specified index as type SqlDecimal. |
| GetSqlDouble | Overridden. Returns the value of the column at the specified index as type SqlDouble. |
| GetSqlGuid | Overridden. Returns the value of the column at the specified index as type SqlGuid. |
| GetSqlInt16 | Overridden. Returns the value of the column at the specified index as type SqlInt16. |
| GetSqlInt32 | Overridden. Returns the value of the column at the specified index as type SqlInt32. |
| GetSqlInt64 | Overridden. Returns the value of the column at the specified index as type SqlInt64. |
| GetSqlMetaData | Returns the metadata information associated with the specified column. |
| GetSqlMoney | Overridden. Returns the value of the column at the specified index as type SqlMoney. |
| GetSqlSingle | Overridden. Returns the value of the column at the specified index as type SqlSingle. |
| GetSqlString | Overridden. Returns the value of the column at the specified index as type SqlString. |
| GetString | Overridden. Returns the value of the column at the specified index as type String. |
| GetType | Gets the Type of the current instance. (Inherited from Object.) |
| GetValue | Overridden. Returns the value of the specified field. |
| GetValues | Overridden. Retrieves an array of all of the fields for the specified record. |
| Insert | Overloaded. |
| IsDBNull | Overridden. Determines if the field at the specified ordinal position is a null reference (Nothing in Visual Basic). |
| IsSetAsDefault | Determines if the field at the specified ordinal position is marked to use the underlying default value. |
| NextResult | Not supported in the .NET Compact Framework Data Provider for SQL Server Mobile. (Inherited from SqlCeDataReader.) |
| Read | Advances SqlCeDataReader to the next record. (Inherited from SqlCeDataReader.) |
| ReadAbsolute | Moves the reader to a specific record in the ResultSet. |
| ReadFirst | Positions the reader at the first record in the ResultSet. |
| ReadLast | Positions the reader at the last record in the ResultSet. |
| ReadPrevious | Positions the reader at the record pervious to the current record. |
| ReadRelative | Moves the reader the specified amount from the current position. |
| ReferenceEquals | Determines whether the specified Object instances are the same instance. (Inherited from Object.) |
| Seek | Places the SqlCeDataReader on the record with indexed values that match the specified parameters. (Inherited from SqlCeDataReader.) |
| SetBoolean | Sets the value of the specified column to the passed-in Boolean value. |
| SetByte | Sets the value of the specified column to the passed-in Byte value. |
| SetBytes | Copies a length of bytes from the specified buffer to the specified column, starting at the specified location within that field. |
| SetChar | Sets the value of the specified column to the passed-in Char value. |
| SetChars | Copies a length of chars from the specified buffer to the specified column, starting at the specified location within that field. |
| SetDateTime | Sets the value of the specified column to the passed-in DateTime value. |
| SetDecimal | Sets the value of the specified column to the passed-in Decimal value. |
| SetDefault | Sets the specified column to its default value. |
| SetDouble | Sets the value of the specified column to the passed-in Double value. |
| SetFloat | Sets the value of the specified column to the passed-in Float value. |
| SetGuid | Sets the value of the specified column to the passed-in Guid value. |
| SetInt16 | Sets the value of the specified column to the passed-in Int16 value. |
| SetInt32 | Sets the value of the specified column to the passed-in Int32 value. |
| SetInt64 | Sets the value of the specified column to the passed-in Int64 value. |
| SetObjectRef | Binds an object to the column at the specified position. |
| SetSqlBinary | Sets the value of the specified column to the passed-in SqlBinary value. |
| SetSqlBoolean | Sets the value of the specified column to the passed-in SqlBoolean value. |
| SetSqlByte | Sets the value of the specified column to the passed-in SqlByte value. |
| SetSqlDateTime | Sets the value of the specified column to the passed-in SqlDateTime value. |
| SetSqlDecimal | Sets the value of the specified column to the passed-in SqlDecimal value. |
| SetSqlDouble | Sets the value of the specified column to the passed-in SqlDouble value. |
| SetSqlGuid | Sets the value of the specified column to the passed-in SqlGuid value. |
| SetSqlInt16 | Sets the value of the specified column to the passed-in SqlInt16 value. |
| SetSqlInt32 | Sets the value of the specified column to the passed-in SqlInt32 value. |
| SetSqlInt64 | Sets the value of the specified column to the passed-in SqlInt64 value. |
| SetSqlMoney | Sets the value of the specified column to the passed-in SqlMoney value. |
| SetSqlSingle | Sets the value of the specified column to the passed-in SqlSingle value. |
| SetSqlString | Sets the value of the specified column to the passed-in SqlString value. |
| SetString | Sets the value of the specified column to the passed-in String value. |
| SetValue | Sets the value of the specified column to the passed-in value. |
| SetValues | Sets each of the fields in the specified record to the corresponding value in the specified array. |
| ToString | Returns a String that represents the current Object. (Inherited from Object.) |
| Update | Sends changes from the current record to the underlying row on the server. |
| Name | Description | |
|---|---|---|
| Dispose | Overloaded. Releases the resources used by the DbDataReader. (Inherited from DbDataReader.) |
| Finalize | (Inherited from SqlCeDataReader.) |
| GetDbDataReader | Returns a DbDataReader object for the requested column ordinal that can be overridden with a provider-specific implementation. (Inherited from DbDataReader.) |
| GetList | Returns an instance of ResultSetView. |
| MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object.) |
| OnMove | Overridden. |