Object cannot be cast from DBNull to other types. error

Question

I am getting error as

Object cannot be cast from DBNull to other types.

at line

txtdate.Value = Convert.ToDateTime(objPridr2["MST_DATE"]).ToString("dd/MM/yyyy").Trim();

how to resolve this

There are at least 10 duplicates for this same error on the related column on the right. Why you don't search before asking? — Steve, Oct 14 '16 at 06:18

score 6 · Accepted Answer · answered Oct 14 '16 at 06:34

6

txtdate.Value = objPridr2["MST_DATE"] is DBNull ? 0 : Convert.ToDateTime(objPridr2["MST_DATE"]).ToString("dd/MM/yyyy").Trim();

answered Oct 14 '16 at 06:34

Venkat

score 0 · Answer 2 · answered Oct 14 '16 at 06:15

0

Try this way using null checking

if(objPridr2["MST_DATE"] != System.DBNull.Value )
{
    txtdate.Value = Convert.ToDateTime(objPridr2["MST_DATE"]).ToString("dd/MM/yyyy").Trim();
}

answered Oct 14 '16 at 06:15

Mostafiz

2 Answers2