ExecuteDataReader Method

Member of ISSelectQueryBuilder
Used in sample: Basic Query with Security Filters
This member is for System Use Only and should NOT be used.
Obsolete. ALTERNATE: Use ExecuteDisconnectedDataReader instead.
Execute Select Query and return a DataReader. Only a single connected DataReader can be open at any one time on most databases hence the option to use a disconnected reader based upon a DataTable.

If called from a Script or external application, a disconnected DataTable will always be assumed

Syntax

ISSelectQueryBuilder.ExecuteDataReader(dataReader, [useDisconnectedDataTable], [disconnectedRowCount], [timeoutSeconds])

Parameters

NameTypeOptionalByRefDescription
dataReader IDataReader ByRef The DataReader object to create.
useDisconnectedDataTable Boolean Optional True to create a DataTable and open a DataReader based on this. Since only one connected DataReader is allowed to be open at one time for most databases, a disconnected DataReader should be used if there is any chance that there is already a connected DataReader open. If omitted, a value of False is assumed.
disconnectedRowCount Integer Optional ByRef When using a disconnected DataTable, this will be set to a count of the rows retrieved. If omitted, a value of 0 is assumed.
timeoutSeconds Integer Optional The number of seconds after which a database connection timeout will occur or -1 to use the default timeout. If omitted, a value of -1 is assumed.

Return Value

Boolean

A Boolean value indicating success.

Member of:
ISSelectQueryBuilder
Namespace:
Intersoft.ISSupport6
Assembly:
ISSupport6, Version=6.0.3
Target Framework:
.NET 9.0