TableAdapter Reversing Values Sent By A Stored Procedure

I have a  stored procedure which returns 3 different kind of values. I am checking whether a certain value entered by user is present in one of the columns of database table. Accordingly the SP returns 1 if present, -1 if not present and third value is SQL server 2005  error.

But the problem is that I am only getting  -1  everytime even if the value is present.I executed  the SP alone to find out if it is the one which is returning the INCORRECT value. I found that that SP is returning the correct value.
Therefore I came to the conclusion that it is the Table ADapter which got corrupted.I deleted the TableAdapter and created it again, but then it didn't solve the problem.
I have now run out of ideas.

The code of the SP is:ALTER PROCEDURE spcheck_ServerName

(@Server_Name nvarchar(50)

 

)

ASDECLARE @Result int

IF EXISTS

(

SELECT

NULL

FROMServerDetails WITH (UPDLOCK)

WHERE

 

[SERVER NAME] = @Server_Name

)

BEGINSELECT @Result = 1

END

ELSE

BEGIN

 SELECT @Result = -1

END

 

IF @@ERROR <> NULL

BEGIN

 SELECT @Result = @@ERROR

 END

RETURN @Result

And I am calling the tableAdapter method in the code behind file of the web form in the following manner:private int chkServerName(string sname1)

{

try

{Serverlist1TableAdapters.SERVERDETAILSTableAdapter nwAdapter = new Serverlist1TableAdapters.SERVERDETAILSTableAdapter();

int snval = (int)nwAdapter.spcheck_SName(sname1);return snval;

}catch (Exception ex)

{return ex.GetHashCode();

}

}

 



Any help will be greatly appreciated.