Checking for boolean DBNull

[G Dean Blake]

I read in an earlier post that this would work:

If Not myrow.DeletedByUser Is DBNull.Value Then

But it gets a diagnostic if DeletedByUser is a boolean. How can I check to
see if a boolean is null without getting an exception?

(I know it's stupid to make a boolean null ok but I didn't design this
database)

Thanks,
G

 

[Ken Cox [Microsoft MVP]]

Wouldn't you test whether it is null first using IsDBNull and if it is
something, look at the actual value?

Here's the method:

Convert.IsDBNull Method
Returns an indication whether the specified object is of type DBNull.

http://msdn.microsoft.com/library/d...html/frlrfsystemconvertclassisdbnulltopic.asp