ExecuteResultSet() method

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

Visual Basic syntax

Public Function ExecuteResultSet() As ULResultSet

C# syntax

public ULResultSet ExecuteResultSet()

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 and any ULCommand.Parameters values 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 method or a ULDataAdapter object.

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

This method supports positioned updates and deletes with Dynamic SQL.

Example

cmd.CommandText = "SELECT id, season, price FROM OurProducts";
ULResultSet rs = cmd.ExecuteResultSet();
while( rs.Read() ) {
    string season = rs.GetString( 1 );
    double price = rs.GetDouble( 2 );
    if( season.Equals( "summer" ) ) {
        rs.UpdateBegin();
        rs.SetDouble( 2, price * .5 );
        rs.Update();
    }
    if( season.Equals( "discontinued" ) ) {
        rs.Delete();
    }
}
rs.Close();

Discuss this page in DocCommentXchange.

ExecuteResultSet() method

Visual Basic syntax

C# syntax

Returns

Exceptions

Remarks

See also

Example