ELSE IF (@CALL_TYPE = 14)
BEGIN
select (CASE ASSETSTATUS
WHEN 0 THEN 'NONE'
WHEN 1 THEN 'NOT REGISTERD'
WHEN 2 THEN 'RENEWED'
WHEN 3 THEN 'DECLINED'
WHEN 4 THEN 'REGISTERD'
WHEN 5 THEN 'EXPIRED'
WHEN 6 THEN 'REPLACE'
WHEN 50 THEN 'UNMANAGED'
WHEN 10 THEN 'DISCONNECTED'
WHEN 101 THEN 'STOCK'
WHEN 102 THEN 'INSERVICE'
WHEN 103 THEN 'REPAIR'
WHEN 104 THEN 'DISCARD'
WHEN 105 THEN 'GIFT'
WHEN 110 THEN 'DISPOSED' END) from AMASSET_STT
WHERE
DATAAREAID = @DATAAREAID
end
Im using visual studio 2005,Vb.net and sql server 2005.
im facing problem in .vb page that conversion string to integer.
objAsset is a class file where we declare properties.
ddlAssetStatus is DDL Control id.
objAsset.AssetStatus=ddlAssetStatus.SelectedValue
Now you any one can help me
This is the stored procedure for populating dropdown AssetStatus.
In database it is working while in calling in .net application it raising an error
conversion failed string to integer.
Asset Status is a DropDownList, ddlAssetStatus.SelectedValue here im getting
error.
please help me.
Thanks in Advance.