DateTimePicker Checked-property question

[Mika M]

Hi!

I have bound DateTimePicker to the DataSet DataTable's field like...

dtpMyDateTime.DataBindings.Add(New Binding("Text", dt, "MyDateTimeField"))

....and ShowCheckBox-property = True

Saving date into database table using DateTimePicker is working fine, but I
assumed when Checked-box is NOT checked then dtpMyDateTime.Value should be
something like "NULL" or DbNull.Value or Nothing, but it's not working like
this way

So how can I choose "not date selected" ie. save NULL into database table
using DateTimePicker?

 

[Earl]

Something like this:

If DTPicker.Checked = True Then
ds.Tables("dt").Rows(0)("SaleDate") = DTPicker.Value
Else
ds.Tables("dt").Rows(0)("SaleDate") = DBNull.Value
End If

 

[Mika M]

Something like this:

If DTPicker.Checked = True Then
ds.Tables("dt").Rows(0)("SaleDate") = DTPicker.Value
Else
ds.Tables("dt").Rows(0)("SaleDate") = DBNull.Value
End If

Thanks Earl!

Yes I quessed and made this kind of solution too, but was wondering is this
the right one to do - but it seems to work like this way anyway.