Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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