Problem data binding DateTimePicker to object

Bob Bedell · October 26th, 2008, 07:25 PM

Hello,

I'm trying to data bind a DateTimePicker to a property of a custom object, like:

Code:

this.dtpDateTimeField.DataBindings.Add("Value", this._typefield, "DateTimeField");

TypeField is the name of the object. "DateTimeField" is the field I'm binding to.

Then I input some data and do an insert into a Jet database.

I have the default value of the date time field in the object set like:

Code:

private System.DateTime _dateTimeField = DateTime.Now;

so the DateTimePicker has a defult value of todays date when the form loads.
Here's the initializing code from the designer:

[code]
this.dtpDateTimeField.Value = new System.DateTime(2008, 10, 26, 0, 0, 0, 0);

If I actually SELECT a date in the DateTimePicker after the form loads, and then
click a Save button that does the insert, all goes well.

However, if I don't actually click on the DateTimePicker and SELECT a date (but just try
and insert the default value), all goes bad. I get:

OleDbException was unhandled, data type mismatch in criteria expression.

The value isn't null anywhere I can see. There seems to be a genuine DateTime value getting
passed around either way. I've even tried adding my own binding and played with formatting and parsing
events:

Code:

Binding b = new Binding("Value", this._typefield, "DateTimeField", true);
this.dtpDateTimeField.DataBindings.Add(b);
b.Format += new ConvertEventHandler(dtpDateTimeField_Format);
b.Parse += new ConvertEventHandler(dtpDateTimeField_Parse);

but no luck.

Any thoughts.

Bob

Bob Bedell · October 27th, 2008, 06:44 PM

I believe I've figured it out.

"OleDbException was unhandled, data type mismatch in criteria expression" is thrown for the following reason.

1. DateTime.Now returns a TimeOfDay value of something like 19:18:17.4236421 (note the milliseconds).

2. I'm trying to store a System.DateTime in a Jet database, so I'm using an OleDbCommand object.

3. command.Parameters.AddWithValue("@dateTimeField", typeField.DateTimeField) creates an OleDbParameter object of OleDbType DBTimeStamp (my instance field's default value is DateTime.Now).

4. The Problem: DBTimeStamp has no conception of milliseconds. Instead it has a fraction property that represents billionths of a second ranging from 0 to 999,999,999.

5. The Solution: Change DateTime.Now to DateTime.Today. That lops off the time value, and hence the problematic millisecond value.

After changing the default value of my DateTime field to DateTime.Today, I can databind to the DateTimePicker and insert the default value fine.