本控件提供的相关内容: 三个文件: 1.Pager.cs 2.WebForm.aspx 3 WebForm.aspx.cs 其中1为翻页控件. 2及3是用作测试的文档及源文件. 试用需要做的事: 1.根据提示转成相应的文件.及建立相关项目编译 2.根据数据库连接信息建立相应的数据库(TestDataBase)及数据表(News) 3.建立相对应的站点.
--------Pager.cs 服务器控件源文件---------------------------------------------------------------------------- using System; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.ComponentModel;
namespace C_Pager { public class Pager : Control, INamingContainer { [Description("操作员选择不同页时产生的页更新事件,通过此事件处理把旧页面显示信息更新到选择页对应的数据信息")] public event EventHandler PageChanged;
private int rectotal = 0; private int pagesize = 10; private int curpage = 0; private int lang = 0 ; private int pagetotal = 0;
private string firstpagetext ="<FONT face=webdings>9</FONT>"; private string prevpagetext = "<FONT face=webdings>3</FONT>"; private string nextpagetext = "<FONT face=webdings>4</FONT>"; private string lastpagetext = "<FONT face=webdings>:</FONT>";
protected virtual void temp_Click(object sender, EventArgs e) { if (PageChanged != null) { PageChanged(this,e); } }
#region Pager控件使用帮助及参数说明 /* 本控件带有三个自定义属性和一个方法.具体如下: 属性: RecTotal 记录总数 默认值:0 PageSize 每页记录数 默认值:0 CurPage 当前页 默认值:0 Lang 版本语言 默认值:0 注:0为中文版,1为英文版 方法: PagerBind 绑定当前自定义控件,如不绑定,该控件则不能显示到页面上 */ #endregion
#region 控件属性列表
[Category("分页控制"),Description("数据集所有页记录总数")] public int RecTotal { get { return rectotal; } set { rectotal = value; } }
[Category("分页控制"),Description("每页显示记录数量")] public int PageSize { get { return pagesize; } set { pagesize = value; } }
[Category("分页控制"),Description("当前显示页")] public int CurPage { get { return curpage; } set { curpage = value; } }
[Category("分页控制"),Description("数据集页总数")] public int PageTotal { set { pagetotal = value; } }
[Category("分页控制"),Description("翻页条显示语言别,0为中文,1为英文")] public int Lang { get { return lang; } set { lang = value; } }
[Category("分页控制"),Description("首页按钮文本,例如可用:第一页")] public string FirstPageText // { get { return firstpagetext; } set { firstpagetext = value; } }
[Category("分页控制"),Description("前页按钮文本,例如可用:上一页")] public string PrevPageText { get { return prevpagetext; } set { prevpagetext = value; } }
[Category("分页控制"),Description("下页按钮文本,例如可用:下一页")] public string NextPageText { get { return nextpagetext; } set { nextpagetext = value; } }
[Category("分页控制"),Description("尾页按钮文本,例如可用:最后页")] public string LastPageText { get { return lastpagetext; } set { lastpagetext = value; } }
#endregion
protected override void CreateChildControls() { ViewState["FirstPageText"]= firstpagetext; ViewState["PrevPageText"] = prevpagetext; ViewState["NextPageText"] = nextpagetext; ViewState["LastPageText"] = lastpagetext; Label lbl_PageInfo = new Label(); //0 lbl_PageInfo.Text = "尚未绑定"; Controls.Add(lbl_PageInfo); LinkButton btn_First = new LinkButton(); //1 btn_First.Text = ViewState["FirstPageText"].ToString(); Controls.Add(btn_First); btn_First.Visible = false; btn_First.Click += new System.EventHandler(btn_First_Click);
Controls.Add(new LiteralControl(" ")); //2
LinkButton btn_Pre = new LinkButton(); //3 btn_Pre.Text = ViewState["PrevPageText"].ToString(); Controls.Add(btn_Pre); btn_Pre.Visible = false; btn_Pre.Click += new System.EventHandler(btn_Pre_Click);
Controls.Add(new LiteralControl(" ")); //4
LinkButton btn_Next = new LinkButton(); //5 btn_Next.Text = ViewState["NextPageText"].ToString(); Controls.Add(btn_Next); btn_Next.Visible = false; btn_Next.Click += new System.EventHandler(btn_Next_Click);
Controls.Add(new LiteralControl(" ")); //6
LinkButton btn_Last = new LinkButton(); //7 btn_Last.Text = ViewState["LastPageText"].ToString(); Controls.Add(btn_Last); btn_Last.Visible = false; btn_Last.Click += new System.EventHandler(btn_Last_Click); Controls.Add(new LiteralControl(" ")); //8
Label lbl_1 = new Label(); //9 lbl_1.Text = "转到"; lbl_1.Visible = false; Controls.Add(lbl_1);
DropDownList drop_CurPage = new DropDownList(); //10 drop_CurPage.Items.Add("0"); Controls.Add(drop_CurPage); drop_CurPage.AutoPostBack = true; drop_CurPage.Visible = false; drop_CurPage.SelectedIndexChanged += new System.EventHandler(drop_CurPage_SelectedIndexChanged);
Label lbl_2 = new Label(); //11 lbl_2.Text = "页"; lbl_2.Visible = false; Controls.Add(lbl_2); }
protected override void OnPreRender(EventArgs e) { if (!Page.IsPostBack) { StartVar(); PagerBind(); } }
protected void StartVar() //初始各参数.希望只执行一次 { ViewState["RecTotal"] = rectotal; ViewState["PageSize"] = pagesize; ViewState["CurPage"] = curpage; ViewState["Lang"] = lang ; ViewState["PageTotal"] = pagetotal; }
#region 相关方法及事件 public void PagerBind() { ViewState["PageTotal"]=((int)ViewState["RecTotal"]%(int)ViewState["PageSize"]>0) ? (int)ViewState["RecTotal"]/(int)ViewState["PageSize"]+1 : (int)ViewState["RecTotal"]/(int)ViewState["PageSize"]; //页总数 if ((int)ViewState["Lang"]==0) { ((Label)Controls[0]).Text="共<font color=red>"+ViewState["RecTotal"].ToString()+"</font>条信息 <font color=red>"+ViewState["PageSize"].ToString()+"</font>条/页 当前<font color=red>"+((int)ViewState["CurPage"]+1).ToString()+"</font>/<font color=red>"+ViewState["PageTotal"].ToString()+"</font>页 "; } else { ((Label)Controls[0]).Text="Total<font color=red>"+ViewState["RecTotal"].ToString()+"</font>Info <font color=red>"+ViewState["PageSize"].ToString()+"</font>/Page Current<font color=red>"+((int)ViewState["CurPage"]+1).ToString()+"</font>/<font color=red>"+ViewState["PageTotal"].ToString()+"</font>Page "; ((Label)Controls[9]).Text = "To"; ((Label)Controls[11]).Text = "Page"; } ((DropDownList)Controls[10]).Items.Clear();
int i=0; do { ((DropDownList)Controls[10]).Items.Add(Convert.ToString(i+1)); i++; } while (i<(int)ViewState["PageTotal"]);
((DropDownList)Controls[10]).SelectedIndex = ((DropDownList)Controls[10]).Items.IndexOf(((DropDownList)Controls[10]).Items.FindByValue(Convert.ToString((int)ViewState["CurPage"]+1)));
((LinkButton)Controls[1]).Visible = true; ((LinkButton)Controls[3]).Visible = true; ((LinkButton)Controls[5]).Visible = true; ((LinkButton)Controls[7]).Visible = true; ((Label)Controls[9]).Visible = true; ((Label)Controls[11]).Visible = true; ((DropDownList)Controls[10]).Visible = true;
((LinkButton)Controls[1]).Enabled = true; ((LinkButton)Controls[3]).Enabled = true; ((LinkButton)Controls[5]).Enabled = true; ((LinkButton)Controls[7]).Enabled = true;
if ((int)ViewState["CurPage"]==0) { ((LinkButton)Controls[1]).Enabled = false; ((LinkButton)Controls[3]).Enabled = false; ((LinkButton)Controls[5]).Enabled = true; ((LinkButton)Controls[7]).Enabled = true; } if ((int)ViewState["CurPage"]==( (int)ViewState["PageTotal"]-1) ) { ((LinkButton)Controls[1]).Enabled = true; ((LinkButton)Controls[3]).Enabled = true; ((LinkButton)Controls[5]).Enabled = false; ((LinkButton)Controls[7]).Enabled = false; } if (( (int)ViewState["PageTotal"]-1) == 0 ) { ((LinkButton)Controls[1]).Enabled = false; ((LinkButton)Controls[3]).Enabled = false; ((LinkButton)Controls[5]).Enabled = false; ((LinkButton)Controls[7]).Enabled = false; }
CurPage = (int)ViewState["CurPage"]; RecTotal = (int)ViewState["RecTotal"]; PageSize = (int)ViewState["PageSize"]; CurPage = (int)ViewState["CurPage"]; Lang = (int)ViewState["Lang"]; PageTotal = (int)ViewState["PageTotal"]; }
private void drop_CurPage_SelectedIndexChanged(object sender, System.EventArgs e) { ViewState["CurPage"] = ((DropDownList)Controls[10]).SelectedIndex; PagerBind();
if (PageChanged != null) temp_Click(this, EventArgs.Empty); }
private void btn_First_Click(object sender, System.EventArgs e) { ViewState["CurPage"] = 0; PagerBind();
if (PageChanged != null) temp_Click(this, EventArgs.Empty); }
private void btn_Pre_Click(object sender, System.EventArgs e) { ViewState["CurPage"] = (int)ViewState["CurPage"]-1; PagerBind();
if (PageChanged != null) temp_Click(this, EventArgs.Empty); }
private void btn_Next_Click(object sender, System.EventArgs e) { ViewState["CurPage"] = (int)ViewState["CurPage"]+1; PagerBind();
if (PageChanged != null) temp_Click(this, EventArgs.Empty); }
private void btn_Last_Click(object sender, System.EventArgs e) { ViewState["CurPage"] = (int)ViewState["PageTotal"]-1; PagerBind();
if (PageChanged != null) temp_Click(this, EventArgs.Empty); } #endregion } } ----------------------------------end------------------------------------------------------------------------
---------WebForm1.aspx 控件测试页面文件------------------------------------------------------------- <%@ Page language="c#" Codebehind="WebForm1.aspx.cs" AutoEventWireup="false" Inherits="MyWebControll.WebForm1" %> <%@ Page language="c#" Codebehind="WebForm1.aspx.cs" AutoEventWireup="false" Inherits="MyWebControll.WebForm1" %> <%@ Register TagPrefix="cc1" Namespace="C_Pager" Assembly="C_Pager" %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" > <HTML> <HEAD> <title>WebForm1</title> <meta content="Microsoft Visual Studio .NET 7.1" name="GENERATOR"> <meta content="C#" name="CODE_LANGUAGE"> <meta content="JavaScript" name="vs_defaultClientScript"> <meta content="http://schemas.microsoft.com/intellisense/ie5" name="vs_targetSchema"> </HEAD> <body MS_POSITIONING="GridLayout"> <form id="Form1" method="post" runat="server"> <FONT face="宋体"> <cc1:pager id="Pager1" runat="server" PageSize="4"></cc1:pager> <asp:DataGrid id="DataGrid1" style="Z-INDEX: 101; LEFT: 24px; POSITION: absolute; TOP: 56px" runat="server" Width="600px" Height="8px"></asp:DataGrid></FONT></form> </body> </HTML> ---------------------------------end------------------------------------------------------
------------WebForm1.aspx.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.Data.SqlClient; using System.Data.OleDb;
namespace MyWebControll { /// <summary> /// WebForm1 的摘要说明。 /// </summary> public class WebForm1 : System.Web.UI.Page { protected C_Pager.Pager Pager1; protected OleDbConnection conn; protected System.Web.UI.WebControls.DataGrid DataGrid1; protected OleDbCommand cmd; private void Page_Load(object sender, System.EventArgs e) { // 在此处放置用户代码以初始化页面
conn=new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath("DataBase\\TestDataBase.mdb")); if(!Page.IsPostBack) { DataBind(0); } }
#region Web 窗体设计器生成的代码 override protected void OnInit(EventArgs e) { // // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。 // InitializeComponent(); base.OnInit(e); } /// <summary> /// 设计器支持所需的方法 - 不要使用代码编辑器修改 /// 此方法的内容。 /// </summary> private void InitializeComponent() { this.Pager1.PageChanged += new System.EventHandler(this.Change); this.Load += new System.EventHandler(this.Page_Load);
} #endregion
private void DataBind(int CurPage) //数据绑定方法 { cmd=new OleDbCommand("select * from news order by id ",conn); OleDbDataAdapter adapter=new OleDbDataAdapter(cmd); DataSet ds=new DataSet(); adapter.Fill(ds,Pager1.PageSize*CurPage,Pager1.PageSize,"news");
DataGrid1.DataSource=ds.Tables["news"]; DataGrid1.DataBind();
cmd=new OleDbCommand("select count(id) from news",conn); conn.Open(); Pager1.RecTotal = (int)cmd.ExecuteScalar(); Pager1.DataBind(); conn.Close(); }
private void Change(object sender, System.EventArgs e) { DataBind(Pager1.CurPage); //得到当前页记录集绑定到DataGird表上 }
} }
---------------------------------------------end--------------------------------------------------
如果哪位朋友需要项目文件的话,也可以发邮件到我的邮箱向我索取的在(.net2003)已调试通过的项目代码(和下面的源代码一样) 我的邮箱是:[email protected]

|