网站制作：datalist分页问题的解决办法

热点排行

datalist分页问题的解决办法

类别：网站制作点击：0 评论：0 推荐：

用datalist制作一个分页，具体要是实现的情况是：<< << 1 2 3 4 5 6…… >> >> 共多少页转到多少页,点第一个<<转到首页点第二个<<向上一页点数字的时候就转到数字所在的页面，后面同理,做分页, 不管是datalist, 还是grid还是listbox等来实现数据呈现,只要将数据源分页就解决了,构思一个数据源分页的方法,不管点击哪一页,
传个页码的关键字进来这个方法就行了.
******************************
<%@ import namespace="System"%>
<%@ import namespace="System.Data"%>
<%@ import namespace="System.Data.OleDb"%>
<%@ import namespace="System.Data.SqlClient"%>
<%@ import namespace="System.Web.UI"%>
<%@ import namespace="System.Web.UI.WebControls"%>
<%@ import namespace="System.Web.UI.HtmlControls"%>
<%@ import namespace="System.Collections"%>
<%@ import namespace="System.Web.SEssionState"%>
<%@ import namespace="System.Configuration"%>

  OleDbConnection MyConn;
                int PageSize,RecordCount,PageCount,CurrentPage,i;
                ArrayList Al_PageNum;

public void Page_Load(Object src,EventArgs e)
{

                PageSize = 4;               //设定PageSize
                                        //连接语句
                string strcon="provider=Microsoft.jet.OLEDB.4.0;data Source="+Server.MapPath(ConfigurationSettings.AppSettings["MDBpath"])+";";
                MyConn = new OleDbConnection(strcon);
                MyConn.Open();

                if(!Page.IsPostBack)                  //第一次请求执行
                 {

                   RecordCount = CalculateRecord(); //计算总共有多少记录/

                   PageCount = RecordCount/PageSize; //计算总共有多少页
                   if (RecordCount%PageSize > 0)     //取整
                   PageCount = PageCount + 1;
                   lblPageCount.Text = PageCount.ToString();
                   lblRecordCount.Text = RecordCount.ToString();
                   ViewState["PageCount"] = PageCount;
                   CurrentPage = 0;
                   ViewState["PageIndex"] = 0;

                   Al_PageNum= new ArrayList();//绑定DROPDOWNLIST
                   for(i=1;i<=PageCount;i++)   //从1开始循环，为了不出现0页码
                   Al_PageNum.Add(i.ToString());
                   Ddl_PageNumber.DataSource=Al_PageNum;
                   Ddl_PageNumber.DataBind();

                   ListBind();                         //绑定
                 }
                 MyConn.Close();

             }


  protected string FormatString(string str)
  {
   str=str.Replace(" ","  ");
   str=str.Replace("<","<");
   str=str.Replace(">",">");
   str=str.Replace('\n'.ToString(),"<br>");
   return str;
  }

  public int CalculateRecord()                //计算总共有多少条记录
                {
                        int intCount;
          string strCount = "select count(*) as co from gbook ";
                        OleDbCommand MyComm = new OleDbCommand(strCount,MyConn);
                        OleDbDataReader dr = MyComm.ExecuteReader();
                        if(dr.Read())
                          {
                             intCount = Int32.Parse(dr["co"].ToString());
                          }
                        else
                          {
                             intCount = 0;
                          }
                        dr.Close();
                        return intCount;
                 }

ICollection CreateSource()
{

                        int StartIndex;                               //设定导入的起终地址
                        StartIndex = CurrentPage*PageSize;            //计算记录数的起始点
                        string strSel = "select * from gbook order by id desc";
                        DataSet ds = new DataSet();
                        OleDbDataAdapter MyAdapter = new OleDbDataAdapter(strSel,MyConn);
                        MyAdapter.Fill(ds,StartIndex,PageSize,"Score");
                        return ds.Tables["Score"].DefaultView;
                }

  public void ListBind()
                {
                        MyList.DataSource = CreateSource();
                        MyList.DataBind();
                        lbnNextPage.Enabled = true;
                        lbnPrevPage.Enabled = true;
                        if(PageCount==0)
                          {
                            lblCurrentPage.Text = "0";
                            lbnNextPage.Enabled = false;
                            lbnPrevPage.Enabled = false;
                          }
                        else
                          {
                            if(CurrentPage==(PageCount-1)) lbnNextPage.Enabled = false;
                            if(CurrentPage==0) lbnPrevPage.Enabled = false;
                            lblCurrentPage.Text = (CurrentPage+1).ToString();
                          }
                }

  public void Page_OnClick(Object sender,CommandEventArgs e)
                {
                        CurrentPage = (int)ViewState["PageIndex"];
                        PageCount = (int)ViewState["PageCount"];
                        string cmd = e.CommandName;                 //判断cmd，以判定翻页方向


                        switch(cmd)
                         {
                            case "next":
                            if(CurrentPage<(PageCount-1)) CurrentPage++;
                            break;
                            case "prev":
                            if(CurrentPage>0) CurrentPage--;
                            break;
                          }

ViewState["PageIndex"] = CurrentPage;

ListBind();

}
public void PageNum_SelectIndexChanged(object sender,System.EventArgs e)

              {
               ViewState["PageIndex"] =int.Parse(Ddl_PageNumber.SelectedItem.Value)-1;//保持不出现0页码
               PageSize = 4;
               CurrentPage = (int)ViewState["PageIndex"];
               PageCount = (int)ViewState["PageCount"];
               ListBind();
               //MyList.DataSource = CreateSource();
               //MyList.DataBind();
              }
