SqlDataAdapter的执行带参存储过程

// 根据页数 执行分页存储过程 返回显示数据
    public DataSet ProceGetCustomersByPage(string getCustomersByPage, int pageNumber, int pageSize)
    {
        SqlDataAdapter dataAdapter = new SqlDataAdapter(getCustomersByPage,OpenCon());        
        dataAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
        //参数的传入
        SqlParameter sptPageNumber = new SqlParameter("@PageNumber", SqlDbType.Int, 20);
        SqlParameter sptPageSize = new SqlParameter("@PageSize", SqlDbType.Int, 20);
        sptPageNumber.Direction = ParameterDirection.Input;
        sptPageSize.Direction = ParameterDirection.Input;
        sptPageNumber.Value = pageNumber;
        sptPageSize.Value = pageSize;
        dataAdapter.SelectCommand.Parameters.Add(sptPageNumber);
        dataAdapter.SelectCommand.Parameters.Add(sptPageSize);      
        DataSet ds = new DataSet();
        dataAdapter.Fill(ds, "ffc");
        return ds;
    }
    //