dateTime

[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

 

[Ollie Riches]

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

 

[JohnnyAppleseed]

Using SQL, you can set a date value to NULL. For example:
set SomeDate = null where id = xxx

 

[Bob Grommes]

When you update the DB, just set the parameter value for that column to
DBValue.Null.

--Bob