Getting Bit value from datareader.

DittoToo · July 11th, 2003, 10:27 AM

I have this function:

Code:

Public Function CheckNullReturnBolean(ByRef oRead as SqlDataReader, ByVal i as Short) as Boolean

    If oRead.IsDBNull(i) then
        Return vbNull
    Else
        Return oRead.GetDataType(i)
    End If

End Function

The value in the reader is a bit field. What Get data reader method would I use to pull out this value?

Thanks,

Jerry

sinceresiva · May 25th, 2006, 11:19 AM

You can use the following syntax,

dreaderResults.GetValue(dreaderResults.GetOrdinal( "bitDepositsAllowed"))

Thanks,

Siva