Empty fields in databinding

[Savvas]

Hi

I have date/time fields in database access table and i would like to be
able to have the choice to be empty when i click the submit button in
my vb.net form.

In the click event of the submit button i have the following code:
Me.comInsertIC.Parameters("expirydatecoke05lpet"). Value =
Me.txtexpirydatecoke05lpet.Text

comInsertIC is the insert command generated by the adapter.

When I click submit button and the field is an empty string I get the
following exception: String was not recognised as a valid datetime.

What can I do in the case of adding a new record and editing an
existing one?
(I use the comInsertIC for adding and for editing the following code:
Me.BindingContext(Me.datasetAddEditIC.ic).EndCurre ntEdit()
Me.adapter.AddEditIC.Update(Me.datasetAddEditIC.ic )

Thank you
Savvas

[Cor Ligthert [MVP]]

Savvas,

Is the expirydatecoke05lpet a real datetime field on your database server?

Than you need at least CDate(Me.txtexpirydatecoke05lpet.Text)

I hope this helps so far,

Cor

[Savvas]

Hi Cor,
The expirydatecoke05lpet is a datetime field in my database. I have
tried the above but it throws an invalid cast exception.

I still can't enter an empty string.

Thanks again
Savvas

[Cor Ligthert [MVP]]

Savvas,

Have a look in this sample for the use of OleDb parameters.

To set a dbvalue to dbnull you can try "Nothing"

I hope this helps,

Cor

[Cor Ligthert [MVP]]

http://www.windowsformsdatagridhelp....3-eb8b44af0137