DataReaderOpen Method

Member of ISDatabaseHandler
Open 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.

Syntax

ISDatabaseHandler.DataReaderOpen(sqlQuery, dataReader, [useDisconnectedDataTable], [disconnectedRowCount], [timeoutSeconds])

Parameters

NameTypeOptionalByRefDescription
sqlQuery String The SQL SELECT query.
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:
ISDatabaseHandler
Namespace:
Intersoft.ISSupport6
Assembly:
ISSupport6, Version=6.0.3
Target Framework:
.NET 9.0