GetBoolean

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

Declaration

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

Parameters

  • index

    The zero-based column index.

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.

See Also: