I'm trying to update a form that has a StartDate and EndDate column. Neither of these are required fields and I can't figure out how to update with a null value. Here's what I have:
Dim prmStart As New SqlParameter("@Date_Start", SqlDbType.SmallDateTime)
If Len(txtStartDate.Text) > 0 Then
prmStart.Value = txtStartDate.Text
prmStart.Value = DBNull.Value
This has to be easy but I'm stuck.
Thanks in advance,