Databinding DateTimePicker and zeroing results?

[Kyote]

I'm using a DateTimePicker for date fields in an Access db Membership
app. Some of the date fields are empty, meaning they haven't been
filled out yet, or they cannot be. But when a record is read with
empty fields, their connected DateTimePicker's display the current
date.

Is there any way to have the DateTimePicker show as empty/blank?
---
Kyote

[Michel Posseth [MCP]]

You might investigate my date entry control

wich can handle db nulls and show a empty box and lots and loots more (
investigate the property`s of the control )

http://www.vbdotnetcoder.com/Downloa.../dateentry.zip

i wrote this control for the company i work for , for simple date entry
while still providing data binding ( the controls takes any entry that is
valid for cdate , 1-1 , 1 jan etc etc etc )
it comes with a sample project and full sourcecode.

regards

Michel Posseth

"Kyote" <ky********@nospamhotmail.comschreef in bericht
news:cu********************************@4ax.com...

I'm using a DateTimePicker for date fields in an Access db Membership
app. Some of the date fields are empty, meaning they haven't been
filled out yet, or they cannot be. But when a record is read with
empty fields, their connected DateTimePicker's display the current
date.

Is there any way to have the DateTimePicker show as empty/blank?
---
Kyote

[D2]

On May 5, 9:47 pm, Kyote <[e-mail]:

I'm using a DateTimePicker for date fields in an Access db Membership
app. Some of the date fields are empty, meaning they haven't been
filled out yet, or they cannot be. But when a record is read with
empty fields, their connected DateTimePicker's display the current
date.

Is there any way to have the DateTimePicker show as empty/blank?
---
Kyote

While binding the control; you can handle the Parse and Format events
of the binding object. In your event handlers, your can set a
different value(default value when database has null). Right now i
dont have the sample code, you can find good samples at msdn.

[Michel Posseth [MCP]]

Yes ,,

But afaik you can`t set the control to a empty value when the db value
is a dbnull
"D2" <dh*****@yahoo.comschreef in bericht
news:11**********************@y5g2000hsa.googlegro ups.com...

On May 5, 9:47 pm, Kyote <[e-mail]:

>I'm using a DateTimePicker for date fields in an Access db Membership
app. Some of the date fields are empty, meaning they haven't been
filled out yet, or they cannot be. But when a record is read with
empty fields, their connected DateTimePicker's display the current
date.

Is there any way to have the DateTimePicker show as empty/blank?
---
Kyote

While binding the control; you can handle the Parse and Format events
of the binding object. In your event handlers, your can set a
different value(default value when database has null). Right now i
dont have the sample code, you can find good samples at msdn.

[D2]

On May 6, 12:46 pm, "Michel Posseth [MCP]" <[e-mail]:

Yes ,,

But afaik you can`t set the control to a empty value when the db value
is a dbnull

"D2" <[e-mail] in berichtnews:11**********************@y5g2000hsa.go oglegroups.com...

On May 5, 9:47 pm, Kyote <[e-mail]:

I'm using a DateTimePicker for date fields in an Access db Membership
app. Some of the date fields are empty, meaning they haven't been
filled out yet, or they cannot be. But when a record is read with
empty fields, their connected DateTimePicker's display the current
date.

Is there any way to have the DateTimePicker show as empty/blank?
---
Kyote

While binding the control; you can handle the Parse and Format events
of the binding object. In your event handlers, your can set a
different value(default value when database has null). Right now i
dont have the sample code, you can find good samples at msdn.

correct! we usually set a default date/time for display... again when
saving back, check whether user has changed it or not.. if no then we
set null in the db.

[Kyote]

On Sat, 5 May 2007 21:30:44 +0200, "Michel Posseth [MCP]"
<ms****@posseth.comwrote:

>

You might investigate my date entry control

wich can handle db nulls and show a empty box and lots and loots more (
investigate the property`s of the control )

http://www.vbdotnetcoder.com/Downloa.../dateentry.zip

i wrote this control for the company i work for , for simple date entry
while still providing data binding ( the controls takes any entry that is
valid for cdate , 1-1 , 1 jan etc etc etc )
it comes with a sample project and full sourcecode.

Thank you Michael. I just downloaded it and will look at the sample
project in a few minutes. From your reply to D2 I think you understand
exactly what I'm trying to do and that this will indeed solve my
problems.

>
regards

Michel Posseth

---
Kyote

[Jay Parzych]

On May 6, 12:46 pm, "Michel Posseth [MCP]" <[e-mail]:

>

>Yes ,,

But afaik you can`t set the control to a empty value when the db
value is a dbnull

"D2" <[e-mail] in
berichtnews:11**********************@y5g2000hsa.g ooglegroups.com...

>>On May 5, 9:47 pm, Kyote <[e-mail]:

I'm using a DateTimePicker for date fields in an Access db
Membership app. Some of the date fields are empty, meaning they
haven't been filled out yet, or they cannot be. But when a record
is read with empty fields, their connected DateTimePicker's display
the current date.

Is there any way to have the DateTimePicker show as empty/blank?
---
Kyote
While binding the control; you can handle the Parse and Format
events of the binding object. In your event handlers, your can set a
different value(default value when database has null). Right now i
dont have the sample code, you can find good samples at msdn.

correct! we usually set a default date/time for display... again when
saving back, check whether user has changed it or not.. if no then we
set null in the db.

this works:

http://www.codeproject.com/cs/miscct...TimePicker.asp

you can customize your null value. for example, i have lots of time columns
that are set later. if null, they say Click To Set. in the click event,
i set the value to the current time.