Home / Questions / 7765
Accepted
Juan Manuel Palacios
Asked: 2020-04-15 07:20:06 +0800 CST 2020-04-15 07:20:06 +0800 CST

How can I validate if a field of type date has a value or is null?

  • 772

I am bringing several records from a database to a database datatableand I have 4 fields that are of type date. At least one of them could bring a value NULLand when linking the field with a control datetimepickerit gives me an error not finding a valid value.

How could I pre-validate the field before assigning it to the control? I have tried comparing the valuefield with NULLbut it has not worked.

if (campoFecha != null)

The Date field already has the value fetched by it datatableand has been declared asdatetime

c#

1 Answers

  1. Best Answer

    You have to use the DbNull.Valueto validate if it is null from the db

    if (row["nombrecampo"] != DBNull.Value){
   DateTimePicker1.Value = Conver.ToDateTime(row["nombrecampo"]);
}
    • 2