SqlCeCommand Members

SqlCeCommand overview

Public Constructors

public constructorSqlCeCommand Constructor

Supported only by the .NET Compact Framework.

Overloaded. Initializes a new instance of the SqlCeCommand class.

Public Properties

public propertyCommandText

Supported only by the .NET Compact Framework.

Gets or sets an SQL statement to execute at the data source.
public propertyCommandTimeout

Supported only by the .NET Compact Framework.

Gets or sets the wait time before terminating the attempt to execute a command and generating an error.
public propertyCommandType

Supported only by the .NET Compact Framework.

Gets or sets a value indicating how the CommandText property is interpreted.
public propertyConnection

Supported only by the .NET Compact Framework.

Gets or sets the SqlCeConnection used by this instance of the SqlCeCommand.
public propertyIndexName

Supported only by the .NET Compact Framework.

Specifies the index to be opened.
public propertyParameters

Supported only by the .NET Compact Framework.

Gets the SqlCeParameterCollection.
public propertyTransaction

Supported only by the .NET Compact Framework.

Gets or sets the transaction in which the SqlCeCommand executes.
public propertyUpdatedRowSource

Supported only by the .NET Compact Framework.

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 CE.

Public Methods

public methodCancel

Supported only by the .NET Compact Framework.

Attempts to cancel the execution of a SqlCeCommand.
public methodCreateObjRef (inherited from MarshalByRefObject) Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object.
public methodCreateParameter

Supported only by the .NET Compact Framework.

Creates a new instance of a SqlCeParameter object.
public methodDispose

Supported only by the .NET Compact Framework.

Releases the unmanaged resources used by the SqlCeCommand.
public methodEquals (inherited from Object)

Supported only by the .NET Compact Framework.

Overloaded. Determines whether two Object instances are equal.
public methodExecuteNonQuery

Supported only by the .NET Compact Framework.

Executes an SQL statement against the SqlCeConnection and returns the number of rows affected.
public methodExecuteReader

Supported only by the .NET Compact Framework.

Overloaded. Sends the CommandText to the Connection and builds a SqlCeDataReader.
public methodExecuteScalar

Supported only by the .NET Compact Framework.

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 methodGetHashCode (inherited from Object)

Supported only by the .NET Compact Framework.

Serves as a hash function for a particular type, suitable for use in hashing algorithms and data structures like a hash table.
public methodGetLifetimeService (inherited from MarshalByRefObject) Retrieves the current lifetime service object that controls the lifetime policy for this instance.
public methodGetType (inherited from Object)

Supported only by the .NET Compact Framework.

Gets the Type of the current instance.
public methodInitializeLifetimeService (inherited from MarshalByRefObject) Obtains a lifetime service object to control the lifetime policy for this instance.
public methodPrepare

Supported only by the .NET Compact Framework.

Creates a prepared (or compiled) version of the command on the data source.
public methodSetRange

Supported only by the .NET Compact Framework.

Restricts the set of rows that will be read by the SqlCeDataReader.
public methodToString (inherited from Object)

Supported only by the .NET Compact Framework.

Returns a String that represents the current Object.

Protected Methods

protected methodFinalize

Supported only by the .NET Compact Framework.

Overridden.

In C# and C++, finalizers are expressed using destructor syntax.

protected methodMemberwiseClone (inherited from Object)

Supported only by the .NET Compact Framework.

Creates a shallow copy of the current Object.

See Also

SqlCeCommand Class | System.Data.SqlServerCe Namespace

Syntax based on .NET Framework version 1.1.
Documentation version 1.1.1.

Send comments on this topic.

© Microsoft Corporation. All rights reserved.