TypeOf vs IsDBNull

[Anonymous]

Which of the following codes is recommended?
Is there any difference between them?


If TypeOf dr("colname") Is DBNull Then
' Do work
End If


If IsDBNull(dr("colname")) Then
' Do work
EndIf

 

[Miha Markic [MVP C#]]

Hi,

I think the later checks also for Nothing and not only DBNull.

 

[Scott M.]

....or:

If "colname" = DBNull.value Then
' Do work
End If

They will all work, but since you are checking for a null value, using
DBNull.value or IsDBNull I think is more direct.

 

[tperovic]

I use the DataRow.IsNull method:

If dr.IsNull("colname") Then
' column is null
Endif

TP