how to insert null value in date field?

[mails4vijayakumar]

i have a maskedtextbox which will accept only date in the format of "DD-MM-yyyy" no i want to insert this date in my db. i have done this successfully.

Now i want to insert null value in through that maskedtextbox .

please give me a sample code for the above

[amrita]

Check if the textbox is blank then insert System.Data.SqlTypes.SqlDateTime.Null to DB date field.

[mails4vijayakumar]

thanks for ur reply. i am using odbc connection so i need odbc connectivity code

[jmcilhinney]

I would suggest not using a MaskedTextBox. The .NET Framework provides the DateTimePicker for date/time display and input. If you want to support null values, set ShowCheckBox to True and use whether or not it is checked to determine whether to insert a value or not, e.g.

If completedDatePicker.Checked Then
    row("CompletedDate") = completedDatePicker.Value.Date
Else
    row("CompletedDate") = DBNull.Value
End If

You always use DBNull.Value to represent a null value no matter the data type or the provider.

[amrita]

Simply inserting NULL will do the job , I guess.

[jmcilhinney]

Simply inserting NULL will do the job , I guess.

Only if you write it literally into the SQl code, which you shouldn't do. If you're using parameters, as you should, or a DataTable then you must use DBNull.Value.

[johnmarsh]

thank u so much for sharing this