- 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