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 | |
|---|---|---|
| SqlCeCommand | Overloaded. Initializes a new instance of the SqlCeCommand class. |
Top
Public Properties
(see also Protected Properties )
| Name | Description | |
|---|---|---|
.gif "cab1zes4.pubproperty(en-us,VS.90).gif") |
CommandText | Overridden. Gets or sets an SQL statement to execute at the data source. |
|
CommandTimeout | Overridden. Gets or sets the wait time before terminating the attempt to execute a command and generating an error. |
|
CommandType | Overridden. Gets or sets a value indicating how the CommandText property is interpreted. |
|
Connection | Gets or sets the SqlCeConnection used by this instance of the SqlCeCommand. |
|
Container | (inherited from Component ) |
|
DesignTimeVisible | Overridden. Get always returns false; set always throws a NotSupportedException. |
|
IndexName | Specifies the index to be opened. |
|
Parameters | Gets the SqlCeParameterCollection. |
|
Site | (inherited from Component ) |
|
Transaction | Gets or sets the transaction in which the SqlCeCommand executes. |
|
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 Compact 3.5 SP1. |
Top
Protected Properties
| Name | Description | |
|---|---|---|
.gif "cab1zes4.protproperty(en-us,VS.90).gif") |
CanRaiseEvents | (inherited from Component ) |
|
DbConnection | (inherited from DbCommand ) |
|
DbParameterCollection | (inherited from DbCommand ) |
|
DbTransaction | (inherited from DbCommand ) |
|
DesignMode | (inherited from Component ) |
|
Events | (inherited from Component ) |
Top
Public Methods
(see also Protected Methods )
| Name | Description | |
|---|---|---|
.gif "cab1zes4.pubmethod(en-us,VS.90).gif") |
Cancel | Overridden. Attempts to cancel the execution of a SqlCeCommand. |
|
CreateObjRef | (inherited from MarshalByRefObject ) |
|
CreateParameter | Creates a new instance of a SqlCeParameter object. |
|
Dispose | Overloaded. (inherited from Component ) |
|
Equals | Overloaded. (inherited from Object ) |
|
ExecuteNonQuery | Overridden. Executes an SQL statement against the SqlCeConnection and returns the number of rows affected. |
|
ExecuteReader | Overloaded. Sends the CommandText to the Connection and builds a SqlCeDataReader. |
|
ExecuteResultSet | Overloaded. Sends the CommandText to the Connection and builds a SqlCeResultSet. |
|
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. |
|
GetHashCode | (inherited from Object ) |
|
GetLifetimeService | (inherited from MarshalByRefObject ) |
|
GetType | (inherited from Object ) |
|
InitializeLifetimeService | (inherited from MarshalByRefObject ) |
|
Prepare | Overridden. Creates a prepared (or compiled) version of the command on the data source. |
.gif "cab1zes4.static(en-us,VS.90).gif") |
ReferenceEquals | (inherited from Object ) |
|
SetRange | Restricts the set of rows that will be read by the SqlCeDataReader. |
|
ToString | (inherited from Component ) |
Top
Protected Methods
| Name | Description | |
|---|---|---|
.gif "cab1zes4.protmethod(en-us,VS.90).gif") |
CreateDbParameter | (inherited from DbCommand ) |
|
Dispose | Overloaded. (inherited from Component ) |
|
ExecuteDbDataReader | (inherited from DbCommand ) |
|
Finalize | (inherited from Component ) |
|
GetService | (inherited from Component ) |
|
MemberwiseClone | Overloaded. (inherited from MarshalByRefObject ) |
Top
Public Events
| Name | Description | |
|---|---|---|
.gif "cab1zes4.pubevent(en-us,VS.90).gif") |
Disposed | (inherited from Component ) |
Top
Explicit Interface Implementations
| Name | Description | |
|---|---|---|
| System.Data.IDbCommand.CreateParameter | (inherited from DbCommand ) | |
| System.Data.IDbCommand.ExecuteReader | Overloaded. (inherited from DbCommand ) | |
| System.ICloneable.Clone | ||
| System.Data.IDbCommand.Connection | (inherited from DbCommand ) | |
| System.Data.IDbCommand.Parameters | (inherited from DbCommand ) | |
| System.Data.IDbCommand.Transaction | (inherited from DbCommand ) |
Top
See Also
Reference
SqlCeCommand Class
System.Data.SqlServerCe Namespace
SqlCeDataAdapter
SqlCeConnection