HOW DO I: Insert Nulls Into SQL DateTime Field Stored In SQL DB From A Web UI Textbox

I’m looking for feedback on the Best/Right way to Insert nulls into SQL dateTime field in SQL DB from a web UI textbox.

 

 
Option 1:    
Presently implemented:

 
Dim dtFollowUpDate = IIf(dtDateFollowUp.Text = "", System.Data.SqlTypes.SqlDateTime.Null, dtDateFollowUp.Text)


Although ithis does what is needed it generates the following inner exception

 


ParamValue    {System.Data.SqlTypes.SqlDateTime} Object
[System.Data.SqlTypes.SqlDateTime] {System.Data.SqlTypes.SqlDateTime}            System.Data.SqlTypes.SqlDateTime
DayTicks  


<error: an exception of type: {System.Data.SqlTypes.SqlNullValueException} occurred>            Integer IsNull   True     Boolean

 


Option 2:


Dim dtFollowUpDate = IIf(dtDateFollowUp.Text = "", System.DBNull.Value, dtDateFollowUp.Text)


 
No exceptions, no problems that I have seen yet.

 


Option 3:


Dim dtNull As System.Data.SqlTypes.INullable


Dim dtFollowUpDate = IIf(dtDateFollowUp.Text = "", dtNull, dtDateFollowUp.Text)


 
No exceptions, no problems that I have seen yet.

 

Any advice would be greatly appreciated! 

 

Thanks

 

Craig

CTARP2