DateTime value null 1

[ChewDoggie]

G'morning,

I have a SQL field "TermDate" of type "date" and the value of which can be null.

I have an object called Assoc that has a TermDate property of type DateTime. When I atempt to load the object with the values from the DB, it barfs when it encounters the DB's null value in the date field.

I thought about setting the TermDate Property to type string, but that involves all sorts of converting to DateTime and then back to a string again all over the place.

Can anyone give some advice about how to handle this?

Thanks!

Chew

10% of your life is what happens to you. 90% of your life is how you deal with it.

 

[jmeckley]

assuming .net 2.0 or higher.

class Assoc
{
   public DateTime? TermDate {get;set;}
}

which is syntax sugar for

class Assoc
{
   public Nullable<DateTime> TermDate {get;set;}
}

when you load the object

var assoc = new Assoc();
if(row["TermDate"] == DbNull.Value)
{
   assoc.TermDate = null;
}
else
{
   assoc.TermDate = (DateTime)row["TermDate"];
}

you will also find that .net and ms sql DateTime min/max values are different and will cause problems as well. You cannot save DateTime.Min or DateTime.Max to the sql database. you will need to convert the min/max values to/from the database.

Jason Meckley
Programmer
Specialty Bakers, Inc.

faq855-7190

 

[ChewDoggie]

jmeckley,

Thanks for the quick reply and for sharing your knowledge.

It works like a charm !

Chew


10% of your life is what happens to you. 90% of your life is how you deal with it.