ASA Programming Guide
  Adaptive Server Anywhere .NET Data Provider API Reference
    AsaCommand class

CommandType property

Description 

The type of command represented by an AsaCommand.

Syntax 

CommandType CommandType

Access 

Read-write

Implements 

IDbCommand.CommandType

Usage 

Supported command types are as follows:

• CommandType.StoredProcedure    When you specify this CommandType, the command text must be the name of a stored procedure and you must supply any arguments as AsaParameter objects.

• CommandType.Text    This is the default value.

When the CommandType property is set to StoredProcedure, the CommandText property should be set to the name of the stored procedure. The command executes this stored procedure when you call one of the Execute methods.

Use a question mark (?) placeholder to pass parameters. For example:

SELECT * FROM Customers WHERE CustomerID = ?

The order in which AsaParameter objects are added to the AsaParameterCollection must directly correspond to the position of the question mark placeholder for the parameter.