SQLHelper获取存储过程里面的return 和 ouput值

最新推荐文章于 2019-10-14 19:31:58 发布

abqqnk6495

最新推荐文章于 2019-10-14 19:31:58 发布

阅读量101

点赞数

原文链接：http://www.cnblogs.com/dongchunfeng/archive/2011/08/12/2136751.html

版权

 SqlParameter p = new SqlParameter("@state", 1);
        SqlParameter returnn = new SqlParameter("@return", SqlDbType.Int);
        SqlParameter outPut = new SqlParameter("ouput", SqlDbType.Int);
        outPut.Direction = ParameterDirection.Output;
        SqlParameter[] sp = {
                                p,returnn,outPut 
                            };
        returnn.Direction = ParameterDirection.ReturnValue;
        SQLHelper.ExecuteNonQuery(SqlDataSource1.ConnectionString, CommandType.StoredProcedure, "testP", sp);
        int count = Convert.ToInt32(returnn.Value);
        int count1 = Convert.ToInt32(outPut.Value);

转载于:https://www.cnblogs.com/dongchunfeng/archive/2011/08/12/2136751.html