How To Set Date Field back to NULL

  • Thread starter Thread starter Michael D. Murphy
  • Start date Start date
M

Michael D. Murphy

Hi,
On my webform is a DOB text box. If the user wants to clear out the field,
how do I write a NULL back into the SQL Server Database field.
Thanks,
MDM
 
By using SqlCommand like "UPDATE Table SET field = null WHERE ID=something"
or by inserting a DBNull.Value into DataTable and use adapter.Update (table)
method.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Table Field Set To Not Allow Nulls 1
inserting Null into date field insteadof "Jan 1 1900" 8
Binding DateTimePicker 4
Checking for Nulls 2
Inserting dates into SQL Server DB 11
Pass DATE NULL to Stored Procedure. 2
Auto Increment Field or Identity Field In MS SQL Server 0
Problems setting database field to null 2

Back
Top