Executes a SQL SELECT statement and returns the result set.

Syntax

Visual Basic
Public Function ExecuteReader() As ULDataReader

C#
public ULDataReader ExecuteReader();

Return value

The result set as a ULDataReader object.

Remarks

The statement is the current ULCommand object, with the ULCommand.CommandText and any ULCommand.Parameters as required. The ULDataReader object is a read-only result set. For editable result sets, use ULCommand.ExecuteResultSet(), 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 ULDataReader.

SELECT statements are marked as read-only by default for performance reasons. If the query is going to be used to make updates, the statement must end with " FOR UPDATE".

This is the strongly-typed version of System.Data.IDbCommand.ExecuteReader() and System.Data.Common.DbCommand.ExecuteReader().

See also

• ULCommand class
• ULCommand members
• ExecuteReader methods
• ExecuteReader(CommandBehavior) method
• CommandText property
• Parameters property
• ULDataReader class
• ExecuteResultSet() method
• ExecuteTable() method
• ULDataAdapter class
• CommandType property
•  CommandType.TableDirect
• ExecuteTable() method
• ULTable class
• ULDataReader class
•  IDbCommand.ExecuteReader
•  DbCommand.ExecuteReader
• Connection property
• Transaction property