How do I handle a DBNull DateTime field coming from the SQL Server?

Question

I am getting this error when I retrieve a row with a null DataTime field:

'srRow.Closed_Date' threw an exception of type 'System.Data.StrongTypingException'

How do I properly handle these?

How are you pulling down the information? Is it in a data table or a strong typed object? — Aaron, Jul 30 '09 at 16:26

Michael Petrotta · Accepted Answer · 2009-07-30T16:37:10.607

6

You can check for a null value in that column before retrieving the value.

if (!srRow.IsClosed_DateNull())
{
  myDate = srRow.Closed_Date;
}

edited Jul 30 '09 at 16:37

answered Jul 30 '09 at 16:30

Michael Petrotta

+1 Good answer - yours should be the accepted answer, not the IsNull answer – Scott Ivey Jul 30 '09 at 16:35

score 1 · Answer 2 · answered Jul 30 '09 at 16:24

1

There's a reference here.

or possibly, can you modify your query to ensure the results are not null by using the IsNull operator?

Select (IsNull, SomeDateField, GetDate())

answered Jul 30 '09 at 16:24

David

score 0 · Answer 3 · answered Jul 30 '09 at 17:27

0

Assuming you're using .NET, there are SqlTypes that can be used in a situation like this.

answered Jul 30 '09 at 17:27

Tyler

3 Answers3