<%@ Register assembly="AspNetPager" namespace="Wuqi.Webdiyer" tagprefix="webdiyer" %>  <webdiyer:AspNetPager id="AspNetPager1" runat="server" ShowPageIndexBox="Always"                                             PageSize="20" OnPageChanged="AspNetPager1_PageChanged"                                             TextBeforeInputBox="转到第  "               TextAfterInputBox="  页  " ShowPageIndex="False"                                             ShowInputBox="Always"               ShowCustomInfoSection="Left" PrevPageText="上一页"                                             NextPageText="下一页" LastPageText="尾页"               FirstPageText="首页" AlwaysShow="True"                                             CustomInfoSectionWidth="600"               CustomInfoTextAlign="NotSet" LayoutType="Table">      </webdiyer:AspNetPager>            <webdiyer:AspNetPager ID="AspNetPager2" runat="server" CloneFrom="AspNetPager1">        </webdiyer:AspNetPager>

 public void checkCase()        {            string strSql = " ID>0";            int num = bll.GetRecordCount(strSql);            AspNetPager1.RecordCount = num;            DataSet ds = bll.GetAspNetPagerDataSet(strSql, AspNetPager1.CurrentPageIndex, AspNetPager1.PageSize);            if (ds.Tables[0].Rows.Count > 0)            {                this.Repeater1.DataSource = ds.Tables[0].DefaultView;                this.Repeater1.DataBind();                AspNetPager1.CustomInfoHTML = "共：<font color=\"red\"><b>" + AspNetPager1.RecordCount.ToString() + "</b></font>&nbsp;&nbsp;条记录";                AspNetPager1.CustomInfoHTML += " 总页数：<font color=\"red\"><b>" + AspNetPager1.PageCount.ToString() + "</b></font>&nbsp;&nbsp;页";                AspNetPager1.CustomInfoHTML += " 每页显示：<font color=\"red\"><b>" + AspNetPager1.PageSize.ToString() + "</b></font>&nbsp;条";                AspNetPager1.CustomInfoHTML += " 当前页：<font color=\"red\"><b>" + AspNetPager1.CurrentPageIndex.ToString() + "</b></font>&nbsp;&nbsp;";            }        }

/// <summary>        /// 获得aspnetpager分页数据        /// </summary>        public DataSet GetAspNetPagerDataSet(string whereSql, int mypageindex, int mypagesize)        {            return dal.GetAspNetPagerList(whereSql, mypageindex, mypagesize);        }

 /// <summary>        /// 获得AspNetPager分页数据列表        /// </summary>        public DataSet GetAspNetPagerList(string strWhere, int mypageindex, int mypagesize)        {            StringBuilder strSql = new StringBuilder();            strSql.Append(" SELECT ID,sTitle,sContent,sAuthor,sAuthorTel,sAuthorQQ,sAuthorEmail,toDepart,ifPass,PubDate ");            strSql.Append(" FROM QuestionBook ");            if (strWhere.Trim() != "")            {                strSql.Append(" where " + strWhere);            }            strSql.Append(" order by ID desc");            return SQLHelper.ExecuteWebDiyerDataset(SQLHelper.DBCONNECTIONSTRING, CommandType.Text, strSql.ToString(), mypageindex, mypagesize);        }

 #region 为webdiyer分页控件做的 DataSet 传递参数进来 DataSet ExecuteWebDiyerDataset(string connString, CommandType cmdType, string cmdText,int mypageindex,int mypagesize, params SqlParameter[] cmdParms)        public static DataSet ExecuteWebDiyerDataset(string connString, CommandType cmdType, string cmdText, int mypageindex, int mypagesize, params SqlParameter[] cmdParms)        {            SqlDataAdapter myAdapter = new SqlDataAdapter();            myAdapter.SelectCommand = new SqlCommand();            using (SqlConnection conn = new SqlConnection(connString))            {                PrepareCommand(myAdapter.SelectCommand, conn, null, cmdType, cmdText, cmdParms);                DataSet ds = new DataSet();                myAdapter.Fill(ds, mypagesize * (mypageindex - 1), mypagesize, "dtable");                myAdapter.SelectCommand.Parameters.Clear();                return ds;            }        }        #endregion