Checking for a null DataRow

Question

How would I check for a null datetime value in a DataRow?

The following works with a dataReader.

calEventDTO.endTime = dr.IsDBNull(9) ? null : (DateTime?) dr.GetDateTime(9);

What is the equivalent when checking the following DataRow?

calEventDTO.endTime = (DateTime)row["endTime"];

Sorry for the very newbee question.

Answer 1

calEventDTO.endTime = row["endTime"] != null ? (DateTime)row["endTime"] : null;

or even better

calEventDTO.endTime = row["endTime"] as DateTime;

PS. I'm assuming you are using C#, since you have not given any details about the language.

Answer 2

Use Convert.IsDBNull:

calEventDTO.endTime = (DateTime?) (Convert.IsDBNull(row["endTime"]) ? null : row["endTime"]);