using case statement in database and Populating DropDownList in .net

See more: (untagged)

ELSE IF (@CALL_TYPE = 14) --MODIFIED BY MANI ADDING ASSET STATUS

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.