ShowNewsInformation.aspx.cs

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

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

using System;
using System.Data;
using System.Configuration;
using System.Collections;
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.Linq;
using System.Data.SqlClient;
// 下载于www.51aspx.com 
public partial class ShowNewsInformation : System.Web.UI.Page
{
    SqlData da = new SqlData();
    protected void Page_Load(object sender, EventArgs e)
    {
        Bind();
    }
    protected void Bind()
    {
        int count = Convert.ToInt32(Request.QueryString["id"]);
        switch (count)
        {
            case 1:
                Label4 .Text  = "时事新闻";
                break;
            case 2:
                Label4.Text = "环球经济";
                break;
            case 3:
                Label4.Text = "军事世界";
                break;
            case 4:
                Label4.Text = "科学技术";
                break;
            case 5:
                Label4.Text = "生活理财";
                break;
            case 6:
                Label4 .Text  = "社会百态";
                break;
            case 7:
                Label4.Text = "世界体育";
                break;
            case 8:
                Label4 .Text  = "娱乐综艺";
                break;
        }
        int currentPage = Convert.ToInt32(this.currentPage.Text);
        PagedDataSource pds = new PagedDataSource();
        string sqlstring = "select * from tb_News where Categories='" + Label4 .Text .Trim () + "' order by issueDate desc";
        DataSet ds = da.datesetExecute(sqlstring, "tbNews");
        pds.DataSource = ds.Tables["tbNews"].DefaultView;
        pds.AllowPaging = true;
        pds.PageSize = 10;
        pds.CurrentPageIndex = currentPage - 1;
        this.firstPage.Enabled = true;
        this.frontPage.Enabled = true;