set the value of a int sqlparameter when the value of a drop down list is 0

EDN Admin

Well-known member
Joined
Aug 7, 2010
Messages
12,794
Location
In the Machine
<span style="font-size:x-small; font-family:Consolas <span style="font-size:x-small; font-family:Consolas
if a ddl has a value of 0 i want the value of the param to be null. I tried this but get an error because null isnt an int. I would like some thing compact. i tried creating a function but you cant return null if the return type is int
<font face="Consolas" size="2" style="font-size:x-small; font-family:Consolas
sqlParams[1] =
</font>
<span style="font-size:x-small; color:#0000ff; font-family:Consolas <span style="font-size:x-small; color:#0000ff; font-family:Consolas <span style="font-size:x-small; color:#0000ff; font-family:Consolas new<span style="font-size:x-small; font-family:Consolas <span style="font-size:x-small; font-family:Consolas
<span style="font-size:x-small; color:#2b91af; font-family:Consolas <span style="font-size:x-small; color:#2b91af; font-family:Consolas <span style="font-size:x-small; color:#2b91af; font-family:Consolas SqlParameter<span style="font-size:x-small; font-family:Consolas <span style="font-size:x-small; font-family:Consolas (<span style="font-size:x-small; color:#a31515; font-family:Consolas <span style="font-size:x-small; color:#a31515; font-family:Consolas <span style="font-size:x-small; color:#a31515; font-family:Consolas "@FdNo"<span style="font-size:x-small; font-family:Consolas <span style="font-size:x-small; font-family:Consolas ,
ddlFd4.SelectedValue == <span style="font-size:x-small; color:#a31515; font-family:Consolas <span style="font-size:x-small; color:#a31515; font-family:Consolas <span style="font-size:x-small; color:#a31515; font-family:Consolas "0"<span style="font-size:x-small; font-family:Consolas <span style="font-size:x-small; font-family:Consolas
? <span style="font-size:x-small; color:#0000ff; font-family:Consolas <span style="font-size:x-small; color:#0000ff; font-family:Consolas <span style="font-size:x-small; color:#0000ff; font-family:Consolas null<span style="font-size:x-small; font-family:Consolas <span style="font-size:x-small; font-family:Consolas
:<span style="font-size:x-small; color:#2b91af; font-family:Consolas <span style="font-size:x-small; color:#2b91af; font-family:Consolas <span style="font-size:x-small; color:#2b91af; font-family:Consolas Convert<span style="font-size:x-small; font-family:Consolas

<span style="font-size:x-small; font-family:Consolas .ToInt32( ddlFund4.SelectedValue));

<hr class="sig M~

View the full article
 
Back
Top