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.
Assign Null value of DataTable Column to int variable?
-
- Posts: 74
- Joined: Fri Dec 07, 2012 11:35 am
Re: Assign Null value of DataTable Column to int variable?
Hello,
Please try to use the following expression:
{iff(data2["id"] == DBNull.Value,"0",data2.id)}
Thank you.
Please try to use the following expression:
{iff(data2["id"] == DBNull.Value,"0",data2.id)}
Thank you.
-
- Posts: 74
- Joined: Fri Dec 07, 2012 11:35 am
Re: Assign Null value of DataTable Column to int variable?
Hello,
We are always glad to help you!
Let us know if you need any additional help.
We are always glad to help you!
Let us know if you need any additional help.