如何在storedprocedsure中使用输出值？ [英] How to use ouput value in storedprocedsure?

问题描述

嗨
在我的storedprocedure中我使用输出值，



创建程序程序名称

@Returnvalue int output

as

开始

设置@Returnvalue = 2

结束



在我的页面中，

strSPName =" DSp_GetUpdateInsertLookupbyName_Admin";



SqlParameter [] objSqlParameter = new SqlParameter [1];







objSqlParameter [0] =新的SqlParameter（@ ReturnValue，System.Data.SqlDbType.Int ）;

objSqlParameter [0] .Direction = ParameterDirection.Output;





intReturnValue =（int） objSqlParameter [0] .Value;



结果为0但我需要返回值为2



Plz帮帮我



提前致谢

Hi In my storedprocedure i use output value,

create procedure Procedure Name
@Returnvalue int output
as
Begin
Set @Returnvalue =2
end

in my page,
strSPName = "DSp_GetUpdateInsertLookupbyName_Admin";

SqlParameter[] objSqlParameter = new SqlParameter[1];



objSqlParameter[0] = new SqlParameter(@ReturnValue, System.Data.SqlDbType.Int);
objSqlParameter[0].Direction = ParameterDirection.Output;


intReturnValue = (int)objSqlParameter[0].Value;

Result is 0 only but I need to return value is 2

Plz help me

Thanks in advance

推荐答案

Google is y我们的老师



http://stackoverflow.com/questions/7770924/how-to-use-output-parameter-in-stored-procedure [ ^ ]



尝试更多链接



http://www.google.co.in/#hl=en&tbo=d&sclient=psy-ab&q =如何+ +使用SQL +过程+输出+参数+在+ C％23安培; OQ =如何+ +使用SQL +过程+出来&安培; gs_l = hp.3.0.33i29 .985.9894.0.11380.28.18.0.10.10.1.378.3877.0j11j5j2.18.0.les％3B..0.0 ... 1c.1.2.hp.KyUaKe4qme0&安培; PBX = 1&安培; BAV = on.2，or.r_gc.r_pw。 r_qf。& bvm = bv.41867550，d.bmk& fp = 728805b6204cca56& biw = 1366& bih = 674 [ ^ ]





接受并投票，如果有其他帮助，请回复查询

- RDB

Google is your teacher

http://stackoverflow.com/questions/7770924/how-to-use-output-parameter-in-stored-procedure[^]

Try more link

http://www.google.co.in/#hl=en&tbo=d&sclient=psy-ab&q=how+to+use+sql+procedure+output+parameter+in+c%23&oq=How+to+use+sql+procedure+out&gs_l=hp.3.0.33i29.985.9894.0.11380.28.18.0.10.10.1.378.3877.0j11j5j2.18.0.les%3B..0.0...1c.1.2.hp.KyUaKe4qme0&pbx=1&bav=on.2,or.r_gc.r_pw.r_qf.&bvm=bv.41867550,d.bmk&fp=728805b6204cca56&biw=1366&bih=674[^]


Accept and vote if helps otherwise revert back with queries
--RDB

您好，试试吧..

Hi, Try this..

SqlParameter objSqlParameter = new SqlParameter("@ID", SqlDbType.Int)
   { 
      Direction = ParameterDirection.Output 
   };
//=============================

int intReturnValue = objSqlParameter .Value as int? ?? default(int); 

另外一个很好的例子你可以通过这个链接。



http://www.eggheadcafe.com/PrintSearchContent.asp?LINKID=624 [ ^ ]

这篇关于如何在storedprocedsure中使用输出值？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！