Unable to store empty/null date in SQL Sever 2000 date/time field via VB.Net Form

  • Thread starter Thread starter Henry
  • Start date Start date
H

Henry

I have built a vb.net form that contains a text box that is used to
store a date field that is input by the user. The form updates work fine
when the textbox is populated with a date. However, when the date field
is set to empty/nothing by the user (which is a valid condition), the
update fails e.g. (Cast from type 'DBNull' to type 'String' is not
valid)

I’ve tried setting the form date field to vbnull, dbnull.value, “ “ ,
etc. with no luck.

Any ideas on how I can resolve this are much appreciated.
 
* Henry said:
I have built a vb.net form that contains a text box that is used to
store a date field that is input by the user. The form updates work fine
when the textbox is populated with a date. However, when the date field
is set to empty/nothing by the user (which is a valid condition), the
update fails e.g. (Cast from type 'DBNull' to type 'String' is not
valid)
Click to expand...

\\\
If ... Is DBNull.Value Then
...
Else
... = ...
End If
///
 
Back
Top