How to solve Error " System.InvalidCastException: Object cannot be cast from DBNull to other types."

Here i want to cast ToDateTime() into ToShortDateString().
During casting required column value is null. Then i got problem of DBNull  as below:

System.InvalidCastException: Object cannot be cast from DBNull to other types.

To solve this problem i follow the below code for casting the Date into ToShortDate.

Here dtEmp refers to Datatable.

Code is as follows:

                if (dtEmp.Rows[0]["Anniversary_Date"] != DBNull.Value)                {                    txtAnniversaryDate.Text = Convert.ToDateTime(dtEmp.Rows[0]["Anniversary_Date"]).ToShortDateString();                }

OR

                txtAnniversaryDate.Text = dtEmp.Rows[0]["Anniversary_Date"] != DBNull.Value ? Convert.ToDateTime(dtEmp.Rows[0]["Anniversary_Date"]).ToShortDateString() : "";

Hence problem is solved.

• Tweet
• Share
• Share
• Share
• Share

About Admin

Beginner School is optimized for learning. This is useful for getting basic knowledge with easiest way. Tutorials, examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content. With the help of other reference book and website, the motive to provide you easiest way to understand the coding, technology and other things.....

Related Post