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);
}
}
}
}
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);
}
}
}
}
设断点跟踪一下试试吧