I have a stored procedureCREATE PROCEDURE Test@ReturnVal int OutputASif exists(Select 1 from Business where Business_ID= '43')
Return 2elseReturn 3GOpublic
{
DataAccess ds =
paramRetMsg.Direction = ParameterDirection.Output;
ExceptionManager.Publish(ex);
}
} I am not able to return 2 or 3 from the stored procedure .Please let me know .Thanks