Contents Index ExecuteScalar method Prepare method

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

Parameters property


Description 

A collection of parameters for the current statement. Use question marks in the CommandText to indicate parameters.

Syntax 

AsaParameterCollection Parameters

Access 

Read-only

Property Value 

The parameters of the SQL statement or stored procedure. The default value is an empty collection.

Usage 

When CommandType is set to Text, pass parameters using the question mark placeholder. 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 in the command text.

When the parameters in the collection do not match the requirements of the query to be executed, an error may result or an exception may be thrown.

See also 

AsaParameterCollection class


Contents Index ExecuteScalar method Prepare method