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.Data.SqlClient;
using System.Data.OleDb;public partial class Alerts : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
             //SELECT NewsHeader,RowID, NewsTime, NewsID FROM NewsDetailed WHERE (NewsID = 7) order by NewsTime desc
            //初始化连接
            string StrConnection = System.Configuration.ConfigurationManager.AppSettings["Wcon"];
            
            OleDbConnection Objconnection = new OleDbConnection(StrConnection);
            Objconnection.Open();            string strsql = "SELECT NewsHeader,RowID, NewsTime, NewsID FROM NewsDetailed WHERE (NewsID = 7) order by NewsTime desc";
            OleDbDataAdapter MyAdapter = new OleDbDataAdapter(strsql,Objconnection);
            //建立Dataset对象ds,利用Adapter的fill方法吧SQL命令执行的结果导入DataSet对象
            DataSet ds = new DataSet();
            MyAdapter.Fill(ds,"news");
            Objconnection.Close();
            int CurPage;
            if (Request.QueryString["Page"] != null && Convert.ToInt32(Request.QueryString["Page"]) > 0)
            {
                CurPage = Convert.ToInt32(Request.QueryString["Page"]);
            }
            else
            {
                CurPage = 1;
            }
            PagedDataSource ps = new PagedDataSource();
            ps.DataSource = ds.Tables["news"].DefaultView;
            ps.AllowPaging = true;
            //每页显示的条数
            ps.PageSize = 28;
            onePage.Text = ps.PageSize.ToString();
            //求数据总数
            allMsg.Text = ps.DataSourceCount.ToString();
            ps.CurrentPageIndex = CurPage - 1;
            //求总页
            allPages.Text = ps.PageCount.ToString();
            nowPage.Text = CurPage.ToString();
            //将数据源与控件绑定
            DataList1.DataSource = ps;
            DataList1.DataBind();
            //上一页
            if (!ps.IsFirstPage)
            {
                firstPage.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=1";
                prePage.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage-1);
            }
            //下一页
            if (!ps.IsLastPage)
            {
                nextPage.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage+1);
                endPage.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(ps.PageCount);
            }
        }
    }
}