how to use Conditional operator when setting a value to sql parameter

Question

I have a stored procedure accepting @from_date = NULL.
I have a variable dayCount. If its value is 0, I have to pass Null as param. Else DateTime.Today.AddDays(dayCount).

My code goes like this.

int dayCount = -7;
SqlParameter[] parameters =
{    
new SqlParameter("@from_date", SqlDbType.VarChar) { Value = (dayCount==0)? null : (DateTime.Today.AddDays(dayCount)) }                        
};

i'm getting error in (dayCount==0)? null : (DateTime.Today.AddDays(dayCount)).

Help

gzaxx · Accepted Answer · 2013-11-25 12:14:01Z

1

Try this:

int dayCount = -7;
SqlParameter[] parameters =
{
       new SqlParameter("@from_date", SqlDbType.VarChar) 
       { 
            Value = dayCount == 0 ? null : (DateTime?)(DateTime.Today.AddDays(dayCount))
       }
};

DateTime cannot be null (as it is a struct) so you have to cast it to Nullable DataTime to use it in conditional operator.

answered Nov 25, 2013 at 12:14

gzaxx

17.6k2 gold badges40 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to use Conditional operator when setting a value to sql parameter

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related