SACommand class

A SQL statement or stored procedure that is executed against a SQL Anywhere database.

Visual Basic syntax

Public NotInheritable Class SACommand
    Inherits System.Data.Common.DbCommand
    Implements System.ICloneable

C# syntax

public sealed class SACommand : 
    System.Data.Common.DbCommand, 
    System.ICloneable

Base classes

Members

All members of SACommand class, including all inherited members.

Name	Description
SACommand constructor	Initializes an SACommand object.
BeginExecuteNonQuery method	Initiates the asynchronous execution of a SQL statement or stored procedure that is described by this SACommand.
BeginExecuteReader method	Initiates the asynchronous execution of a SQL statement or stored procedure that is described by this SACommand, and retrieves one or more result sets from the database server.
Cancel method	Cancels the execution of an SACommand object.
CreateParameter method	Provides an SAParameter object for supplying parameters to SACommand objects.
EndExecuteNonQuery method	Finishes asynchronous execution of a SQL statement or stored procedure.
EndExecuteReader method	Finishes asynchronous execution of a SQL statement or stored procedure, returning the requested SADataReader.
ExecuteDbDataReader method (Inherited from System.Data.Common.DbCommand)	Executes the command text against the connection.
ExecuteNonQuery method	Executes a statement that does not return a result set, such as an INSERT, UPDATE, DELETE, or data definition statement.
ExecuteReader method	Executes a SQL statement that returns a result set.
ExecuteScalar method	Executes a statement that returns a single value.
Prepare method	Prepares or compiles the SACommand on the data source.
ResetCommandTimeout method	Resets the CommandTimeout property to its default value of 30 seconds.
CommandText property	Gets or sets the text of a SQL statement or stored procedure.
CommandTimeout property	This feature is not supported by the SQL Anywhere .NET Data Provider.
CommandType property	Gets or sets the type of command represented by an SACommand.
Connection property	Gets or sets the connection object to which the SACommand object applies.
DesignTimeVisible property	Gets or sets a value that indicates if the SACommand should be visible in a Windows Form Designer control.
Parameters property	A collection of parameters for the current statement.
Transaction property	Specifies the SATransaction object in which the SACommand executes.
UpdatedRowSource property	Gets or sets how command results are applied to the DataRow when used by the Update method of the SADataAdapter.

Remarks

SACommand constructor
BeginExecuteNonQuery method
BeginExecuteReader method
Cancel method
CreateParameter method
EndExecuteNonQuery method
EndExecuteReader method
ExecuteNonQuery method
ExecuteReader method
ExecuteScalar method
Prepare method
ResetCommandTimeout method
CommandText property
CommandTimeout property
CommandType property
Connection property
DesignTimeVisible property
Parameters property
Transaction property
UpdatedRowSource property

Discuss this page in DocCommentXchange.