SqlCeResultSet Members

  • Article

An updateable, scrollable, and bindable cursor.

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

Protected Constructors

  Name Description
Protected method Supported by the .NET Compact Framework 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
Public property Supported by the .NET Compact Framework Depth  Gets a value indicating the depth of nesting for the current row.(inherited from SqlCeDataReader)
Public property Supported by the .NET Compact Framework FieldCount  Gets the number of columns in the current row.(inherited from SqlCeDataReader)
Public property Supported by the .NET Compact Framework HasRows  Gets a value that indicates whether the SqlCeDataReader contains one or more rows(inherited from SqlCeDataReader)
Public property Supported by the .NET Compact Framework HiddenFieldCount  (inherited from SqlCeDataReader)
Public property Supported by the .NET Compact Framework IsClosed  Indicates whether the data reader is closed.(inherited from SqlCeDataReader)
Public property Supported by the .NET Compact Framework Item Overloaded. Overridden. Serves as an indexer for the SqlCeResultSet.
Public property Supported by the .NET Compact Framework RecordsAffected  Gets the number of rows changed, inserted, or deleted by execution of the SQL statement.(inherited from SqlCeDataReader)
Public property Supported by the .NET Compact Framework ResultSetView Used when data binding a SqlCeResultSet to a control.
Public property Supported by the .NET Compact Framework Scrollable Determines whether the SqlCeResultSet is scrollable.
Public property Supported by the .NET Compact Framework Sensitivity Determines the sensitivity of the SqlCeResultSet.
Public property Supported by the .NET Compact Framework Updatable Determines whether values within the SqlCeResultSet can be modified.
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

Protected Properties

  Name Description
Protected property Supported by the .NET Compact Framework ContainsListCollection  

Top

Public Methods

(see also Protected Methods )

  Name Description
