SqlCeResultSet Members
An updateable, scrollable, and bindable cursor.
The following tables list the members exposed by the SqlCeResultSet type.
Protected Constructors
| Name | Description | |
|---|---|---|
| SqlCeResultSet | Do not use. To create a SqlCeResultSet, you must call the ExecuteResultSet method of the SqlCeCommand. |
Top
Public Properties
(see also Protected Properties )
| Name | Description | |
|---|---|---|
.gif "0385h814.pubproperty(en-us,VS.90).gif") |
Depth | Gets a value indicating the depth of nesting for the current row. (inherited from SqlCeDataReader) |
|
FieldCount | Gets the number of columns in the query's SELECT clause. (inherited from SqlCeDataReader) |
|
HasRows | Gets a value that indicates whether the SqlCeDataReader contains one or more rows (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 SqlCeResultSet to a control. |
|
Scrollable | Determines whether the SqlCeResultSet is scrollable. |
|
Sensitivity | Determines the sensitivity of the SqlCeResultSet. |
|
Updatable | Determines whether values within the SqlCeResultSet can be modified. |
|
VisibleFieldCount | (inherited from DbDataReader ) |
Top
Protected Properties
| Name | Description | |
|---|---|---|
.gif "0385h814.protproperty(en-us,VS.90).gif") |
ContainsListCollection |
Top
Public Methods
(see also Protected Methods )
| Name | Description | |
|---|---|---|
.gif "0385h814.pubmethod(en-us,VS.90).gif") |
Close | Closes the SqlCeDataReader object. (inherited from SqlCeDataReader) |
|
CreateObjRef | (inherited from MarshalByRefObject ) |
|
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. (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 | (inherited from SqlCeDataReader ) |
|
GetChars | Overridden. Copies a length of chars into the buffer, starting at a specified position in the specified field. |
|
GetData | (inherited from DbDataReader ) |
|
GetDataTypeName | (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. Returns a IEnumerator that can be used to iterate through the rows in the data reader. |
|
GetFieldType | (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 | (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. |
|
GetLifetimeService | (inherited from MarshalByRefObject ) |
|
GetName | (inherited from SqlCeDataReader ) |
|
GetOrdinal | (inherited from SqlCeDataReader ) |
|
GetProviderSpecificFieldType | (inherited from SqlCeDataReader ) |
|
GetProviderSpecificValue | (inherited from DbDataReader ) |
|
GetProviderSpecificValues | (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 | (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. |
|
InitializeLifetimeService | (inherited from MarshalByRefObject ) |
|
Insert | Overloaded. Inserts the specified SqlCeUpdatableRecord into the underlying rowset. |
|
IsDBNull | Overridden. Determines if the field at the specified ordinal position is null. |
|
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 Compact 3.5 SP1. (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. |
.gif "0385h814.static(en-us,VS.90).gif") |
ReferenceEquals | (inherited from Object ) |
|
Seek | (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 | (inherited from Object ) |
|
Update | Sends changes from the current record to the underlying row on the server. |
Top
Protected Methods
| Name | Description | |
|---|---|---|
.gif "0385h814.protmethod(en-us,VS.90).gif") |
Dispose | Overloaded. (inherited from DbDataReader ) |
|
Finalize | Releases unmanaged resources and performs other cleanup operations before the SqlCeDataReader is reclaimed by garbage collection. (inherited from SqlCeDataReader) |
|
GetDbDataReader | (inherited from DbDataReader ) |
|
GetList | Returns an instance of ResultSetView. |
|
IsCommandBehavior | (inherited from SqlCeDataReader ) |
|
MemberwiseClone | Overloaded. (inherited from MarshalByRefObject ) |
|
OnMove | Overridden. |
Top
Explicit Interface Implementations
| Name | Description | |
|---|---|---|
| System.Collections.IEnumerable.GetEnumerator | ||
| System.ComponentModel.IListSource.GetList | ||
| System.Data.IDataRecord.GetData | (inherited from DbDataReader ) | |
| System.ComponentModel.IListSource.ContainsListCollection |
Top