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.

[Lethal]

Try this:

if(dr["Author"] == DBNull.Value) {
    txtAuthor.Name = String.Empty;
}
else {
    txtAuthor.Name = dr["Author"];
}

[Lord_Rat]

Also, isDBNull(avalue)

[EyeTalion]

thanks guys...

I used

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