站长论坛

标题: 使用DataList实现分页的例子 [打印本页]

作者: abcdef133 时间: 2007-9-19 23:47
标题: 使用DataList实现分页的例子
数据表名称为：guest
包括字段：id(int)，name(varchar)，face(varchar)，sex(varchar)，caption(varchar)，postdate(datetime)，content(text)，homepage(varchar)，ip(varchar)，qq(varchar)，email(varchar)

<body MS_POSITIONING="GridLayout">
   <form method="post" action="default.aspx" runat="server" ID="Form1">
         <table width="100%" border="0" cellpadding="2" cellspacing="0" align="center">
            <tr>
               <td align="center">
                     <asp:DataList ID="Myguest" RepeatColumns="1" Runat="server">
                        <ItemTemplate>
                           <table class="gueststyleline" border="0" cellpadding="0" cellspacing="1" align="center"
                                 width="610">
                                 <tr>
                                    <td>
                                       <table class="gueststyleline" border="0" cellpadding="0" cellspacing="1" align="center"
                                             width="610">
                                             <tr>
                                                <td>
                                                   <table width="100%" border="0" cellpadding="6" cellspacing="0" class="gueststylebg" align="center">
                                                         <tr>
                                                            <td width="112" align="center" height="153" valign="top">
                                                               <table width="100%" border="0" cellspacing="0" cellpadding="0" height="100%" class="gueststylebg">
                                                                     <tr>
                                                                        <td>
                                                                           <table border="0" cellspacing="0" cellpadding="0" align="center" height="25">
                                                                                 <tr>
                                                                                    <td class="FILTER">
                                                                                       <div align="center"><font style="LEFT: 0px; WIDTH: 100%; WORD-WRAP: break-word; 130; 0pt"><%# DataBinder.Eval(Container.DataItem,"name") %></font></div>
                                                                                    </td>
                                                                                 </tr>
                                                                           </table>
                                                                           <div align="center"><font style="LEFT: 0px; WIDTH: 100%; WORD-WRAP: break-word; 130; 0pt"><%#"<img src=\""+ DataBinder.Eval(Container.DataItem,"face")+ "\" width=\"80\" height=\"90\" align=\"middle\">"%></font><br>
                                                                                 <br>
                                                                                 ★
                                                                                 <%# DataBinder.Eval(Container.DataItem,"sex") %>
                                                                                 ★</div>
                                                                        </td>
                                                                     </tr>
                                                               </table>
                                                            </td>
                                                            <td align="center" height="153" width="2">
                                                               <table class="gueststyleline" width="1" height="100%" border="0" cellpadding="0" cellspacing="0">
                                                                     <tr>
                                                                        <td width="1"></td>
                                                                     </tr>
                                                               </table>
                                                            </td>
                                                            <td height="33" valign="top" width="463">
                                                               <table width="100%" border="0" cellspacing="0" cellpadding="0" class="gueststylebg" style="TABLE-LAYOUT: fixed"
                                                                     height="20">
                                                                     <tr>
                                                                        <td height="14" width="310"><img src="webimages/icon/subject.gif" width="15" height="15" alt="主题">:<%# DataBinder.Eval(Container.DataItem,"caption") %><br>
                                                                        </td>
                                                                        <td width="151" height="14"><font style="0pt"> <img src="webimages/icon/posttime.gif" width="16" height="15" alt="发表时间[北京时间]">:<%# DataBinder.Eval(Container.DataItem,"postdate") %></font></td>
                                                                     </tr>
                                                               </table>
                                                               <hr class="gueststylehr" size="0.1" width="100%">
                                                               <table width="100%" border="0" cellpadding="5" cellspacing="0" class="gueststylebg" height="45%"
                                                                     style="TABLE-LAYOUT: fixed">
                                                                     <tr>
                                                                        <td valign="top" width="28" align="center"><img src="webimages/emot/1.gif" width="16" height="16">
                                                                        </td>
                                                                        <td valign="top" width="94%" style="LEFT: 0px; WIDTH: 100%; WORD-WRAP: break-word; 130; 0pt">
                                                                           <%# DataBinder.Eval(Container.DataItem,"content") %>
                                                                        </td>
                                                                     </tr>
                                                               </table>
                                                               <table width="100%" border="0" cellpadding="4" cellspacing="0">
                                                                     <tr>
                                                                        <td valign="top">
                                                                           <hr class="gueststylehr" size="0.1" width="100%">
                                                                           <%#"<a href=\""+ DataBinder.Eval(Container.DataItem,"homepage")+" \" target=\"_blank\"><img src=\"webimages/icon/home.gif\" width=\"44\" height=\"16\" border=\"0\"></a>"%>

                                                                           <%#"<a target=\"_blank\" href=\"http://www.chinagz.net/ip/ipsearch.cgi?ip="+DataBinder.Eval(Container.DataItem,"ip")+"\"><img src=\"webimages/icon/ip.gif\" align=\"absmiddle\" height=\"16\" border=\"0\"></a>"%>

                                                                           <%#"<a href=\"http://search.tencent.com/cgi-bin/friend/user_show_info?ln="+DataBinder.Eval(Container.DataItem,"qq") +"\" target=\"_blank\"><img src=\"webimages/icon/qq.gif\" border=\"0\" width=\"35\" height=\"16\"></a>"%>

                                                                           <%# "<a href=\"mailto:"+DataBinder.Eval(Container.DataItem,"email")+"\"><img src=\"webimages/icon/email.gif\" width=\"42\" height=\"16\" border=\"0\"></a>"%>
                                                                              <a href="#"><img src="webimages/icon/postguest.gif" width="45" height="16" border="0"></a>
                                                                        </td>
                                                                     </tr>
                                                               </table>
                                                            </td>
                                                         </tr>
                                                   </table>
                                                </td>
                                             </tr>
                                       </table>
                                    </td>
                                 </tr>
                           </table>
                        </ItemTemplate>
                     </asp:DataList>
                     <BR>
               </td>
            </tr>
         </table>
         <table width="100%" border="0" cellspacing="0" cellpadding="2" align="center" height="9">
            <TBODY>
               <tr>
                     <td align="center">
                        <table class="gueststyleline" width="610" border="0" cellpadding="1" cellspacing="0" height="18">
                           <tr>
                                 <td height="24">
                                    <table width="100%" border="0" cellspacing="0" cellpadding="0" class="gueststylebg" height="18">
                                       <tr>
                                             <td width="35%" align="center" height="36">
                                                共有<asp:Label id="lblRecordCount" ForeColor="red" runat="server" />条记录当前为<asp:Label id="lblCurrentPage" ForeColor="red" runat="server" />/<asp:Label id="lblPageCount" ForeColor="red" runat="server" />页
                                             </td>
                                             <td align="center" height="36">
                                                <asp:LinkButton id="lbnPrevPage" Text="上一页" CommandName="prev" runat="server" />
                                                <asp:LinkButton id="lbnNextPage" Text="下一页" CommandName="next" runat="server" />
                                             </td>
                                       </tr>
                                    </table>
                                 </td>
                           </tr>
                        </table>
                     </td>
               </tr>
            </TBODY>
         </table>
   </form>
