DateTime to DBNull.Value

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Diogo Alves - Software Developer - 30 Sep 2005 15:34 GMT

Hi,

I am writing a class to work with a table that I have...

I would like to initialize every var that will be used to nulls...
I found a problem doing this to DateTime vars

How can I add a parameter do my OdbcCommand telling that a DateTime will be
null.... I really need this...

Any help is appreciated...

Reply to this Message

Rob Schieber - 30 Sep 2005 15:56 GMT

> Hi,
>
[quoted text clipped - 7 lines]
>
> Any help is appreciated...

DateTime can not be null because it is a value type. What you should do
is pick an arbitrary value that will represent null, for example
DateTime.MinValue.

if(date == DateTime.MinValue)
parameter.Value = null;

Signature

Rob Schieber

Reply to this Message

mphacker - 30 Sep 2005 16:03 GMT

How about using the SqlDateTime data type. It will allow you to use
nulls.

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...