SACommand members

Public constructors
Member name Description

SACommand constructors

Initializes a new instance of the SACommand class.

Public properties
Member name Description

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 name Description

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