Public method Supported by the .NET Compact Framework Close  Closes the SqlCeDataReader object. (inherited from SqlCeDataReader)
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 CreateRecord Creates a new row on the server and returns a SqlCeUpdatableRecord object.
Public method Supported by the .NET Compact Framework Delete Deletes the current record from the data source on the server.
Public method Supported by the .NET Compact Framework Dispose  Overloaded. (inherited from SqlCeDataReader)
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. Returns the value of the column at the specified index as a Boolean value.
Public method Supported by the .NET Compact Framework GetByte Overridden. Returns the value of the column at the specified index as a byte.
Public method Supported by the .NET Compact Framework GetBytes Overridden. Copies a length of bytes into the buffer, starting at a specified position in the specified field.
Public method Supported by the .NET Compact Framework GetChar  Not supported in the .NET Compact Framework Data Provider for SQL Server Compact Edition. (inherited from SqlCeDataReader)
Public method Supported by the .NET Compact Framework GetChars Overridden. Copies a length of chars into the buffer, starting at a specified position in the specified field.
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  Gets the name of the source data type. (inherited from SqlCeDataReader)
Public method Supported by the .NET Compact Framework GetDateTime Overridden. Returns the value of the column at the specified index as a DateTime.
Public method Supported by the .NET Compact Framework GetDecimal Overridden. Returns the value of the column at the specified index as a Double.
Public method Supported by the .NET Compact Framework GetDouble Overridden. Returns the value of the column at the specified index as a Double.
Public method Supported by the .NET Compact Framework GetEnumerator Overridden. Returns a IEnumerator that can be used to iterate through the rows in the data reader.
Public method Supported by the .NET Compact Framework GetFieldType  Gets the Type that is the data type of the object. (inherited from SqlCeDataReader)
Public method Supported by the .NET Compact Framework GetFloat Overridden. Returns the value of the column at the specified index as a Float.
Public method Supported by the .NET Compact Framework GetGuid Overridden. Returns the value of the column at the specified index as a 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. Returns the value of the column at the specified index as an Int16.
Public method Supported by the .NET Compact Framework GetInt32 Overridden. Returns the value of the column at the specified index as an Int32.
Public method Supported by the .NET Compact Framework GetInt64 Overridden. Returns the value of the column at the specified index as an Int64.
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  Gets the name of the specified column. (inherited from SqlCeDataReader)
Public method Supported by the .NET Compact Framework GetOrdinal  Gets the column ordinal, given the name of the column. (inherited from SqlCeDataReader)
Public method Supported by the .NET Compact Framework GetProviderSpecificFieldType  Gets a Object that is a representation of the underlying provider-specific field type. (inherited from SqlCeDataReader)
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  Returns a DataTable that describes the column metadata of the SqlCeDataReader. (inherited from SqlCeDataReader)
Public method Supported by the .NET Compact Framework GetSqlBinary Overridden. Returns the value of the column at the specified index as type SqlBinary.
Public method Supported by the .NET Compact Framework GetSqlBoolean Overridden. Returns the value of the column at the specified index as type SqlBoolean.
Public method Supported by the .NET Compact Framework GetSqlByte Overridden. Returns the value of the column at the specified index as type SqlByte.
Public method Supported by the .NET Compact Framework GetSqlDateTime Overridden. Returns the value of the column at the specified index as type SqlDateTime.
Public method Supported by the .NET Compact Framework GetSqlDecimal Overridden. Returns the value of the column at the specified index as type SqlDecimal.
Public method Supported by the .NET Compact Framework GetSqlDouble Overridden. Returns the value of the column at the specified index as type SqlDouble.
Public method Supported by the .NET Compact Framework GetSqlGuid Overridden. Returns the value of the column at the specified index as type SqlGuid.
Public method Supported by the .NET Compact Framework GetSqlInt16 Overridden. Returns the value of the column at the specified index as type SqlInt16.
Public method Supported by the .NET Compact Framework GetSqlInt32 Overridden. Returns the value of the column at the specified index as type SqlInt32.
Public method Supported by the .NET Compact Framework GetSqlInt64 Overridden. Returns the value of the column at the specified index as type SqlInt64.
Public method Supported by the .NET Compact Framework GetSqlMetaData Returns the metadata information associated with the specified column.
Public method Supported by the .NET Compact Framework GetSqlMoney Overridden. Returns the value of the column at the specified index as type SqlMoney.
Public method Supported by the .NET Compact Framework GetSqlSingle Overridden. Returns the value of the column at the specified index as type SqlSingle.
Public method Supported by the .NET Compact Framework GetSqlString Overridden. Returns the value of the column at the specified index as type SqlString.
Public method Supported by the .NET Compact Framework GetString Overridden. Returns the value of the column at the specified index as type 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. Returns the value of the specified field.
Public method Supported by the .NET Compact Framework GetValues Overridden. Retrieves an array of all of the fields for the specified record.
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 Insert Overloaded. Inserts the specified SqlCeUpdatableRecord into the underlying rowset.
Public method Supported by the .NET Compact Framework IsDBNull Overridden. Determines if the field at the specified ordinal position is null.
Public method Supported by the .NET Compact Framework IsSetAsDefault Determines if the field at the specified ordinal position is marked to use the underlying default value.
Public method Supported by the .NET Compact Framework NextResult  Not supported in the .NET Compact Framework Data Provider for SQL Server Compact Edition. (inherited from SqlCeDataReader)
Public method Supported by the .NET Compact Framework Read  Advances SqlCeDataReader to the next record. (inherited from SqlCeDataReader)
Public method Supported by the .NET Compact Framework ReadAbsolute Moves the reader to a specific record in the ResultSet.
Public method Supported by the .NET Compact Framework ReadFirst Positions the reader at the first record in the ResultSet.
Public method Supported by the .NET Compact Framework ReadLast Positions the reader at the last record in the ResultSet.
Public method Supported by the .NET Compact Framework ReadPrevious Positions the reader at the record pervious to the current record.
Public method Supported by the .NET Compact Framework ReadRelative Moves the reader the specified amount from the current position.
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. (inherited from SqlCeDataReader)
Public method Supported by the .NET Compact Framework SetBoolean Sets the value of the specified column to the passed-in Boolean value.
Public method Supported by the .NET Compact Framework SetByte Sets the value of the specified column to the passed-in Byte value.
Public method Supported by the .NET Compact Framework SetBytes Copies a length of bytes from the specified buffer to the specified column, starting at the specified location within that field.
Public method Supported by the .NET Compact Framework SetChar Sets the value of the specified column to the passed-in Char value.
Public method Supported by the .NET Compact Framework SetChars Copies a length of chars from the specified buffer to the specified column, starting at the specified location within that field.
Public method Supported by the .NET Compact Framework SetDateTime Sets the value of the specified column to the passed-in DateTime value.
Public method Supported by the .NET Compact Framework SetDecimal Sets the value of the specified column to the passed-in Decimal value.
Public method Supported by the .NET Compact Framework SetDefault Sets the specified column to its default value.
Public method Supported by the .NET Compact Framework SetDouble Sets the value of the specified column to the passed-in Double value.
Public method Supported by the .NET Compact Framework SetFloat Sets the value of the specified column to the passed-in Float value.
Public method Supported by the .NET Compact Framework SetGuid Sets the value of the specified column to the passed-in Guid value.
Public method Supported by the .NET Compact Framework SetInt16 Sets the value of the specified column to the passed-in Int16 value.
Public method Supported by the .NET Compact Framework SetInt32 Sets the value of the specified column to the passed-in Int32 value.
Public method Supported by the .NET Compact Framework SetInt64 Sets the value of the specified column to the passed-in Int64 value.
Public method Supported by the .NET Compact Framework SetObjectRef Binds an object to the column at the specified position.
Public method Supported by the .NET Compact Framework SetSqlBinary Sets the value of the specified column to the passed-in SqlBinary value.
Public method Supported by the .NET Compact Framework SetSqlBoolean Sets the value of the specified column to the passed-in SqlBoolean value.
Public method Supported by the .NET Compact Framework SetSqlByte Sets the value of the specified column to the passed-in SqlByte value.
Public method Supported by the .NET Compact Framework SetSqlDateTime Sets the value of the specified column to the passed-in SqlDateTime value.
Public method Supported by the .NET Compact Framework SetSqlDecimal Sets the value of the specified column to the passed-in SqlDecimal value.
Public method Supported by the .NET Compact Framework SetSqlDouble Sets the value of the specified column to the passed-in SqlDouble value.
Public method Supported by the .NET Compact Framework SetSqlGuid Sets the value of the specified column to the passed-in SqlGuid value.
Public method Supported by the .NET Compact Framework SetSqlInt16 Sets the value of the specified column to the passed-in SqlInt16 value.
Public method Supported by the .NET Compact Framework SetSqlInt32 Sets the value of the specified column to the passed-in SqlInt32 value.
Public method Supported by the .NET Compact Framework SetSqlInt64 Sets the value of the specified column to the passed-in SqlInt64 value.
Public method Supported by the .NET Compact Framework SetSqlMoney Sets the value of the specified column to the passed-in SqlMoney value.
Public method Supported by the .NET Compact Framework SetSqlSingle Sets the value of the specified column to the passed-in SqlSingle value.
Public method Supported by the .NET Compact Framework SetSqlString Sets the value of the specified column to the passed-in SqlString value.
Public method Supported by the .NET Compact Framework SetString Sets the value of the specified column to the passed-in String value.
Public method Supported by the .NET Compact Framework SetValue Sets the value of the specified column to the passed-in value.
Public method Supported by the .NET Compact Framework SetValues Sets each of the fields in the specified record to the corresponding value in the specified array.
Public method Supported by the .NET Compact Framework ToString  Returns a String that represents the current Object. (inherited from Object)
Public method Supported by the .NET Compact Framework Update Sends changes from the current record to the underlying row on the server.

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  Releases unmanaged resources and performs other cleanup operations before the SqlCeDataReader is reclaimed by garbage collection. (inherited from SqlCeDataReader)
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 GetList Returns an instance of ResultSetView.
Protected method Supported by the .NET Compact Framework MemberwiseClone  Overloaded. (inherited from MarshalByRefObject)
Protected method Supported by the .NET Compact Framework OnMove Overridden.  

Top

Explicit Interface Implementations

  Name Description
Explicit interface implementation Method Supported by the .NET Compact Framework System.Collections.IEnumerable.GetEnumerator For a description of this member, see GetEnumerator.
Explicit interface implementation Method Supported by the .NET Compact Framework System.ComponentModel.IListSource.GetList  
Explicit interface implementation Property Supported by the .NET Compact Framework System.ComponentModel.IListSource.ContainsListCollection  

Top

See Also

Reference

SqlCeResultSet Class
System.Data.SqlServerCe Namespace