asp.net handle field that has null value 1

[maswien]

I have a piece of code to test if the return column is null:

If Not objDataReader.GetString(2) Is DBNull.Value Then
...

end if

I got error tells me that the cast is not valid!


What's the correct way to test null?


Thanks

 

[JignasuK]

Try using something like below...

If Not IsDBNull(objDataReader.GetString(2)) Then
...
End If

Jignasu

 

[maswien]

It doesn't work eithor, the same error.

Actually the value for objDataReader.GetString(2) is a '' but not a null in the database, in any case above statement shouldn't fail. it's so weird!

 

[RiverGuy]

Instead of objDataReader.GetString(2), use objDataReader.Item(2)