Error: Object cannot be cast from DBNull to other types.


Error: Object cannot be cast from DBNull to other types.

Description: An invalid cast exception, when trying to convert a nonexistent value of table column to other types.

Solution: Use DBNull.Value to validate the column having a valid value or not.


if (!DBNull.Value.Equals(row[FirstName]))
{
  return Convert.ToString(row[FirstName]);
}

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s