ASP.NET 获取存储过程返回值的实现代码

<br>create proc proc_addUserInfo <br>@uname varchar(50), <br>@upass varchar(50), <br>@Returnc int output <br>as <br>begin <br>insert into erp_user(u_name,u_pass)values(@uname,@upass) <br>set @Returnc= isnull(@@identity,0) <br>end <br> <br>这里返回值我获取的是添加记录的Id。 <br>后台代码： <br><span><u></u></span> 代码如下:<pre class="brush:php;toolbar:false layui-box layui-code-view layui-code-notepad"><ol class="layui-code-ol"><li><br>SqlParameter[] para = new SqlParameter[] <br>{ <br>new SqlParameter("@uname","2012"), <br>new SqlParameter("@upass","2012") <br>}; <br>string sql_para = "dbo.proc_addUserInfo"; <br>CommandType type=CommandType.StoredProcedure; <br>SQLHelper sqlh = new SQLHelper(); <br>int Id=sqlh.ExecuteNoQuery(sql_para,type,para); <br> <br>SQLHelper： <br><span><u></u></span> 代码如下:<pre class="brush:php;toolbar:false layui-box layui-code-view layui-code-notepad"><ol class="layui-code-ol"><li><br>public int ExecuteNoQuery(string sql,CommandType type,params SqlParameter [] values) <br>{ <br>using (SqlCommand cmd = new SqlCommand(sql, Conn)) <br>{ <br>cmd.CommandType = type; <br>if (values != null) <br>{ <br>cmd.Parameters.AddRange(values); <br>} <br>SqlParameter Retvar = cmd.Parameters.Add("@Returnc", SqlDbType.Int); <br>Retvar.Direction = ParameterDirection.Output; <br>int count = cmd.ExecuteNonQuery(); <br>return (int)Retvar.Value; <br>} <br>} <br></li><li>            </li><li>                                </li></ol></pre></li></ol></pre>