The Infamous DateTimePicker

[Earl]

I have what I consider to be an unusual issue. In the past, I've not used
data-binding with the DTPs. So I'm finding some of the old issues raising
their ugly heads in a new fashion.

First a caveat: All other controls and data work properly on this form.
Updates, deletes, inserts, all as advertised. The DTPs are bound to
smalldatetime columns in the database. The bindingsource is bound to the
table, the controls to the bindingsource.

The DTPs are set up as follows:
ShowCheckBox = True
Checked = True
Format = Short

My understanding of the DTP in the past has been that an unchecked control
indicates a null. In the past, when I manually saved the values from the
DTPs, I could save a null back to the database. But now, when I uncheck a
DTP and save, the originally saved date remains in the database. If I change
the value in the DTP (even if unchecked), the value in the database changes.

So what gives with the binding? How in the world to null a value from the
DTP when it is bound? Finally, who created this godforsaken control!?

 

[Eric Moreau]

see if an article I have written can answer your question :
http://www.emoreau.com/Entries/Articles/2005/01/The-DateTimePicker-control.aspx

--


HTH

Éric Moreau, MCSD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
S2i web inc. (www.s2i.com)
http://emoreau.s2i.com/

 

[Earl]

Thanks Eric, very nice article, and certainly on the right track to what I'm
trying to do. I can see how you would do that manually binding to a dataset,
but how would you handle the situation where the control is bound to the
bindingsource (with the datasource of the bindingsource being the strongly
typed dataset)? It almost looks as if the DTP has to be unbound from the
bindingsource and manually bound to the strongly typed dataset (which
doesn't work very well because a datagridview is also bound to the
bindingsource, keeping all in synch)

 

[Earl]

I worked that out by using the Value property -- with no need to add another
binding nor make changes to the BindingSource. Excellent resolution to a
tough annoying issue. Thanks much.

 

[Guest]

Earl, so what did you do in order to resolve your problem?