PDA

Click to See Complete Forum and Search --> : db error


EyeTalion
Jan 21st, 2003, 01:52 PM
I have an update page where the user can change data in the db. When I delete data from a textbox and keep it empty, then save to the db, I get this error:

String was not recognized as a valid DateTime.

Is there a way around this?
thanks

Cander
Jan 21st, 2003, 02:07 PM
you cannot have blank values in a DateTime field.

EyeTalion
Jan 21st, 2003, 02:09 PM
in the database it can be null. How do I insert a null value into that field?

mpSmooth
Jan 21st, 2003, 03:41 PM
DbNull.Value