我写了一个存储过程,在CS文件里调用SqlHelper.cs的那一个方法才能得到存储过程的返回值呢?
存储过程如下:CREATE PROCEDURE Pr_MobileBrandAdd
(
@MobileBrandName varchar(50),
@MobileBrandName1 varchar(50)
)
AS
Declare @MobileOrder int
if exists (select * from MobileBrand where MobileBrandName = @MobileBrandName or MobileBrandName1 = @MobileBrandName1)
return 0
else
begin
set @MobileOrder = (select max(MobileBrandOrders) from MobileBrand) + 1
insert into MobileBrand (MobileBrandOrders,MobileBrandName,MobileBrandName1)
values( @MobileOrder,@MobileBrandName,@MobileBrandName1)
return 1
end
GO我要的是在CS文件里执行这个存储过程,并得到它的返回值.
谢谢!!
存储过程如下:CREATE PROCEDURE Pr_MobileBrandAdd
(
@MobileBrandName varchar(50),
@MobileBrandName1 varchar(50)
)
AS
Declare @MobileOrder int
if exists (select * from MobileBrand where MobileBrandName = @MobileBrandName or MobileBrandName1 = @MobileBrandName1)
return 0
else
begin
set @MobileOrder = (select max(MobileBrandOrders) from MobileBrand) + 1
insert into MobileBrand (MobileBrandOrders,MobileBrandName,MobileBrandName1)
values( @MobileOrder,@MobileBrandName,@MobileBrandName1)
return 1
end
GO我要的是在CS文件里执行这个存储过程,并得到它的返回值.
谢谢!!
(
@MobileBrandName varchar(50),
@MobileBrandName1 varchar(50)
)
AS
return 12345
GO
调用代码
SqlParameter[] sp = new SqlParameter[3];
sp[0] = new SqlParameter("@MobileBrandName ","");
sp[1] = new SqlParameter("@MobileBrandName1 ","");
sp[2] = new SqlParameter();
sp[2].Direction = ParameterDirection.ReturnValue;
WebJuFu.SqlHelper.ExecuteNonQuery(@"data source=CCC;uid=sa;initial catalog=tempdb",CommandType.StoredProcedure,"ppp",sp);
Response.Write(sp[2].Value.ToString());sp[2]就是取返回值的参数.
Parm[9].Direction = ParameterDirection.Output;string returnvalue=Parm[9].Value