Page 1 of 1

Assign Null value of DataTable Column to int variable?

Posted: Thu Mar 21, 2013 5:59 pm
by amitkaushik
I have null value in integer column in DB. and looking to assign that null value to integer variable in stimulsoft. but it became 0 here.

it can be possible to assign null value to variable?
and can i put the condition like

{iff(data2.id == null,"0",data2.id)}

Thank you.

Re: Assign Null value of DataTable Column to int variable?

Posted: Fri Mar 22, 2013 6:36 am
by Alex K.
Hello,

Please try to use the following expression:
{iff(data2["id"] == DBNull.Value,"0",data2.id)}

Thank you.

Re: Assign Null value of DataTable Column to int variable?

Posted: Thu Apr 04, 2013 7:45 am
by amitkaushik
Thank you

Re: Assign Null value of DataTable Column to int variable?

Posted: Thu Apr 04, 2013 7:49 am
by Alex K.
Hello,

We are always glad to help you!
Let us know if you need any additional help.