前台 html
<TABLE cellSpacing=0 cellPadding=0 width="100%" align=center border=0>
<TBODY>
<TR bgColor=#ffffff>
<TD align=right><asp:label id=records runat="server" CssClass="style"></asp:label><asp:label id=page_all runat="server" CssClass="style"></asp:label><asp:label id=current_page runat="server" CssClass="style"></asp:label><FONT face=宋体> <asp:linkbutton id=btnFirst οnclick=PagerButtonClick Runat="server" CssClass="style" CausesValidation="False" CommandArgument="0">首 页</asp:linkbutton> <asp:linkbutton id=btnPrev οnclick=PagerButtonClick Runat="server" CssClass="style" CausesValidation="False" CommandArgument="prev">上一页</asp:linkbutton><FONT face=宋体> </FONT> <asp:linkbutton id=btnNext οnclick=PagerButtonClick Runat="server" CssClass="style" CausesValidation="False" CommandArgument="next">下一页</asp:linkbutton> <asp:linkbutton id=btnLast οnclick=PagerButtonClick Runat="server" CssClass="style" CausesValidation="False" CommandArgument="last">末 页</asp:linkbutton> 转到第 <asp:textbox id=TextBox1 Width="20" runat="server" BorderStyle="Groove"></asp:textbox> 页<asp:button id=Button1 runat="server" Text="Go"></asp:button></FONT> </TD></TR></TBODY></TABLE>
后台CS
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Configuration;
using System.Data.SqlClient;
using functions;
namespace Allianceforum
{
/// <summary>
/// WebForm2 的摘要说明。
/// </summary>
public class ivanbbs_list : System.Web.UI.Page
{
protected System.Web.UI.WebControls.DataGrid DataGrid1;
protected System.Web.UI.WebControls.Label records;
protected System.Web.UI.WebControls.Label page_all;
protected System.Web.UI.WebControls.Label current_page;
protected System.Web.UI.WebControls.LinkButton btnFirst;
protected System.Web.UI.WebControls.LinkButton btnPrev;
protected System.Web.UI.WebControls.LinkButton btnNext;
protected System.Web.UI.WebControls.LinkButton btnLast;
protected System.Web.UI.WebControls.TextBox TextBox1;
protected System.Web.UI.WebControls.Button Button1;
protected System.Web.UI.WebControls.Button But1;
public int startIndex=0;
private void Page_Load(object sender, System.EventArgs e)
{
if(!this.Page.IsPostBack)
{
ViewState["sqlstr"] = "select id,UName,Hit,Title,ReleaseTime,State,Revert from infoTable where smallClassID="+BID+" order by State Desc";
//ViewState["sqlstr"] = "select id,UName,Hit,Title,ReleaseTime,State,Revert from infoTable order by State Desc";
DataGridDataBind();
}
// 在此处放置用户代码以初始化页面
}
public void chage(object sender,DataGridPageChangedEventArgs e)
{
startIndex = e.NewPageIndex*DataGrid1.PageSize;
DataGrid1.CurrentPageIndex=e.NewPageIndex;
DataGridDataBind();
}
private void DataGridDataBind()
{
string dsn = ConfigurationSettings.AppSettings["conn_DB"].ToString();
Security security = new Security();
SqlConnection myConnection = new SqlConnection(dsn);
SqlDataAdapter myCommand = new SqlDataAdapter(ViewState["sqlstr"].ToString(),myConnection);
DataSet ds = new DataSet();
//DataGrid1.PageSize = 31;
try
{
//从指定的索引开始取PageSize条记录
myCommand.Fill(ds,startIndex,DataGrid1.PageSize,"CurDataTable");
//填充数据集
myCommand.Fill(ds,"AllDataTable");
//设置DataGrid控件实际要显示的项数
DataGrid1.VirtualItemCount = ds.Tables["AllDataTable"].Rows.Count;
//显示分页状态
records.Text = "记录总数<font color=red>"+ds.Tables["AllDataTable"].Rows.Count.ToString()+"</font>条,";
if(ds.Tables["AllDataTable"].Rows.Count<=DataGrid1.PageSize)
{
page_all.Text = "共<font color=red>1</font>页";
ViewState["numm"]="1";
}
else
{
page_all.Text = "共<font color=red>"+System.Convert.ToString(ds.Tables["AllDataTable"].Rows.Count/DataGrid1.PageSize+1)+"</font>页";
ViewState["numm"]=System.Convert.ToInt32(System.Convert.ToString(ds.Tables["AllDataTable"].Rows.Count/DataGrid1.PageSize+1));
}
current_page.Text = "当前页为第<font color=red>"+(DataGrid1.CurrentPageIndex+1).ToString()+"</font>页";
//以下统计查询的结果
// for(int i = 0;i<ds.Tables["AllDataTable"].Rows.Count;i++)
// {
// sum += System.Convert.ToDecimal(ds.Tables["AllDataTable"].Rows[i][4].ToString());
// }
//
//进行数据绑定
DataGrid1.DataSource = ds.Tables["CurDataTable"];
DataGrid1.DataBind();
}
catch(System.Exception ex)
{
this.Response.Write(ex.ToString());
}
}
public void PagerButtonClick(object sender,EventArgs e)
{
//取得按钮单击时传递的命令参数
string arg = ((LinkButton)sender).CommandArgument.ToString();
switch(arg)
{
//如果单击的是"下一页"
case "next":
//如果当前页不是最后一页
if(DataGrid1.CurrentPageIndex<(DataGrid1.PageCount - 1))
{
//设置DataGrid的当前页索引为下一页面
DataGrid1.CurrentPageIndex += 1;
}
break;
//如果点击的是"前一页"
case "prev":
//如果当前页不是首页
if(DataGrid1.CurrentPageIndex>0)
{
//设置DataGrid的当前页索引为上一页面
DataGrid1.CurrentPageIndex -=1;
}
break;
//如果点击的是"末页"
case "last":
//设置当前的索引为最后一页
DataGrid1.CurrentPageIndex = (DataGrid1.PageCount - 1);
break;
//默认为"首页"
default:
//设置当前页的索引为首页
DataGrid1.CurrentPageIndex = System.Convert.ToInt32(arg);
break;
}
startIndex = DataGrid1.PageSize*DataGrid1.CurrentPageIndex;
DataGridDataBind();
}
private void Button1_Click(object sender, System.EventArgs e)
{
if(TextBox1.Text.Trim().ToString()!="")
{
int x=System.Convert.ToInt32(TextBox1.Text.ToString());
if(x<=System.Convert.ToInt32(ViewState["numm"].ToString()))
{
DataGrid1.CurrentPageIndex=x-1;
startIndex = DataGrid1.PageSize*DataGrid1.CurrentPageIndex;
DataGridDataBind();
TextBox1.Text="1";
}
else
{
DataGrid1.CurrentPageIndex=System.Convert.ToInt32(ViewState["numm"].ToString())-1;
startIndex = DataGrid1.PageSize*DataGrid1.CurrentPageIndex;
DataGridDataBind();
TextBox1.Text="1";
}
}
}
#region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.But1.Click += new System.EventHandler(this.But1_Click);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
}
}