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

ExecuteResultSet method

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

Visual Basic

Overloads Public Function ExecuteResultSet() As ULResultSet

C#

public ULResultSet ExecuteResultSet();

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() or a ULDataAdapter.

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

• ULException class - A SQL error occurred.

•  InvalidOperationException - The command is in an invalid state. Either the ULCommand.Connection is missing or closed, the ULCommand.Transaction value does not match the current transaction state of the connection, or the ULCommand.CommandText is invalid.

• ULCommand class
• ULCommand members
• ExecuteResultSet method
• ULCommand class
• CommandText property
• Parameters property
• CommandType property
•  CommandType.TableDirect
• ULResultSet class
• ULTable class