DateTime to DBNull.Value

[Diogo Alves - Software Developer]

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...

[Rob Schieber]

Re: DateTime to DBNull.Value

Diogo Alves - Software Developer wrote:[color=blue]
> 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...[/color]

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.MinVal ue.

if(date == DateTime.MinVal ue)
parameter.Value = null;


--
Rob Schieber

[mphacker]

Re: DateTime to DBNull.Value

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