null error[RESOLVED]

[EyeTalion]

I'm getting this error when I try to populate my page. The field can be null in the database, so how do I get around this?

Cast from type 'DBNull' to type 'String' is not valid.

[Pirate]

this is how you can handle null values :

Dim MyNull As System.DBNull
 
If mystring Is MyNull Then
'do things
End If

[EyeTalion]

thanks...I used:

If objDataReader("display_start_date") Is DBNull.Value Then
                        txtIntDisStartDate.Text = String.Empty
                    Else
                        txtIntDisStartDate.Text = ("display_start_date")
                    End If