test for null

Anyone know how to test for a null value being returned from a database query

i tried the code below but think i had too much beer over the long weekend because it should be easy but i can't locate the middle portion of my brain

Code:

---

If myDataSet.Tables(0).Rows(0).Item("Contact") Is Not System.DBNull Then
            contactTemp = ""
        End If

---

thanks for any help

do a search on the IsDBNull Function

DbNull.Value

You need to understand that DBNull is very different from empty string (""). Numeric fields for example can be DBNull but cannot be "". Also a lot of controls will choke if you are trying to stick datarow fields into them if the field is DBNull, but will work fine if it is "".

Use IsNull function existed in the Rows Obj . Something like this :

VB Code:

If ds.Tables(0).Rows(0).IsNull(0) Then

VB Code:

If myDataSet.Tables(0).Rows(0).Item("Contact")  Is DBNull.Value Then
'you have a null value

Thanks for the help everyone!
nemaroller ... used yours and worked like a charm

:D