</body>

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

namespace CrystalReport
{
/// <summary>
/// _default 的摘要说明。
/// </summary>
public class _default : System.Web.UI.Page
{
   protected System.Web.UI.WebControls.DataList Myguest;
   protected System.Web.UI.WebControls.Label lblRecordCount;
   protected System.Web.UI.WebControls.Label lblCurrentPage;
   protected System.Web.UI.WebControls.Label lblPageCount;
   protected System.Web.UI.WebControls.LinkButton lbnPrevPage;
   protected System.Web.UI.WebControls.LinkButton lbnNextPage;
   protected int PageSize;
   protected int CurrentPage;
   protected int RecordCount;
   protected int PageCount;

   private void Page_Load(object sender, System.EventArgs e)
   {
         // 在此处放置用户代码以初始化页面
         PageSize=5;
         if(!Page.IsPostBack)
         {
            ListBind();
            CurrentPage = 0;
            ViewState["PageIndex"] = 0;
            //计算总共有多少记录
            RecordCount = CalculateRecord();
            lblRecordCount.Text = RecordCount.ToString();
            //计算总共有多少页
            if(RecordCount/PageSize==0)
            {
               PageCount = RecordCount/PageSize;
            }
            else
            {
            PageCount = RecordCount/PageSize+1;
            }
            lblPageCount.Text = PageCount.ToString();
            ViewState["PageCount"] = PageCount;
         }

   }

   #region Web 窗体设计器生成的代码
   override protected void OnInit(EventArgs e)
   {
         //
         // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
         //
         InitializeComponent();
         base.OnInit(e);
   }

   /// <summary>
   /// 设计器支持所需的方法 - 不要使用代码编辑器修改
   /// 此方法的内容。
   /// </summary>
   private void InitializeComponent()
   {
         this.lbnPrevPage.Click += new System.EventHandler(this.Page_OnClick);
         this.lbnNextPage.Click += new System.EventHandler(this.Page_OnClick);
         this.Load += new System.EventHandler(this.Page_Load);

   }
   #endregion

   //计算总共有多少条记录
   public int CalculateRecord()
   {
         SqlConnection Conn= new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnString"]);
         Conn.Open();
         int intCount;
         string strCount = "select count(*) as co from guest";
         SqlCommand MyComm = new SqlCommand (strCount,Conn);
         SqlDataReader dr = MyComm.ExecuteReader();
         if(dr.Read())
         {
            intCount = Int32.Parse(dr["co"].ToString());
         }
         else
         {
            intCount = 0;
         }
         dr.Close();
         return intCount;
   }

   ICollection CreateSource()
   {
         SqlConnection Conn= new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnString"]);
         Conn.Open();
         int StartIndex;
         //设定导入的起终地址
         StartIndex = CurrentPage*PageSize;
         string strSel = "Select * from guest order by postdate desc";
         DataSet ds = new DataSet();
         SqlDataAdapter MyAdapter = new SqlDataAdapter(strSel,Conn);
         MyAdapter.Fill(ds,StartIndex,PageSize,"guest");
         return ds.Tables["guest"].DefaultView;
   }

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

   private void lbnPrevPage_Click(object sender, System.EventArgs e)
   {

   }

   private void lbnNextPage_Click(object sender, System.EventArgs e)
   {

   }

   private void Page_OnClick(object sender, System.EventArgs e)
   {

         CurrentPage = (int)ViewState["PageIndex"];
         PageCount = (int)ViewState["PageCount"];
         string cmd =((LinkButton)sender).CommandName;

         //判断cmd，以判定翻页方向
         switch(cmd)
         {
            case "next":
               if(CurrentPage<(PageCount-1))
                     CurrentPage++;
               break;
            case "prev":
               if(CurrentPage>0)
                     CurrentPage--;
               break;
         }
         ViewState["PageIndex"] = CurrentPage;
         ListBind();
   }

}
}

欢迎光临站长论坛 (http://www.tzlink.com/bbs/)