ExecuteResultSet(CommandBehavior) method

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

Visual Basic syntax

Public Function ExecuteResultSet(
     ByVal cmdBehavior As CommandBehavior
) As ULResultSet

C# syntax

public ULResultSet ExecuteResultSet(CommandBehavior cmdBehavior)

Parameters

cmdBehavior A bitwise combination of System.Data.CommandBehavior flags describing the results of the query and its effect on the connection. UltraLite.NET respects only the System.Data.CommandBehavior.Default, System.Data.CommandBehavior.CloseConnection, and System.Data.CommandBehavior.SchemaOnly flags.

Exceptions

ULException class A SQL error occurred.
InvalidOperationException The command is in an invalid state. Either the ULCommand.Connection value is missing or closed, the ULCommand.Transaction value does not match the current transaction state of the connection, or the ULCommand.CommandText value is invalid.

The statement is the current ULCommand object, with the ULCommand.CommandText value and any ULCommand.Parameters value as required. The ULResultSet object is an editable result set on which you can perform positioned updates and deletes. For fully editable result sets, use the ULCommand.ExecuteTable(CommandBehavior) method or a ULDataAdapter object.

If the ULCommand.CommandType value is System.Data.CommandType.TableDirect, the ExecuteReader method performs a ULCommand.ExecuteTable(CommandBehavior) call and returns a ULTable object downcast as a ULResultSet object.

This method supports positioned updates and deletes with Dynamic SQL.

ExecuteResultSet(CommandBehavior) method

Visual Basic syntax

C# syntax

Parameters

Returns

Exceptions

Remarks

See also