asp如何取得存储过程的return值

Question

本帖最后由 fangsky 于 2009-07-13 23:52:05 编辑

Answer 1

                connParameter.commandtext = "Page2005";
                connParameter.commandtype = CommandType.StoredProcedure;                SqlParameter[] sqlParameters =
                    {
                        new SqlParameter("@TableName",SqlDbType.Int),
                        new SqlParameter("@Fields",SqlDbType.Int),
                        new SqlParameter("@PrimaryKey",SqlDbType.Int),
                        new SqlParameter("@OrderField",SqlDbType.DateTime),
                        new SqlParameter("@Orderby",SqlDbType.Int),
                        new SqlParameter("@sqlWhere",SqlDbType.DateTime),
                        new SqlParameter("@pageSize",SqlDbType.Int),
                        new SqlParameter("@pageIndex",SqlDbType.Int),
                        new SqlParameter("@TotalPage",SqlDbType.Int)
                   };
                sqlParameters[0].Value = TableName;//这些参数需要在上面定义
                sqlParameters[1].Value = Fields;
                sqlParameters[2].Value = PrimaryKey;
                sqlParameters[3].Value = OrderField;
                sqlParameters[4].Value = Orderby;
                sqlParameters[5].Value = sqlWhere;
                sqlParameters[6].Value = pageSize;
                sqlParameters[7].Value = TotalPage;//这些参数需要在上面定义
                sqlParameters[8].Direction = ParameterDirection.Output;  //这个值就是你要的值                connParameter.parameters = sqlParameters;

Answer 2

Database db = DatabaseFactory.CreateDatabase("DataBase");            SqlConnection connection = (SqlConnection)db.GetConnection();            SqlCommand sb = connection.CreateCommand();
                try
                {
                    connection.Open();                    sb.CommandText = "Process Name";
                    sb.CommandType = CommandType.StoredProcedure;                    sb.Parameters.Clear();
                    sb.Parameters.Add("@TableName ", SqlDbType.VarChar, 50);   --传入参数
                    sb.Parameters["@TableName "].Value = data;   -- 值                                         ...                    sb.Parameters.Add("@totalRecord ", SqlDbType.NVarChar, 500); --传出参数
                    sb.Parameters["@totalRecord "].Direction = ParameterDirection.Output;   -- 设置方向
                   
                    sb.ExecuteNonQuery();                    string dividedJobInfo = sb.Parameters[1].Value.ToString();                    return dividedJobInfo;
                }