datalist分页之二

来源：互联网发布：淘宝如何看卖家销售额编辑：程序博客网时间：2024/09/21 09:26

简单的DATALIST分页用PAGEDATASOURCE~~
在设计器里加入和一个DATALIST ID设为 DataList1
    <asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>
                <asp:LinkButton ID="ix" runat="server" OnClick="SubmitButton_Click">首页</asp:LinkButton>
                <asp:LinkButton ID="pp" runat="server" OnClick="SubmitButton_Click">上一页</asp:LinkButton>

                <asp:LinkButton ID="np" runat="server" OnClick="SubmitButton_Click">下一页</asp:LinkButton>
                <asp:LinkButton ID="lp" runat="server" OnClick=" SubmitButton_Click">尾页</asp:LinkButton>
                <asp:Label ID="Label2" runat="server" Text="0" Visible="False"></asp:Label>
//================================代码页中加入=============
//page_load 里加入
if (!IsPostBack)
        {
            this.Label2.Text = "1";
            this.Label1.Text = "共 "+this.bind().PageCount.ToString()+" 页 "+this.bind ().DataSourceCount .ToString ()+" 条记录每页显示 "+this.bind ().Count .ToString ()+" 条记录";
            this.DataList1.DataSource = this.bind();
            this.DataList1.DataBind();
        //  this.bind().Tables[0].Clear();
        }
///// 复制下边两个事件
public   void SubmitButton_Click(Object sender, EventArgs e)
    {
        switch (((LinkButton)sender).ID)
        {
            case "ix":
        {
            this.Label2.Text = "1";
            this.DataList1.DataSource = this.bind();
            this.DataList1.DataBind();
          }
        break;
    case "pp":
        {

            this.Label2.Text = Convert.ToString((int.Parse(this.Label2.Text.ToString()) - 1));
            if (int.Parse(this.Label2.Text.ToString()) <= 1)
            {
                this.Label2.Text = "1";
                return;
            }
            this.DataList1.DataSource = this.bind();
            this.DataList1.DataBind();
        }
        break;
        case "np":
            {
                if (int.Parse(this.Label2.Text.ToString()) >=this.bind().PageCount)
                {
                    return;
                }
            this.Label2.Text = Convert .ToString ((int.Parse(this.Label2.Text.ToString()) + 1));
            this.DataList1.DataSource = this.bind();
            this.DataList1.DataBind();
        }
        break;
    case "lp":
        {
            this.Label2.Text =  this.bind ().PageCount .ToString ();
            this.DataList1.DataSource = this.bind();
            this.DataList1.DataBind();
        }
        break;
        }

    }
    public  PagedDataSource  bind()
    {
        SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Sql_con"].ToString()); //修改链接
        SqlDataAdapter adap = new SqlDataAdapter("select * from Ws_Case order by id desc", conn);
        DataSet ds = new DataSet();
        adap.Fill(ds, "0");
        PagedDataSource pds = new PagedDataSource();
        pds.DataSource = ds.Tables[0].DefaultView ;
        pds.AllowPaging = true;
        pds.PageSize =4;
        int cp;
        cp =  int.Parse (this.Label2.Text.ToString());
        cp = cp - 1;
        pds.CurrentPageIndex = cp;

        return pds;
    }