蔡鸟,加油!

C#里调用带输出参数的存储过程

private int PageCount(SqlParameter[] param, string procName, SqlParameter outPutParam)
        {
            using (SqlConnection conn = new SqlConnection(DAL.DBHelper.connString))
            {
                conn.Open();
                SqlCommand cmd = new SqlCommand(procName, conn);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.AddRange(param);
                cmd.Parameters.Add(outPutParam);
                outPutParam.Direction = ParameterDirection.Output;
                cmd.ExecuteNonQuery();
                return Convert.ToInt32(cmd.Parameters["@count"].Value);//获取存储过程的返回值

            }
        }

posted on 2009-04-13 15:20  蔡鸟  阅读(287)  评论(0编辑  收藏  举报

导航