Formview itemupdating newvalues empty
Essently I want to return a NULL data back to the database if the user removes the date.
I know there are many different posts out there referring to NULL dates and SQL but I don't have the option to return the Date Time. Client wants NULL in the field if the date is not filled in or removed from the UI. Value" helps, but here are some possible solutions: File/sd_patel/Enter Null Values For Date Time11222005015742AM/Enter Null Values For Date Thanks, Dim dt As Nullable(Of Date Time) ' validate end date Dim end Date ' check if the value is null or empty If Not String. Values("End Date")) Then ' not null or empty so parse out the string end Date = Date Time. Values("End Date")) End If ' check to see if the enddate is a date object If Not Type Of end Date Is Date Time Then ' not a date object so return a null date to the database e.
The workaround is to subscribe to the Form View Item Updating event and look for string.empty New Values and set those to null instead.
All functions work find except the update with one Date Time column.