日期:2014-05-18  浏览次数:21064 次

如何调用这个输出参数的存储过程谢谢了
create procedure [dbo].[proc_MaxNum]
@maxNum int output 
as
begin
set @maxNum=(select top 1 COUNT(GID) as Number from dbo.Group_InternalMember group by UserID,UserName order by Number desc)
--return @maxNum
end
下面是我写的肯定不对
  public DataSet maxNum()
  {
  SqlParameter[] parameters = {
  new SqlParameter("@maxNum", SqlDbType.Int),
  };
  parameters[0].Value ="-1" ;
  DataSet sa = DbHelperSQL.RunProcedure("proc_MaxNum", parameters, "ds");
  return DbHelperSQL.RunProcedure("proc_MaxNum", parameters, "ds");
  }
谁知道怎么调这个存储过程
并返回输出参数

------解决方案--------------------
--------Procedure
create procedure [dbo].[proc_MaxNum]
@maxNum int output 
as
begin
set @maxNum=(select top 1 COUNT(GID) as Number from dbo.Group_InternalMember group by UserID,UserName order by Number desc)
SELECT @maxNum AS MAXNUM
end

-----------Code
public DataSet maxNum()
{
SqlParameter[] parameters = {
new SqlParameter("@maxNum", SqlDbType.Int),
};
parameters[0].Value ="-1" ;
-----这里就是用返回int的方法去调用
比如:
Int32 Result = DbHelperSQL.RunProcedure("proc_MaxNum", parameters, "ds");
}