ShouCangList.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;

public partial  class ShouCangList : System.Web.UI.Page
{
    SqlData da = new SqlData();
    protected void Page_Load(object sender, EventArgs e)
    {
        Bind();
    }
    protected void Bind()
    {
        Label4.Text = "收藏夹";

        int currentPage = Convert.ToInt32(this.currentPage.Text);
        PagedDataSource pds = new PagedDataSource();
        string sqlstring = @"SELECT * FROM [dbo].[tb_News] a
                            INNER JOIN [dbo].[shoucang] b ON a.ID =b.[newsid]
                            WHERE b.userid = '" + Session["uname"] + "' order by issueDate desc";
        DataSet ds = da.datesetExecute(sqlstring, "tbNews2");
        pds.DataSource = ds.Tables["tbNews2"].DefaultView;
        pds.AllowPaging = true;
        pds.PageSize = 10;
        pds.CurrentPageIndex = currentPage - 1;
        this.firstPage.Enabled = true;
        this.frontPage.Enabled = true;
        this.nextPage.Enabled = true;
        this.lastPage.Enabled = true;

        if (currentPage == 1)
        {
            this.firstPage.Enabled = false;
            this.frontPage.Enabled = false;
        }
        if (currentPage == pds.Count)
        {
            this.nextPage.Enabled = false;
            this.lastPage.Enabled = false;
        }
        this.totalPage.Text = Convert.ToString(pds.PageCount);
        this.dlstNews.DataSource = pds;
        this.dlstNews.DataKeyField = "id";
        this.dlstNews.DataBind();
    }

    protected void firstPage_Click(object sender, EventArgs e)
    {
        this.currentPage.Text = "1";
        this.Bind();
    }

    protected void frontPage_Click(object sender, EventArgs e)
    {
        this.currentPage.Text = Convert.ToString(Convert.ToInt32(this.currentPage.Text) - 1);
        this.Bind();