VS2005中使用AspNetPager控件成功事例代码(分页超快的哟)

效果图片:

显示页面的Html代码:

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="AspNetPager.aspx.cs" Inherits="AspNetPager" %>

<%@ Register Assembly="AspNetPager" Namespace="Wuqi.Webdiyer" TagPrefix="webdiyer" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

</head>

<body>

<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>

<asp:Button ID="Button1" runat="server" Text="Button" /><br />

<asp:GridView ID="GridView1" runat="server" Width="664px" Height="64px" OnRowDataBound="GridView1_RowDataBound">

</asp:GridView>

</div>

<br />

<asp:Label ID="CustomInfoClass" runat="server"></asp:Label><br />

<webdiyer:AspNetPager ID="AspNetPager1" runat="server" UrlPaging="true"

PageSize="10" ShowCustomInfoSection="Left" NumericButtonTextFormatString="[{0}]"

AlwaysShow="true" OnPageChanged="AspNetPager1_PageChanged" Width="296px" CustomInfoSectionWidth="60%" ShowInputBox="Never" TextAfterInputBox="" TextBeforeInputBox="" >

</webdiyer:AspNetPager>

</div>

</form>

</body>

</html>

显示页面的CS代码:

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.Text;

public partial class AspNetPager : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

if (!this.IsPostBack)

{

getLog();

}

private void getLog()

{

string con = ConfigurationManager.ConnectionStrings["AspNetPagerConnectionString"].ConnectionString;

SqlConnection dbconnection = new SqlConnection(con);

try

{

SqlCommand cmd = new SqlCommand("select count(newsid) from wqnews", dbconnection);

SqlDataAdapter sda = new SqlDataAdapter(cmd);

//wqnews可以是别名

DataSet ds = new DataSet("wqnews");

sda.Fill(ds, "wqnews");

this.AspNetPager1.RecordCount = Convert.ToInt32(ds.Tables[0].Rows[0][0]);

Response.Write(ds.Tables[0].Rows[0][0]);

}

catch (Exception e)

{

Response.Write(e.Message);

}

BindData();

}

private void BindData()

{

string con = ConfigurationManager.ConnectionStrings["AspNetPagerConnectionString"].ConnectionString;

SqlConnection dbconnection = new SqlConnection(con);

int RecordPage = (AspNetPager1.CurrentPageIndex - 1) * AspNetPager1.PageSize;

//string strsql =string.Format("select * from wqnews order by addtime desc",AspNetPager1.PageSize.ToString(),RecordPage.ToString());

SqlCommand cmd=new SqlCommand("select * from wqnews order by addtime desc",dbconnection);

DataSet ds= new DataSet();

SqlDataAdapter sda = new SqlDataAdapter(cmd);

sda.Fill(ds, RecordPage,AspNetPager1.PageSize, "wqnews");

this.GridView1.DataSource = ds.Tables[0];

this.GridView1.DataBind();

//动态设置用户自定义文本内容

sda.Dispose();

AspNetPager1.CustomInfoClass = "记录总数:<font color=\"blue\"><b>" + AspNetPager1.RecordCount.ToString() + "</b></font>";

AspNetPager1.CustomInfoClass += "总页数:<font color=\"blue\"><b>" + AspNetPager1.PageCount.ToString() + "</b></font>";

AspNetPager1.CustomInfoClass += "当前页:<font color=\"red\"><b>" + AspNetPager1.CurrentPageIndex.ToString() + "</b></font>";

CustomInfoClass.Text = AspNetPager1.CustomInfoClass;

}

protected void AspNetPager1_PageChanged(object src, Wuqi.Webdiyer.PageChangedEventArgs e)

{

this.AspNetPager1.CurrentPageIndex = e.NewPageIndex;

BindData();

StringBuilder sb = new StringBuilder("<script Language=\"Javascript\"><!--\n");

sb.Append("var el=document.all;");

sb.Append(this.GridView1.ClientID);

sb.Append(".scrollIntoView(true);");

sb.Append("<");

sb.Append("/");

sb.Append("script>");

if (!ClientScript.IsStartupScriptRegistered("scrollScript"))

{

ClientScript.IsStartupScriptRegistered(sb.ToString());

}

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)

{

if (e.Row.RowType == DataControlRowType.DataRow)

{

e.Row.Attributes.Add("onMouseOver", "c=this.style.backgroundColor;this.style.backgroundColor='eafae9';");

e.Row.Attributes.Add("onMouseOut", "this.style.backgroundColor=c;");

}

posted on 2010-04-11 12:42 追梦人RUBY 阅读(242) 评论(0) 收藏举报