Data bound datetimepicker control with checkbox How to handle Null

[cluelessAnyAdvise]

Hi

I have a dateTimePicker control on a Windows Form (VB.NET),
which is bound to a dataset (database column of date type).

Following properties are set -
editfldName.Checked = False
editfldName.DataBindings.Add(New System.Windows.Forms.Binding("Text", Me.dsName, "tblName.fldName"))
editfldName.ShowCheckBox = True

As I understand it is not possible to set a DateTimePicker to null value (if the DB column has null). So there is no way to blank out the field's text itself. Currently it shows the default date (Date.Now) when dataset column has no date in it. The check box next to it is always checked once the data is loaded on the form.
So there is no visual indication for the users to determine if the value shown is from dataset or default.
So I'd like to see -
checkbox as checked if the value in <editfldName> is the one from dataset column.
checkbox as NOT checked when the value is default value of datetimepicker (ie. Date.Now)

Any suggestions?

Thanks

 

[ThatRickGuy]

Isn't there a AllowNull property on the date time picker?

VB.Net Forum forum796 forum855 ASP.NET Forum
I believe in killer coding ninja monkeys.

 

[cluelessAnyAdvise]

DataGrid Column has AllowNull property. But I don't see one for datetimepicker...