Perform Response.Redirect based on value from database stored procedure in ASP.Net

hi 

below is my SP

create procedure [dbo].[Estate_P_SaveEstate]
@Name nvarchar(40)
,@id int =0
,@behcode nvarchar(10)
,@Success NVARCHAR(120) OUTPUT
AS 
BEGIN
 DECLARE @Result AS int
Declare @BehcodeN nvarchar(10) set @BehcodeN =(select BehcodeN from House_info where behcode=@Behcode )
					IF NOT EXISTS(SELECT behcode FROM Estate_p WHERE code = @code and behcode=@Behcode) 
						BEGIN
							IF EXISTS(SELECT behcode FROM Estate_p WHERE id = @id AND @id > 0 )
								BEGIN
								UPDATE Estate_p
								SET
									  Name=@Name
								WHERE BehCode=@Behcode and ID=@id
								SET @Success = 'Insert successfully' 
								SELECT @id
					        END
						ELSE
						BEGIN
					         IF (SELECT COUNT(behcode) FROM Estate_p WHERE behcode = @behcode and BehcodeN='FreeE')< 2
								  BEGIN
										INSERT INTO Estate_p(Name,behcode,BehcodeN)
										VALUES(@Name,@Behcode,@BehcodeN)
										SELECT SCOPE_IDENTITY()						
										set @Success= 'Insert successfully' 
								  END
							ELSE
								BEGIN
									SET @Success = 'you can just insert 2 product.'    
								END
							END
						END
					ELSE
						BEGIN
							SET @Success = 'you insert this product twice'
							SET @Result = 0
						END
END

here I define 

,@Success NVARCHAR(120) OUTPUT

that according to condition it show some message here I want in below line

SET @Success = 'Insert successfully' 

instead of it show 'Insert successfully' it go to page Message.aspx 

how I can do it?

Best Regards

Neda