Handle null DateTime in SQLDataReader

Marius Vasile

In the table, DateTime field DataTestSSM is not null. When I try to get data from reader and handle the null value is not working. I tried with

txtDataTest.Text = rdr["DataTestSSM"] == DBNull.Value ? "-" : ((DateTime)(rdr["DataTestSSM"]).ToString("dd-MM-yyyy"));

What am I doing wrong?

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Accepted answer

You can correct the same with the following code

txtDataTest.Text = rdr["DataTestSSM"] == DBNull.Value ? "-" : ((DateTime)rdr["DataTestSSM"]).ToString("dd-MM-yyyy");