030. asp.net中DataList数据绑定跳转(两种方式)的完整示例

时间：2022-02-24 16:38:50

前台代码:

<%@ Page Language="C#" AutoEventWireup="true"  CodeFile="Default.aspx.cs" Inherits="_Default" MaintainScrollPositionOnPostback="true" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >

<head runat="server">

    <title>无标题页</title>

</head>

<body>

    <form id="form1" runat="server" style=" font-size: 9pt">

    <div>

        <table style="width: 590px; height: 218px;" cellpadding="0" cellspacing="0">

            <tr>

                <td style="width: 112px; height: 240px">

                    <asp:DataList ID="DataList1" runat="server" Width="239px" CellPadding="0"

                        Height="61px" onitemcommand="DataList1_ItemCommand"

                        onitemdatabound="DataList1_ItemDataBound">

                        <HeaderTemplate>

                            <table border="1" cellpadding="0" cellspacing="0" style="width: 300px; text-align: center;">

                                <tr>

                                    <td colspan="4" style="font-size: 16pt; color: #006600; text-align: center">

                                       分页显示DataList控件中的数据</td>

                                </tr>

                                <tr>

                                    <td style="height: 19px; width: 50px; color: #669900;">

                                        编号</td>

                                    <td style="height: 19px; width: 50px; color: #669900;">

                                        姓名</td>

                                    <td style="height: 19px; width: 50px; color: #669900;">

                                        性别</td>

                                    <td style="width: 150px; height: 19px; color: #669900;">

                                        内编号</td>

                                </tr>

                            </table>

                        </HeaderTemplate>

                        <ItemTemplate>

                            <table border="1" cellpadding="0" cellspacing="0" style="width: 300px; color: #000000;

                                text-align: center;">

                                <tr>

                                    <td style="height: 21px; width: 50px; color: #669900;">

                                        <asp:Label ID="lblStuID" runat="server" Text='<%# Eval("cardNo") %>'></asp:Label></td>

                                    <td style="height: 21px; width: 50px; color: #669900;">

                                        <asp:Label ID="lblStuName" runat="server" Text='<%# Eval("name") %>'></asp:Label></td>

                                    <td style="height: 21px; width: 50px; color: #669900;">

                                        <asp:Label ID="lblStuSex" runat="server" Text='<%# Eval("sex") %>'></asp:Label></td>

                                    <td style="width: 150px; height: 21px; color: #669900;">

                                        <asp:Label ID="lblstuHobby" runat="server" Text='<%# Eval("cardBound") %>'></asp:Label></td>

                                </tr>

                            </table>

                        </ItemTemplate>

                        <FooterTemplate>

                            <table style="width: 500px" cellpadding="0" cellspacing="0">

                                <tr>

                                    <td style="width: 71px; height: 4px" valign="middle">

                                        共有<asp:Label ID="labCount" runat="server" ForeColor="#FF3300" Width="12px"/>页</td>

                                    <td style="width: 73px; height: 4px" valign="middle">

                                        当前<asp:Label ID="labNowPage" runat="server" ForeColor="Brown">1</asp:Label>页</td>

                                    <td style="width: 46px; height: 4px" valign="middle">

                                        <asp:LinkButton ID="lnkbtnFirst" runat="server" CommandName="first"

                                            Font-Underline="False" ForeColor="Black" Width="43px">首页</asp:LinkButton></td>

                                    <td style="width: 55px; height: 4px" valign="middle">

                                        <asp:LinkButton ID="lnkbtnFront" runat="server" CommandName="pre"

                                            Font-Underline="False" ForeColor="Black" Width="62px">上一页</asp:LinkButton></td>

                                    <td style="width: 51px; height: 4px" valign="middle">

                                        <asp:LinkButton ID="lnkbtnNext" runat="server" CommandName="next"

                                            Font-Underline="False" ForeColor="Black" Width="61px">下一页</asp:LinkButton></td>

                                    <td style="width: 29px; height: 4px" valign="middle">

                                        <asp:LinkButton ID="lnkbtnLast" runat="server" Font-Overline="False" CommandName="last"

                                            Font-Underline="False" ForeColor="Black" Width="38px">尾页</asp:LinkButton></td>

<%--文本框输入方式实现的页面跳转--%>

                                   <%-- <td style="width: 200px; height: 4px" valign="middle">&nbsp;&nbsp; 跳转至：<asp:TextBox ID="txtPage" runat="server" Width="25px" Height="21px"></asp:TextBox>

                                        <asp:Button ID="Button1" runat="server" CommandName="search" Text="GO"

                                            Height="19px" />

                                        <asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server"

                                            ControlToValidate="txtPage" ErrorMessage="请输入数字（除了数值0）"

                                            ValidationExpression="[1-9]+(\d)*"></asp:RegularExpressionValidator>

                                    </td>--%>   

