AspNetPage分页查询使用方法分页风格

最新推荐文章于 2019-01-10 15:50:38 发布

「已注销」

最新推荐文章于 2019-01-10 15:50:38 发布

阅读量661

点赞数

分类专栏： ASP.NET

ASP.NET 专栏收录该内容

21 篇文章 0 订阅

订阅专栏

一、绑定方法
private void DataBindDataTable(string whereCondition)

{

//whereCondition是查询的条件
IList<Sr_TakeNameListEntity> list = SrTakeNameListManage.GetSrTabkeNameAllList(whereCondition);
AspNetPager1.RecordCount = list.Count;//设置总条数

PagedDataSource pds = new PagedDataSource();
pds.DataSource = list;
pds.AllowPaging = true;
pds.CurrentPageIndex = AspNetPager1.CurrentPageIndex - 1;//当前页的索引
pds.PageSize = AspNetPager1.PageSize;//每页显示的记录数
GridView1.DataSource = pds;
GridView1.DataBind();
}

二、页面首次加载
if(!IsPostBack){
Session["vkey"]=" 1=1 ";//查询条件的关键字
DataBindDataTable(Session["vkey"].ToString());
}

三、AspNetPage事件
protected void AspNetPager1_PageChanged(object sender, EventArgs e)
{

string bb = Request["sid"].ToString().Trim();
DataBindDataTable(Session["vkey"].ToString());
}

四、搜索按钮单击事件
protected void btnAllSearch_Click(object sender, EventArgs e)
{
AspNetPager1.CurrentPageIndex = 1;
Session["vkey"] = " 1=1 ";
DataBindDataTable(Session["vkey"].ToString());
}

五、asp.net页面内容

第二行：

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

显示分页内容处：

<webdiyer:AspNetPager ID="AspNetPager1" runat="server" CssClass="anpager" CurrentPageButtonClass="cpb"
CustomInfoHTML="第%CurrentPageIndex%页，共%PageCount%页，每页%PageSize%条"
FirstPageText="首页" Font-Size="9pt"
LastPageText="尾页" NextPageText="下一页"
PageIndexBoxType="DropDownList"
PrevPageText="上一页"
ShowCustomInfoSection="Left" ShowPageIndexBox="Always" PageSize="12"
AlwaysShow="true" SubmitButtonText="Go"
TextAfterPageIndexBox="页" TextBeforePageIndexBox="转到"
onpagechanged="AspNetPager1_PageChanged" >
</webdiyer:AspNetPager>

或者：

/*网易风格*/
.anpager .cpb {background:#1F3A87 none repeat scroll 0 0;border:1px solid #CCCCCC;color:#FFFFFF;font-weight:bold;margin:5px 4px 0 0;padding:4px 5px 0;}
.anpager a {background:#FFFFFF none repeat scroll 0 0;border:1px solid #CCCCCC;color:#1F3A87;margin:5px 4px 0 0;padding:4px 5px 0;text-decoration:none}
.anpager a:hover{background:#1F3A87 none repeat scroll 0 0;border:1px solid #1F3A87;color:#FFFFFF;}

<h4>拍拍网风格：</h4>
<webdiyer:AspNetPager CssClass="paginator" CurrentPageButtonClass="cpb" ID="AspNetPager3" runat="server" RecordCount="228"
FirstPageText="首页" LastPageText="尾页" NextPageText="下一页" PrevPageText="上一页">

/*拍拍网风格*/
.paginator { font: 11px Arial, Helvetica, sans-serif;padding:10px 20px 10px 0; margin: 0px;}
.paginator a {padding: 1px 6px; border: solid 1px #ddd; background: #fff; text-decoration: none;margin-right:2px}
.paginator a:visited {padding: 1px 6px; border: solid 1px #ddd; background: #fff; text-decoration: none;}
.paginator .cpb {padding: 1px 6px;font-weight: bold; font-size: 13px;border:none}
.paginator a:hover {color: #fff; background: #ffa501;border-color:#ffa501;text-decoration: none;}

<h4>迅雷风格：</h4>
<webdiyer:AspNetPager CssClass="pages" CurrentPageButtonClass="cpb" ID="AspNetPager4" runat="server" RecordCount="228"
FirstPageText="首页" LastPageText="尾页" NextPageText="下一页" PrevPageText="上一页">
</webdiyer:AspNetPager>

/*迅雷风格*/
.pages { color: #999 }
.pages a, .pages .cpb { text-decoration:none;float: left; padding: 0 5px; border: 1px solid #ddd;background: #ffff;margin:0 2px; font-size:11px; color:#000;}
.pages a:hover { background-color: #E61636; color:#fff;border:1px solid #E61636; text-decoration:none;}
.pages .cpb { font-weight: bold; color: #fff; background: #E61636; border:1px solid #E61636;}
.code{font-weight:bold;color:blue}