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

ExecuteResultSet(CommandBehavior) method

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

Visual Basic

Public Function ExecuteResultSet( _
ByVal cmdBehavior As CommandBehavior _
) As ULResultSet

C#

public ULResultSet ExecuteResultSet(
CommandBehavior cmdBehavior
);

• 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.

The result set as a ULResultSet object.

The statement is the current ULCommand object, with the ULCommand.CommandText and any ULCommand.Parameters 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 ULCommand.ExecuteTable(CommandBehavior) or a ULDataAdapter.

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

• ULCommand class
• ULCommand members
• ExecuteResultSet methods
• ExecuteReader() method
• ULResultSet class
• CommandText property
• Parameters property
• ExecuteTable(CommandBehavior) method
• ULDataAdapter class
• CommandType property
•  CommandType.TableDirect
• ExecuteTable(CommandBehavior) method
• ULTable class
•  CommandBehavior
•  CommandBehavior.Default
•  CommandBehavior.CloseConnection
•  CommandBehavior.SchemaOnly
• Connection property
• Transaction property