Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - Programming » SQL Anywhere .NET 2.0 API Reference » SACommand class

SACommand class Next Page

SACommand members


Public constructors
Member nameDescription
SACommand constructors Initializes a new instance of the SACommand class.
Public properties
Member nameDescription
CommandText property Gets or sets the text of a SQL statement or stored procedure.
CommandTimeout property Gets or sets the wait time in seconds before terminating an attempt to execute a command and generating an error.
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. The default is true.
Parameters property A collection of parameters for the current statement. Use question marks in the CommandText to indicate parameters.
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.
Public methods
Member nameDescription
BeginExecuteNonQuery methods Initiates the asynchronous execution of a SQL statement or stored procedure that is described by this SACommand.
BeginExecuteReader methods 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.
ExecuteNonQuery method Executes a statement that does not return a result set, such as an INSERT, UPDATE, DELETE, or data definition statement.
ExecuteReader methods Executes a SQL statement that returns a result set.
ExecuteScalar method Executes a statement that returns a single value. If this method is called on a query that returns multiple rows and columns, only the first column of the first row is returned.
Prepare method Prepares or compiles the SACommand on the data source.
ResetCommandTimeout method Resets the CommandTimeout property to its default value of 30 seconds.
See also