<%--下拉列表方式实现的页面跳转--%>

                                    <td style="width: 200px; height: 4px" valign="middle">&nbsp;&nbsp; 跳转至：

                                    <asp:DropDownList ID="DropDownList1" runat="server"></asp:DropDownList>

                                        <asp:Button ID="Button1" runat="server" CommandName="search" Text="GO"

                                            Height="19px" />

                                    </td>

                                </tr>

                            </table>

                        </FooterTemplate>

                    </asp:DataList>

                </td>

            </tr>

            <tr>

                <td style="width: 112px; height: 12px">

                </td>

            </tr>

        </table>

    </div>

    </form>

</body>

</html>

后台cs代码:

using System;

using System.Data;

using System.Configuration;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page

{

    protected static PagedDataSource ps = new PagedDataSource();//创建一个分页数据源的对象且一定要声明为静态

    protected void Page_Load(object sender, EventArgs e)

    {

        if (!IsPostBack)

        {

            Bind();//数据绑定

        }

    }

    //进行数据绑定的方法

    public void Bind(int CurrentPage)

    {

        //实例化SqlConnection对象

        SqlConnection sqlCon = new SqlConnection();

        //实例化SqlConnection对象连接数据库的字符串

        sqlCon.ConnectionString = "server=.;uid=sa;pwd=123.456;database=TYW";

        //定义SQL语句

        string SqlStr = "select * from card";

        //实例化SqlDataAdapter对象

        SqlDataAdapter da = new SqlDataAdapter(SqlStr, sqlCon);

        //实例化数据集DataSet

        DataSet ds = new DataSet();

        da.Fill(ds, "cardInfo");

        ps.DataSource = ds.Tables["cardInfo"].DefaultView;

        ps.AllowPaging = true; //是否可以分页

        ps.PageSize = ; //每页显示的条数

        ps.CurrentPageIndex = CurrentPage; //取得当前页的页码

        this.DataList1.DataSource = ps;

        this.DataList1.DataKeyField = "cardNo";

        this.DataList1.DataBind();

    }

    protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)

    {

        switch (e.CommandName)

        {

            //以下5个为 捕获用户点击 上一页 下一页等时发生的事件

            case "first"://第一页

                ps.CurrentPageIndex = ;

                Bind(ps.CurrentPageIndex);

                break;

            case "pre"://上一页

                ps.CurrentPageIndex = ps.CurrentPageIndex - ;

                Bind(ps.CurrentPageIndex);

                break;

            case "next"://下一页

                ps.CurrentPageIndex = ps.CurrentPageIndex + ;

                Bind(ps.CurrentPageIndex);

                break;

            case "last"://最后一页

                ps.CurrentPageIndex = ps.PageCount - ;

                Bind(ps.CurrentPageIndex);

                break;

            case "search"://页面跳转页

                if (e.Item.ItemType == ListItemType.Footer)

                {

                    int PageCount = int.Parse(ps.PageCount.ToString());

                    DropDownList ddl = e.Item.FindControl("DropDownList1") as DropDownList;

                    int MyPageNum = ;

                    MyPageNum = Convert.ToInt32(ddl.SelectedValue);

                    if (MyPageNum <=  || MyPageNum > PageCount)

                        Response.Write("<script>alert('请输入页数并确定没有超出总页数！')</script>");

                    else

                        Bind(MyPageNum - );

                }

                break;

        }

    }

    protected void DataList1_ItemDataBound(object sender, DataListItemEventArgs e)

    {

        if (e.Item.ItemType == ListItemType.Footer)

        {

            //以下六个为得到脚模板中的控件,并创建变量

            Label CurrentPage = e.Item.FindControl("labNowPage") as Label;

            Label PageCount = e.Item.FindControl("labCount") as Label;

            LinkButton FirstPage = e.Item.FindControl("lnkbtnFirst") as LinkButton;

            LinkButton PrePage = e.Item.FindControl("lnkbtnFront") as LinkButton;

            LinkButton NextPage = e.Item.FindControl("lnkbtnNext") as LinkButton;

            LinkButton LastPage = e.Item.FindControl("lnkbtnLast") as LinkButton;

            CurrentPage.Text = (ps.CurrentPageIndex + ).ToString();//绑定显示当前页

            PageCount.Text = ps.PageCount.ToString();//绑定显示总页数

            if (ps.IsFirstPage)//如果是第一页,首页和上一页不能用

            {

                FirstPage.Enabled = false;

                PrePage.Enabled = false;

            }

            if (ps.IsLastPage)//如果是最后一页"下一页"和"尾页"按钮不能用

            {

                NextPage.Enabled = false;

                LastPage.Enabled = false;

            }

            DropDownList ddl = e.Item.FindControl("DropDownList1") as DropDownList;

            ddl.Items.Clear();

            for (int i = ; i <= ps.PageCount; i++)

            {

                ddl.Items.Add(i.ToString());

            }

        }

    }

}

相关文章