dateTime

  • Thread starter Thread starter Hrvoje Voda
  • Start date Start date
H

Hrvoje Voda

How to put a dateTime value back to Null!

I have a table in database in witch I put a dateTime values.
I would like to delete that value so that it becomes null again.

Hrcko
 
you can't set DateTime value to null (you will be able to in the next
version) all you can do is set it to the 'MinValue', 'MaxValue' or an
arbitrary value that you define.

If you want to remove a dateTime from a datagrid when it is shown because
the value is invalid for your accepted range you will have to override the
dataBound event and remvoe the text from the datagrid cell.

HTH

Ollie Riches
 
Using SQL, you can set a date value to NULL. For example:
set SomeDate = null where id = xxx
 
When you update the DB, just set the parameter value for that column to
DBValue.Null.

--Bob
 
Back
Top