Chriz L

Chriz L

  • NA
  • 220
  • 51.1k

Object cannot be cast from DBNull to other types (Date)

Sep 30 2015 2:44 AM
Hello,
 
I retrieve data from db through dataset as following:
birthdate.Text = Convert.ToDateTime(ds.Tables[0].Rows[0]["BirthDate"]).ToString("dd/MM/yyyy");
 
My problem is when the BirthDate is null I get the following exception   "Object cannot be cast from DBNull to other types."
 
I tried:
if (String.IsNullOrEmpty(Convert.ToDateTime(ds.Tables[0].Rows[0]["BirthDate"]).ToString("dd/MM/yyyy").Trim()))
birthdate.Text = null;
else
birthdate.Text = Convert.ToDateTime(ds.Tables[0].Rows[0]["BirthDate"]).ToString("dd/MM/yyyy");
 
but I'm still getting the exception. 
 
Any suggestions?
 
Thank you in advance. 

Answers (11)