SqlCeResultSet Members
An updateable, scrollable, and bindable cursor.
The SqlCeResultSet type exposes the following members.
Constructors
| Name | Description | |
|---|---|---|
.gif "Protected method") |
SqlCeResultSet() () () () | Do not use. To create a SqlCeResultSet, you must call the ExecuteResultSet(ResultSetOptions) method of the SqlCeCommand. |
Top
Methods
| Name | Description | |
|---|---|---|
.gif "Public method") |
Close() () () () | Closes the SqlCeDataReader object. (inherited from SqlCeDataReader) |
|
CreateObjRef(Type) | (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() () () () | Infrastructure. Releases the resources consumed by this SqlCeDataReader. (inherited from SqlCeDataReader) |
|
Dispose(Boolean) | (inherited from DbDataReader) |
|
Equals(Object) | (inherited from Object) |
|
Finalize() () () () | Releases unmanaged resources and performs other cleanup operations before the SqlCeDataReader is reclaimed by garbage collection. (inherited from SqlCeDataReader) |
|
GetBoolean(Int32) | Returns the value of the column at the specified index as a Boolean value. (Overrides SqlCeDataReader. . :: . .GetBoolean(Int32).) |
|
GetByte(Int32) | Returns the value of the column at the specified index as a byte. (Overrides SqlCeDataReader. . :: . .GetByte(Int32).) |
|
GetBytes(Int32, Int64, array<Byte> [] () [] [], Int32, Int32) | Copies a length of bytes into the buffer, starting at a specified position in the specified field. (Overrides SqlCeDataReader. . :: . .GetBytes(Int32, Int64, array<Byte> [] () [] [], Int32, Int32).) |
|
GetChar(Int32) | Not supported in the .NET Compact Framework Data Provider for . (inherited from SqlCeDataReader) |
|
GetChars(Int32, Int64, array<Char> [] () [] [], Int32, Int32) | Copies a length of chars into the buffer, starting at a specified position in the specified field. (Overrides SqlCeDataReader. . :: . .GetChars(Int32, Int64, array<Char> [] () [] [], Int32, Int32).) |
|
GetData(Int32) | (inherited from DbDataReader) |
|
GetDataTypeName(Int32) | Gets the name of the source data type. (inherited from SqlCeDataReader) |
|
GetDateTime(Int32) | Returns the value of the column at the specified index as a DateTime. (Overrides SqlCeDataReader. . :: . .GetDateTime(Int32).) |
|
GetDbDataReader(Int32) | (inherited from DbDataReader) |
|
GetDecimal(Int32) | Returns the value of the column at the specified index as a Double. (Overrides SqlCeDataReader. . :: . .GetDecimal(Int32).) |
|
GetDouble(Int32) | Returns the value of the column at the specified index as a Double. (Overrides SqlCeDataReader. . :: . .GetDouble(Int32).) |
|
GetEnumerator() () () () | Returns a IEnumerator that can be used to iterate through the rows in the data reader. (Overrides SqlCeDataReader. . :: . .GetEnumerator() () () ().) |
|
GetFieldType(Int32) | Gets the Type that is the data type of the object. (inherited from SqlCeDataReader) |
|
GetFloat(Int32) | Returns the value of the column at the specified index as a Float. (Overrides SqlCeDataReader. . :: . .GetFloat(Int32).) |
|
GetGuid(Int32) | Returns the value of the column at the specified index as a GUID. (Overrides SqlCeDataReader. . :: . .GetGuid(Int32).) |
|
GetHashCode() () () () | (inherited from Object) |
|
GetInt16(Int32) | Returns the value of the column at the specified index as an Int16. (Overrides SqlCeDataReader. . :: . .GetInt16(Int32).) |
|
GetInt32(Int32) | Returns the value of the column at the specified index as an Int32. (Overrides SqlCeDataReader. . :: . .GetInt32(Int32).) |
|
GetInt64(Int32) | Returns the value of the column at the specified index as an Int64. (Overrides SqlCeDataReader. . :: . .GetInt64(Int32).) |
|
GetLifetimeService() () () () | (inherited from MarshalByRefObject) |
|
GetList() () () () | Returns an instance of ResultSetView. |
|
GetName(Int32) | Gets the name of the specified column. (inherited from SqlCeDataReader) |
|
GetOrdinal(String) | Gets the column ordinal, given the name of the column. (inherited from SqlCeDataReader) |
|
GetProviderSpecificFieldType(Int32) | Gets a Object that is a representation of the underlying provider-specific field type. (inherited from SqlCeDataReader) |
|
GetProviderSpecificValue(Int32) | (inherited from DbDataReader) |
|
GetProviderSpecificValues(array<Object> [] () [] []) | (inherited from DbDataReader) |
|
GetSchemaTable() () () () | Returns a DataTable that describes the column metadata of the SqlCeDataReader. (inherited from SqlCeDataReader) |
|
GetSqlBinary(Int32) | Returns the value of the column at the specified index as type SqlBinary. (Overrides SqlCeDataReader. . :: . .GetSqlBinary(Int32).) |
|
GetSqlBoolean(Int32) | Returns the value of the column at the specified index as type SqlBoolean. (Overrides SqlCeDataReader. . :: . .GetSqlBoolean(Int32).) |
|
GetSqlByte(Int32) | Returns the value of the column at the specified index as type SqlByte. (Overrides SqlCeDataReader. . :: . .GetSqlByte(Int32).) |
|
GetSqlDateTime(Int32) | Returns the value of the column at the specified index as type SqlDateTime. (Overrides SqlCeDataReader. . :: . .GetSqlDateTime(Int32).) |
|
GetSqlDecimal(Int32) | Returns the value of the column at the specified index as type SqlDecimal. (Overrides SqlCeDataReader. . :: . .GetSqlDecimal(Int32).) |
|
GetSqlDouble(Int32) | Returns the value of the column at the specified index as type SqlDouble. (Overrides SqlCeDataReader. . :: . .GetSqlDouble(Int32).) |
|
GetSqlGuid(Int32) | Returns the value of the column at the specified index as type SqlGuid. (Overrides SqlCeDataReader. . :: . .GetSqlGuid(Int32).) |
|
GetSqlInt16(Int32) | Returns the value of the column at the specified index as type SqlInt16. (Overrides SqlCeDataReader. . :: . .GetSqlInt16(Int32).) |
|
GetSqlInt32(Int32) | Returns the value of the column at the specified index as type SqlInt32. (Overrides SqlCeDataReader. . :: . .GetSqlInt32(Int32).) |
|
GetSqlInt64(Int32) | Returns the value of the column at the specified index as type SqlInt64. (Overrides SqlCeDataReader. . :: . .GetSqlInt64(Int32).) |
|
GetSqlMetaData(Int32) | Returns the metadata information associated with the specified column. |
|
GetSqlMoney(Int32) | Returns the value of the column at the specified index as type SqlMoney. (Overrides SqlCeDataReader. . :: . .GetSqlMoney(Int32).) |
|
GetSqlSingle(Int32) | Returns the value of the column at the specified index as type SqlSingle. (Overrides SqlCeDataReader. . :: . .GetSqlSingle(Int32).) |
|
GetSqlString(Int32) | Returns the value of the column at the specified index as type SqlString. (Overrides SqlCeDataReader. . :: . .GetSqlString(Int32).) |
|
GetString(Int32) | Returns the value of the column at the specified index as type String. (Overrides SqlCeDataReader. . :: . .GetString(Int32).) |
|
GetType() () () () | (inherited from Object) |
|
GetValue(Int32) | Returns the value of the specified field. (Overrides SqlCeDataReader. . :: . .GetValue(Int32).) |
|
GetValues(array<Object> [] () [] []) | Retrieves an array of all of the fields for the specified record. (Overrides SqlCeDataReader. . :: . .GetValues(array<Object> [] () [] []).) |
|
InitializeLifetimeService() () () () | (inherited from MarshalByRefObject) |
|
Insert(SqlCeUpdatableRecord) | Inserts the specified SqlCeUpdatableRecord into the underlying rowset. |
|
Insert(SqlCeUpdatableRecord, DbInsertOptions) | Inserts the specified SqlCeUpdatableRecord into the underlying rowset and specifies how the cursor is positioned. |
|
IsCommandBehavior(CommandBehavior) | (inherited from SqlCeDataReader) |
|
IsDBNull(Int32) | Determines if the field at the specified ordinal position is null. (Overrides SqlCeDataReader. . :: . .IsDBNull(Int32).) |
|
IsSetAsDefault(Int32) | Determines if the field at the specified ordinal position is marked to use the underlying default value. |
|
MemberwiseClone() () () () | (inherited from Object) |
|
MemberwiseClone(Boolean) | (inherited from MarshalByRefObject) |
|
NextResult() () () () | Not supported in the .NET Compact Framework Data Provider for . (inherited from SqlCeDataReader) |
|
OnMove() () () () | Infrastructure. (Overrides SqlCeDataReader. . :: . .OnMove() () () ().) |
|
Read() () () () | Advances SqlCeDataReader to the next record. (inherited from SqlCeDataReader) |
|
ReadAbsolute(Int32) | 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(Int32) | Moves the reader the specified amount from the current position. |
|
Seek(DbSeekOptions, array<Object> [] () [] []) | Places the SqlCeDataReader on the record with indexed values that match the specified parameters. (inherited from SqlCeDataReader) |
|
SetBoolean(Int32, Boolean) | Sets the value of the specified column to the passed-in Boolean value. |
|
SetByte(Int32, Byte) | Sets the value of the specified column to the passed-in Byte value. |
|
SetBytes(Int32, Int64, array<Byte> [] () [] [], Int32, Int32) | Copies a length of bytes from the specified buffer to the specified column, starting at the specified location within that field. |
|
SetChar(Int32, Char) | Sets the value of the specified column to the passed-in Char value. |
|
SetChars(Int32, Int64, array<Char> [] () [] [], Int32, Int32) | Copies a length of chars from the specified buffer to the specified column, starting at the specified location within that field. |
|
SetDateTime(Int32, DateTime) | Sets the value of the specified column to the passed-in DateTime value. |
|
SetDecimal(Int32, Decimal) | Sets the value of the specified column to the passed-in Decimal value. |
|
SetDefault(Int32) | Sets the specified column to its default value. |
|
SetDouble(Int32, Double) | Sets the value of the specified column to the passed-in Double value. |
|
SetFloat(Int32, Single) | Sets the value of the specified column to the passed-in Float value. |
|
SetGuid(Int32, Guid) | Sets the value of the specified column to the passed-in Guid value. |
|
SetInt16(Int32, Int16) | Sets the value of the specified column to the passed-in Int16 value. |
|
SetInt32(Int32, Int32) | Sets the value of the specified column to the passed-in Int32 value. |
|
SetInt64(Int32, Int64) | Sets the value of the specified column to the passed-in Int64 value. |
|
SetObjectRef(Int32, Object) | Binds an object to the column at the specified position. |
|
SetSqlBinary(Int32, SqlBinary) | Sets the value of the specified column to the passed-in SqlBinary value. |
|
SetSqlBoolean(Int32, SqlBoolean) | Sets the value of the specified column to the passed-in SqlBoolean value. |
|
SetSqlByte(Int32, SqlByte) | Sets the value of the specified column to the passed-in SqlByte value. |
|
SetSqlDateTime(Int32, SqlDateTime) | Sets the value of the specified column to the passed-in SqlDateTime value. |
|
SetSqlDecimal(Int32, SqlDecimal) | Sets the value of the specified column to the passed-in SqlDecimal value. |
|
SetSqlDouble(Int32, SqlDouble) | Sets the value of the specified column to the passed-in SqlDouble value. |
|
SetSqlGuid(Int32, SqlGuid) | Sets the value of the specified column to the passed-in SqlGuid value. |
|
SetSqlInt16(Int32, SqlInt16) | Sets the value of the specified column to the passed-in SqlInt16 value. |
|
SetSqlInt32(Int32, SqlInt32) | Sets the value of the specified column to the passed-in SqlInt32 value. |
|
SetSqlInt64(Int32, SqlInt64) | Sets the value of the specified column to the passed-in SqlInt64 value. |
|
SetSqlMoney(Int32, SqlMoney) | Sets the value of the specified column to the passed-in SqlMoney value. |
|
SetSqlSingle(Int32, SqlSingle) | Sets the value of the specified column to the passed-in SqlSingle value. |
|
SetSqlString(Int32, SqlString) | Sets the value of the specified column to the passed-in SqlString value. |
|
SetString(Int32, String) | Sets the value of the specified column to the passed-in String value. |
|
SetValue(Int32, Object) | Sets the value of the specified column to the passed-in value. |
|
SetValues(array<Object> [] () [] []) | 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
Properties
| Name | Description | |
|---|---|---|
.gif "Protected property") |
ContainsListCollection | Infrastructure. |
.gif "Public property") |
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 | Infrastructure. (inherited from SqlCeDataReader) |
|
IsClosed | Indicates whether the data reader is closed. (inherited from SqlCeDataReader) |
|
Item[ ( [ ( Int32] ) ] ) | Serves as an indexer for the SqlCeResultSet. (Overrides SqlCeDataReader. . :: . .Item[ ( [ ( Int32] ) ] ).) |
|
Item[ ( [ ( String] ) ] ) | Serves as an indexer for the SqlCeResultSet. (Overrides SqlCeDataReader. . :: . .Item[ ( [ ( String] ) ] ).) |
|
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
Explicit Interface Implementations
| Name | Description | |
|---|---|---|
.gif "Explicit interface implemetation") .gif "Private property") |
IListSource. . :: . .ContainsListCollection | |
.gif "Private method") |
IEnumerable. . :: . .GetEnumerator() () () () | |
|
IListSource. . :: . .GetList() () () () | |
|
IDataRecord. . :: . .GetData(Int32) | (inherited from DbDataReader) |
Top