1
Answer

Handle null DateTime in SQLDataReader

Marius Vasile

Marius Vasile

Jun 22
506
1

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?

Answers (1)