GetBoolean

This method returns the bool value of the specified numeric column.

Declaration

// C#
public override bool GetBoolean(int index);

Parameters

Return Value

The bool value of the column.

Implements

IDataRecord

Exceptions

InvalidOperationException - The connection is closed, the reader is closed, Read() has not been called, or all rows have been read.

IndexOutOfRangeException - The column index is invalid.

InvalidCastException - The accessor method is invalid for this column type.

Remarks

This method can be called on the BOOLEAN column, any numeric database type column (NUMBER, BINARY_DOUBLE, BINARY_FLOAT, and FLOAT), or any scalar character based column (CHAR, NCHAR, VARCHAR2, NVARCHAR2).
For numeric columns, FALSE is returned if column value is 0; TRUE otherwise.
For scalar character based column (CHAR, NCHAR, VARCHAR2, NVARCHAR2), GetBoolean can be called on Valid String literals.

Valid String literals to represent TRUE and FALSE (case insensitive) are as follows:
- For TRUE, valid string literals are (case insensitive) - true, yes, on, 1, t, y
- For FALSE, valid string literals are (case insensitive) - false, no, off, 0, f, n
If the string literals are anything other than those listed above, then an InvalidCastException will be returned when trying to read the value.
IsDBNull should be called to check for NULL values before calling this method.