******************************
override protected void OnInit(EventArgs e)
             {
               InitializeComponent();
               base.OnInit(e);
              }

            private void InitializeComponent()
             {

               this.Load+=new System.EventHandler(this.Page_Load);
               this.Ddl_PageNumber.SelectedIndexChanged+=new System.EventHandler(this.PageNum_SelectIndexChanged);

             }
             public string test(string str)
               {
                   string str2="";
                   if(str==String.Empty)
                      {
                       str2="暂无回复";
                      }
                   else
                      {
                       string str3="回复：<br>   ";

                       str2=str3+str;

                      }
                   return str2;
               }

   /*          for(int i=10;i<20;i++)
              {
               DropDownList1.Items.Add(new ListItem("第"+i.ToString()+"页",i.ToString()));
              }

</script>
<asp:DataList id="MyList" RepeatColumns="1" runat="server">

<itemtemplate> <table width="500" border="0" cellpadding="4" cellspacing="1" bgcolor="8c9aa5">
<tr bgcolor="cecfd6">
    <td colspan="2" align="left" bgcolor="#dedbde"><strong>      No.<%# DataBinder.Eval(Container.DataItem, "id") %> 
      <%# DataBinder.Eval(Container.DataItem, "title") %></strong>
    </td>
</tr>
<tr>
    <td width="95" rowspan="2" align="center" valign="middle" bgcolor="f7f7f7" class="word">
      <table width="95" border="0" cellspacing="0" cellpadding="0" class="table1">
        <tr>
          <td align="center" valign="top" ><br><image src="<%# DataBinder.Eval(Container.DataItem, "sex_image") %>" border=0 ></td>
        </tr>
        <tr>
          <td align="center" class="word" ><%# DataBinder.Eval(Container.DataItem, "username") %><br><%# DataBinder.Eval(Container.DataItem, "sex") %></td>
        </tr>
      </table>
    </td>
    <td width="386" height="129" valign="top" bgcolor="f7f7f7" class="word">
           <table width="100%" border="0" cellspacing="0" cellpadding="0">
               <tr>
                 <td class="word">留言：<Br>   <%# DataBinder.Eval(Container.DataItem, "content") %><br><br><Br><BR></td>
               </tr>
               <tr>
                 <td width="80%" bgcolor="#c6c3c6" height="1"></td>
               </tr>
               <tr>
                 <td class="word"><br><font color=red><%# test(DataBinder.Eval(Container.DataItem, "r_content").ToString()) %><font></FONT><br><br></td>
               </tr>
           </table>

</td>
</tr>
<tr>
    <td height="22" bgcolor="cecfd6" valign="top">
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td align="left"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                              <tr>
                               <td>IP地址:<%# DataBinder.Eval(Container.DataItem, "ip") %>&nbsp&nbsp&nbsp发表时间：<%# DataBinder.Eval(Container.DataItem, "regdate") %></td>
                               <td width="15%" align="right"><a href="<%# DataBinder.Eval(Container.DataItem, "website") %>" target="_blank"><img src="img/url.gif" border=0></a> <a href="mailto:<%# DataBinder.Eval(Container.DataItem, "email") %>" target="_blank"><img src="img/email2.gif" border=0></a></td>
                              </tr>
                           </table>
          </td>
        </tr>
      </table></td>
</tr>
</table>
   <br>
</itemtemplate>

</asp:DataList>
<table width="530" border="1" align="center" cellspacing="0" cellpadding="3" bgcolor="#FFFFFF" bordercolor="#C0C0C0" style="border-collapse: collapse">
<tr>
      <td align="right" bgcolor="#ECECEC" colspan="2"><asp:LinkButton id="lbnPrevPage" Text="上一页" CommandName="prev" OnCommand="Page_OnClick" runat="server" />
  <asp:LinkButton id="lbnNextPage" Text="下一页" CommandName="next" OnCommand="Page_OnClick" runat="server" />
  共有<asp:Label id="lblRecordCount" ForeColor="red" runat="server" />条记录
  当前为<asp:Label id="lblCurrentPage" ForeColor="red" runat="server" />/<asp:Label id="lblPageCount" ForeColor="red" runat="server" />页  <asp:dropdownlist ID="Ddl_PageNumber" runat="server" AutoPostBack="true" CssClass="lanyu"></asp:dropdownlist>
      </td>

</tr>

</table>

本文地址：http://com.8s8s.com/it/it30729.htm