AseCommand Class

Represents commands performed on the Adaptive Server and encapsulates either dynamic SQL statements or stored procedures.

Component

IDbCommand, IDisposable

• AseCommand Constructors
  Initializes an AseCommand object.
• Cancel Method
  Cancels the execution of an AseCommand object.
• CommandText Property
  The text of a SQL statement or stored procedure.
• CommandTimeout Property
  The wait time in seconds before terminating an attempt to execute a command and generating an error.
• CommandType Property
  The type of command represented by an AseCommand.
• Connection Property
  The connection object to which the AseCommand object applies.
• CreateParameter Method
  Provides an AseParameter object for supplying parameters to AseCommand objects.
• ExecuteNonQuery Method
  Executes a statement that does not return a result set, such as an Insert, Update, Delete, or a data definition statement.
• ExecuteReader Method
  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.
• ExecuteXmlReader Method
  Executes a SQL statement with a valid FOR XML clause, that returns a result set. ExecuteXmlReader can also be called with a statement that returns one text column that contains XML.
• NamedParameters
  This property governs the default behavior of the AseCommand objects associated with this connection.
• Parameters Property
  A collection of parameters for the current statement. Use the @name parameter or question marks in the CommandText to indicate parameters.
• Prepare Method
  Prepares or compiles the AseCommand on the data source.
• Transaction Property
  Associates the current command with a transaction.
• UpdatedRowSource Property
  Command results that are applied to the DataRow when used by the Update method of the AseDataAdapter.