DateTimePicker and null

[codemech]

I have a SQL field, "PurchaseDate DateTime Null", where the date is optional.

Is it possible to set a DateTimePicker on a Windows form to a null value?

I am starting to think that if you need null date values on your Windows form then the DateTimePicker control is not the correct control to use.

Thanks,
Codemech

 

[chiph]

DateTimes don't handle DBNull at all. Usually what I do is when I see a null, I change the date value to DateTime.MinValue, and the reverse when writing the date back to the database (if mydate == DateTime.MinValue, write a null).

Chip H.


____________________________________________________________________
Click here to learn Ways to help with Tsunami Relief
If you want to get the best response to a question, please read FAQ222-2244 first

 

[codemech]

Thans for the feedback.

~~ C