Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » UltraLite - .NET Programming » UltraLite .NET 1.0 API Reference » ULCommand class

ULCommand class Next Page

ULCommand members


Public constructors
Member nameDescription
ULCommand constructor

Initializes a ULCommand object.

ULCommand constructor

Initializes a ULCommand object with the specified command text.

ULCommand constructor

Initializes a ULCommand object with the specified command text and connection.

ULCommand constructor

Initializes a ULCommand object with the specified command text, connection, and transaction.

Public properties
Member nameDescription
CommandText property

Specifies the text of the SQL statement or the name of the table when the ULCommand.CommandType is System.Data.CommandType.TableDirect. For parameterized statements, use a question mark (?) placeholder to pass parameters.

CommandTimeout property

This feature is not supported by UltraLite.NET.

CommandType property

Specifies the type of command to be executed.

Connection property

The connection object on which to execute the ULCommand object.

DesignTimeVisible property

Indicates if the ULCommand should be visible in a customized Windows Form Designer control.

IndexName property

UL Ext.: Specifies the name of the index to open (sort) the table with when the ULCommand.CommandType is System.Data.CommandType.TableDirect.

Parameters property

Specifies the parameters for the current statement.

Plan property

UL Ext.: Returns the access plan UltraLite.NET uses to execute a query. This property is intended primarily for use during development.

Transaction property

Specifies the ULTransaction in which the ULCommand executes.

UpdatedRowSource property

Specifies how command results are applied to the DataRow when used by the Update method of the ULDataAdapter.

Public methods
Member nameDescription
Cancel method

This method is not supported in UltraLite.NET.

CreateParameter method

Provides a ULParameter object for supplying parameters to ULCommand objects.

ExecuteNonQuery method

Executes a statement that does not return a result set, such as a SQL INSERT, DELETE, or UPDATE statement.

ExecuteReader method

Executes a SQL SELECT statement and returns the result set.

ExecuteReader method

Executes a SQL SELECT statement with the specified command behavior and returns the result set.

ExecuteResultSet method

UL Ext.: Executes a SQL SELECT statement and returns the result set as a ULResultSet.

ExecuteResultSet method

UL Ext.: Executes a SQL SELECT statement with the specified command behavior and returns the result set as a ULResultSet.

ExecuteScalar method

Executes a SQL SELECT statement and returns a single value.

ExecuteTable method

UL Ext.: Retrieves in a ULTable a database table for direct manipulation. The ULCommand.CommandText is interpreted as the name of the table and ULCommand.IndexName can be used to specify a table sorting order.

ExecuteTable method

UL Ext.: Retrieves, with the specified command behavior, a database table for direct manipulation. The ULCommand.CommandText is interpreted as the name of the table and ULCommand.IndexName can be used to specify a table sorting order.

Prepare method

Pre-compiles and stores the SQL statement of this command.