ASA Programming Guide
Adaptive Server Anywhere .NET Data Provider API Reference
AsaDataAdapter class
An AsaCommand that is used during Fill or FillSchema to obtain a result set from the database for copying into a DataSet.
AsaCommand SelectCommand
Read-write
When SelectCommand is assigned to a previously created AsaCommand, the AsaCommand is not cloned. The SelectCommand maintains a reference to the previously created AsaCommand object.
If the SelectCommand does not return any rows, no tables are added to the DataSet, and no exception is raised.
The SELECT statement can also be specified in the AsaDataAdapter constructor.