DateTimePicker and Null values from database

[Spajder]

Hi,

I'm having problem with DateTimePicker control in my project. My controls on winform are connected with table in database with Entity Framework model (i'm using BindingSource and BindingNavigator). All data from my table are shown properly, but DateTimePicker control makes me a real headache. Why? Because table has column with dates and null values. So, when I have a record with null date value, my DateTimePicker shows me todays date. Or when I'm navigating through my database (movefirst, movenext, etc), it just doesn't show correct values for records with null values.

I am able to detect null value, if I put my bindingsource to DateTimePicker.Tag property instead to DateTimePicker.Value. But how should I now show my blank tag values and date values properly in DateTimePicker.Value??? I realy need some good example.

Please help in thank in advance

[jmcilhinney]

The DateTimePicker has ShowCheckBox and Checked properties to help with this. Set ShowCheckBox to true to display a check box in the control. You can then set Checked to True for a value and false for null.