Save Null Value to SQL Table in DateTime Field??

[crjunk]

I have a text box that records a date. If the user enters a date in
the text box, and click on save, the date will be saved in the SQL
table, but if the user does not enter a date in this field and then
clicks save, I reveive the following message:
Cast from string "" to type 'Date' is not valid

The DateTime field in my table has Allow Nulls set to true. How can I
prevent this error from occuring if the user decides not to enter in a
date into the textbox when saving arecord?

Thanks,
C.R.

 

[Guest]

You have to set the value to DBNull.Value instead of '

Tu-Thac

----- crjunk wrote: ----

I have a text box that records a date. If the user enters a date i
the text box, and click on save, the date will be saved in the SQ
table, but if the user does not enter a date in this field and the
clicks save, I reveive the following message
Cast from string "" to type 'Date' is not vali

The DateTime field in my table has Allow Nulls set to true. How can
prevent this error from occuring if the user decides not to enter in
date into the textbox when saving arecord

Thanks
C.R

 

[crjunk]

You have to set the value to DBNull.Value instead of ''

Tu-Thach

I tried using the following code when saving a record but I received
this error message: "Cast from string "" to type 'Date' is not valid"

If eProposalReceived.Text.Trim = "" Then
Row.Item("ProposalReceived") = DBNull.Value
End If

Am I doing something wrong?

Thanks,
C.R.