Doubt in retrive value from database to form in c#

hi use this stored procedure.

Create procedure SP_DEMO
@Amount decimal(18,2)
As

    if @Amount  between 10000 and 19999
     Begin
     Select Gift from Table_3
     Where Amount=10000
     End
    Else if @Amount  between 20000 and 29999
    Begin
     Select Gift from Table_3 
     Where Amount=20000
     End
    Else if @Amount  between 30000 and 49999
    Begin
     Select Gift from Table_3 
     Where Amount=30000
     End