try
        {
            int iCnt = -1;
            int iTest = -1;
            SqlParameter[] para = { 
                                new SqlParameter("@col1",10),
                                new SqlParameter("@col2",'Z'),
                                new SqlParameter("@cnt",iCnt),
                                new SqlParameter("@test",iTest)

                              };

            para[2].Direction = ParameterDirection.Output;	//这里接受的是output的值
            para[3].Direction = ParameterDirection.ReturnValue;	//这里接收的是return 的值
            SqlHelper.ExecuteNonQuery(sConn, CommandType.StoredProcedure, "p_tab", para);
            string str1 = para[2].Value.ToString();	
            string str2 = para[3].Value.ToString();

        }
        catch (Exception ex)
        {
            throw ex;
        }

 ALTER proc [dbo].[p_tab]
@col1 int ,
@col2 varchar(20),
@cnt int output
as
begin
 insert into Tab values(@col1,@col2)
 select @cnt= COUNT(1) from Tab
 declare @test int
 set @test=55
 return @test
end