Binding a datetimepicker control to a date time dataset field does not work 
Author Message
 Binding a datetimepicker control to a date time dataset field does not work

I've tried every which way I can think of to bind a datetimepicker field to
a datatime field in a dataset so that, if the field value is not null in the
dataset it shows the dataset's currently selected record date in the
datetimepicker control. I just can't get it, any time I use any of the
databinding properties for this control I get an error message.

Try a simple test, create a sql table with two fields, an Id and Mydate a
datetime field, use the data form wizard to create a data entry form using
textboxes (not a grid) to create a winform for it, add a
datetimepickercontrol and try to bind it to the mydate field. as soon as you
hit the load button you get error messages.

What am i Doing wrong, this should be simple <GGGGGG>

Thanks for any help.

I sincerely wish Microsoft would remember a very valid axiom, KEEP IT SIMPLE
STOOPID.



Thu, 10 Mar 2005 04:00:18 GMT  
 Binding a datetimepicker control to a date time dataset field does not work
Sorry but my datetimepicker fields bind ok, using the Text binding from the
IDE.

Try it without the wizard it easy enough

Colin


Quote:
> I've tried every which way I can think of to bind a datetimepicker field
to
> a datatime field in a dataset so that, if the field value is not null in
the
> dataset it shows the dataset's currently selected record date in the
> datetimepicker control. I just can't get it, any time I use any of the
> databinding properties for this control I get an error message.

> Try a simple test, create a sql table with two fields, an Id and Mydate a
> datetime field, use the data form wizard to create a data entry form using
> textboxes (not a grid) to create a winform for it, add a
> datetimepickercontrol and try to bind it to the mydate field. as soon as
you
> hit the load button you get error messages.

> What am i Doing wrong, this should be simple <GGGGGG>

> Thanks for any help.

> I sincerely wish Microsoft would remember a very valid axiom, KEEP IT
SIMPLE
> STOOPID.



Thu, 10 Mar 2005 04:25:40 GMT  
 Binding a datetimepicker control to a date time dataset field does not work
Robert,
I don't believe the DateTimePicker control allows Null values. If that
is the case, as soon as you bind the DateTimePicker to a field and
come across a Null value, an error would be thrown.

HTH,
R/mi.

Quote:

> I've tried every which way I can think of to bind a datetimepicker field to
> a datatime field in a dataset so that, if the field value is not null in the
> dataset it shows the dataset's currently selected record date in the
> datetimepicker control. I just can't get it, any time I use any of the
> databinding properties for this control I get an error message.

> Try a simple test, create a sql table with two fields, an Id and Mydate a
> datetime field, use the data form wizard to create a data entry form using
> textboxes (not a grid) to create a winform for it, add a
> datetimepickercontrol and try to bind it to the mydate field. as soon as you
> hit the load button you get error messages.

> What am i Doing wrong, this should be simple <GGGGGG>

> Thanks for any help.

> I sincerely wish Microsoft would remember a very valid axiom, KEEP IT SIMPLE
> STOOPID.



Thu, 10 Mar 2005 21:47:05 GMT  
 Binding a datetimepicker control to a date time dataset field does not work
almost true, the datetime picker defaults to tadys date when it encounters a
null

Colin


Quote:
> Robert,
> I don't believe the DateTimePicker control allows Null values. If that
> is the case, as soon as you bind the DateTimePicker to a field and
> come across a Null value, an error would be thrown.

> HTH,
> R/mi.




Quote:
> > I've tried every which way I can think of to bind a datetimepicker field
to
> > a datatime field in a dataset so that, if the field value is not null in
the
> > dataset it shows the dataset's currently selected record date in the
> > datetimepicker control. I just can't get it, any time I use any of the
> > databinding properties for this control I get an error message.

> > Try a simple test, create a sql table with two fields, an Id and Mydate
a
> > datetime field, use the data form wizard to create a data entry form
using
> > textboxes (not a grid) to create a winform for it, add a
> > datetimepickercontrol and try to bind it to the mydate field. as soon as
you
> > hit the load button you get error messages.

> > What am i Doing wrong, this should be simple <GGGGGG>

> > Thanks for any help.

> > I sincerely wish Microsoft would remember a very valid axiom, KEEP IT
SIMPLE
> > STOOPID.



Fri, 11 Mar 2005 02:10:21 GMT  
 
 [ 4 post ] 

 Relevant Pages 

1. bound masked field to date/time field in access not formatting right

2. ADO with Access Date/Time field not storing the time, just the date

3. Date() not working, time() and Now() do work

4. Matching system date/time with field date/time

5. Trying to bind datetimepicker to SQL table datetime field

6. How to handle Medium Date and General Date in a DateTimePicker control

7. Inconsistent date/time stored in database with bound dtpicker control

8. Findfirst method not working with date fields

9. Form with Date Field Not Working Properly

10. Controls bound to date and numeric fields PROBLEM

11. Date field in a bound Datagrid control

12. Updating Date fields in the database not working (CAPA)

 

 
Powered by phpBB® Forum Software