Actions right arrow Actions List right arrow Execute JavaScript right arrow Class List right arrow DataReaderObject

Contains objects and methods to read the results of a query.

Functions

string GetColumnName ( object ordinal )

Gets the name of the column, given the zero-based column ordinal.

Parameters:
ordinal The zero-based column ordinal.
Returns:
The name of the specified column.
object GetValue ( object index )

Gets the value of the specified column ordinal or column name.

Parameters:
index The zero-based column ordinal or the column name.
Returns:
The value of the specified column.
bool Read ( )

Advances the reader to the next record in the result set. The default position of a data reader is before the first record. Therefore, you must call Read to begin accessing data.

Returns:
true if there are more rows; otherwise false.
object ToMatrix ( )

Returns the current results as a two-dimensional array of the form "[row][column]". This method calls DataReaderObject.Read internally.

Returns:
A two-dimensional array containing every record in the result set.
object ToObjects ( )

Returns the current results as an array of objects, each of which contains a set of properties named after the column names. This method calls DataReaderObject.Read internally.

Returns:
An array of objects containing every record in the result set.

Properties

string LastError = ""

If the last action performed by this DataReaderObject caused an error, this object gets a description of it. Otherwise it gets an empty string.

int FieldCount [get]

Gets the number of columns in the current row.

int RecordsAffected [get]

Gets the number of rows changed, inserted, or deleted by execution of the SQL statement.