設參數和直接return時都可接收到。

string sConnectionString =User ID=zdp;pwd=zdp;Initial Catalog=aaa;Data Source=(local);
SqlConnection conn=new SqlConnection(sConnectionString);
conn.Open();
SqlCommand cm=new SqlCommand(aaaa,conn);
cm.CommandType=CommandType.StoredProcedure;
cm.Parameters.Add(@id,SqlDbType.Int,4);
cm.Parameters.Add(@test,SqlDbType.Int,4);
cm.Parameters.Add(@ouid,SqlDbType.Int,4);
cm.Parameters[@id].Value=Convert.ToInt32(newid.Text.ToString());
cm.Parameters[@test].Direction=System.Data.ParameterDirection.ReturnValue;
cm.Parameters[@ouid].Direction=System.Data.ParameterDirection.Output;
cm.ExecuteNonQuery();
//OUTRET為存儲過程中輸出參數給變量outret賦予的值
string outret=cm.Parameters[@ouid].Value.ToString();
//returnvalue為存儲過程給返回值變量returnvalue賦予的值
string returnvalue=cm.Parameters[@test].Value.ToString();
//mes,ret是兩個LABEL的ID
mes.Text=outret.ToString();
ret.Text=returnvalue.ToString();

//-----------------------------------存儲過程

CREATE PROCEDURE aaaa
@id INT,
@ouid int output
AS
SET NOCOUNT ON
begin
if exists(select * from yg where id=@id)
BEGIN
set @ouid=@id
return 0
END
set @ouid=@id
RETURN 1
end
GO