test for null

[Halon]

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

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

thanks for any help

[Memnoch1207]

do a search on the IsDBNull Function

[EyeTalion]

DbNull.Value

[Slow_Learner]

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 "".

[Pirate]

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

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

[nemaroller]

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

[Halon]

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