Hi All,

I am trying to get date values from my SQL Server 2000 database. One of the values may be null, this is valid because until a transaction gets processed this value is null. I am using a strongly typed dataset, and it won't return anything because the ctype function fails. I am even trying to test for dbnull in the strongly typed dataset class and return January 1, 0001 if the value is dbnull. However, I keep getting an exception thrown when attempting to test for DBNull. Should I be setting the date value to January 1, 0001 when I add the record to avoid null values?

If anyone has some insight on this problem, I would greatly appreciate any suggestions.

Thanks in advance,

Rodney Hall