Share via


SqlCeCommand Members

Represents an SQL statement to execute against a data source.

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

Public Constructors

  Name Description
Public method Supported by the .NET Compact Framework SqlCeCommand Overloaded. Initializes a new instance of the SqlCeCommand class.

Top

Public Properties

(see also Protected Properties )

  Name Description
Public property Supported by the .NET Compact Framework CommandText Overridden. Gets or sets an SQL statement to execute at the data source.
Public property Supported by the .NET Compact Framework CommandTimeout Overridden. Gets or sets the wait time before terminating the attempt to execute a command and generating an error.
Public property Supported by the .NET Compact Framework CommandType Overridden. Gets or sets a value indicating how the CommandText property is interpreted.
Public property Supported by the .NET Compact Framework Connection Gets or sets the SqlCeConnection used by this instance of the SqlCeCommand.
Public property Supported by the .NET Compact Framework DesignTimeVisible Overridden. Get always returns false; set always throws a NotSupportedException.
Public property Supported by the .NET Compact Framework IndexName Specifies the index to be opened.
Public property Supported by the .NET Compact Framework Parameters Gets the SqlCeParameterCollection.
Public property Supported by the .NET Compact Framework Site  Gets or sets the ISite of the Component.(Inherited from Component.)
Public property Supported by the .NET Compact Framework Transaction Gets or sets the transaction in which the SqlCeCommand executes.
Public property Supported by the .NET Compact Framework UpdatedRowSource Overridden. Gets or sets how command results are applied to the DataRow when used by the Update method of the DbDataAdapter. This property should not be used with the .NET Compact Framework Data Provider for SQL Server Mobile.

Top

Protected Properties

  Name Description
Protected property Supported by the .NET Compact Framework DbConnection  Gets or sets the DbConnection used by this DbCommand.(Inherited from DbCommand.)
Protected property Supported by the .NET Compact Framework DbParameterCollection  Gets the collection of DbParameter objects.(Inherited from DbCommand.)
Protected property Supported by the .NET Compact Framework DbTransaction  Gets or sets the DbTransaction within which this DbCommand object executes.(Inherited from DbCommand.)
Protected property Supported by the .NET Compact Framework Events  Gets the list of event handlers that are attached to this Component.(Inherited from Component.)

Top

Public Methods

(see also Protected Methods )

  Name Description
Public method Supported by the .NET Compact Framework Cancel Overridden. Attempts to cancel the execution of a SqlCeCommand.
Public method Supported by the .NET Compact Framework CreateParameter Creates a new instance of a SqlCeParameter object.
Public method Supported by the .NET Compact Framework Dispose  Overloaded. Releases the resources used by the Component. (Inherited from Component.)
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 ExecuteNonQuery Overridden. Executes an SQL statement against the SqlCeConnection and returns the number of rows affected.
Public method Supported by the .NET Compact Framework ExecuteReader Overloaded. Sends the CommandText to the Connection and builds a SqlCeDataReader.
Public method Supported by the .NET Compact Framework ExecuteResultSet Overloaded. Sends the CommandText to the Connection and builds a SqlCeResultSet.
Public method Supported by the .NET Compact Framework ExecuteScalar Overridden. Executes the query and returns the first column of the first row in the result set that is returned by the query. Extra columns or rows are ignored.
Public method Supported by the .NET Compact Framework 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.)
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 Prepare Overridden. Creates a prepared (or compiled) version of the command on the data source.
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 SetRange Restricts the set of rows that will be read by the SqlCeDataReader.
Public method Supported by the .NET Compact Framework ToString  Returns a String that represents the current Object. (Inherited from Object.)

Top

Protected Methods

  Name Description
Protected method Supported by the .NET Compact Framework CreateDbParameter  Creates a new instance of a DbParameter object. (Inherited from DbCommand.)
Protected method Supported by the .NET Compact Framework Dispose  Overloaded. Releases the resources used by the Component. (Inherited from Component.)
Protected method Supported by the .NET Compact Framework ExecuteDbDataReader  Executes the command text against the connection. (Inherited from DbCommand.)
Protected method Supported by the .NET Compact Framework Finalize  Releases unmanaged resources and performs other cleanup operations before the Component is reclaimed by garbage collection. (Inherited from Component.)
Protected method Supported by the .NET Compact Framework MemberwiseClone  Creates a shallow copy of the current Object. (Inherited from Object.)

Top

Public Events

  Name Description
Public event Supported by the .NET Compact Framework Disposed  Adds an event handler to listen to the Disposed event on the component.(Inherited from Component.)

Top

Explicit Interface Implementations

  Name Description
Explicit interface implementation Method Supported by the .NET Compact Framework System.Data.IDbCommand.CreateParameter  
Explicit interface implementation Supported by the .NET Compact Framework System.Data.IDbCommand.ExecuteReader Overloaded.  
Explicit interface implementation Method Supported by the .NET Compact Framework System.ICloneable.Clone  
Explicit interface implementation Property Supported by the .NET Compact Framework System.Data.IDbCommand.Connection  
Explicit interface implementation Property Supported by the .NET Compact Framework System.Data.IDbCommand.Parameters  
Explicit interface implementation Property Supported by the .NET Compact Framework System.Data.IDbCommand.Transaction  

Top

See Also

Reference

SqlCeCommand Class
System.Data.SqlServerCe Namespace
SqlCeDataAdapter
SqlCeConnection