DateTime to DBNull.Value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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...
 
Diogo said:
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...
Click to expand...

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;
 
Back
Top