一直想做一个属于自己的分页,
1:我试过用datapage,虽然是很好用,但是必须要配合datalist才能使用,感觉不太好
2:自己写分页控件,目前正在摸索中,关键是怎么分页的问题,有的是用datatable传进去分页,感觉效率有点低
3:就是今天我使用的方法,存储过程+Div+css分页了
说明:本人是毕业半年的菜鸟,以下程序全是按照自己的想法来写的,原创勿喷,并请大神们给出指导,谢谢了。
1:建好存储过程
ALTER procedure [dbo].[p_news_query]
@Page int
as
begin
select top new_id,new_title,new_url,new_content_text,create_time,user_name from
(select *,ROW_NUMBER() over(order by new_id desc ) as RowNumber from
(select new_id,new_title,new_url,new_content_text,
dbo.f_ConvertDate(a.create_time) create_time, b.user_name from xs_new a
left join xs_users b on b.user_no=a.create_user
)TI
) A
where A.RowNumber>(@Page-)* end
目前实验的是每页5条数据,传入当前页码就可以了
2:前台定义一个div ,用于显示
<div id="divPage" runat="server" class="divpage">
</div>
3:后台根据传入参数来拼html
目前是模仿博客园的模式,前后显示5条,多余的加...后到最后一条
StringBuilder sbr = new StringBuilder();
int ITotalCount = pageLogic.QueryNewsCount();
int IPage = ;
if (Request["p"] != null)
{
IPage = Convert.ToInt32(Request["p"]);
}
int IPageCount = ;
int ITotalPage = ITotalCount / IPageCount;
if (ITotalCount % IPageCount > )
{
ITotalPage += ;
} if (IPage != )
{
sbr.Append("<a href=\"news.aspx?p=" + (IPage - ).ToString() + "\">上一页</a>");
} if (ITotalPage <= )
{
for (int i = ; i <= ITotalPage; i++)
{
if (i == IPage)
{
sbr.Append("<a href=\"news.aspx?p=" + i.ToString() + "\" class=\"pageSelect\">" + i.ToString() + "</a>");
}
else
{
sbr.Append("<a href=\"news.aspx?p=" + i.ToString() + "\">" + i.ToString() + "</a>");
}
}
}
else
{ if (IPage - > && IPage + < ITotalPage)//前后都有的
{
sbr.Append("<a href=\"news.aspx?p=1\">1</a>...");
for (int i = IPage - ; i <= IPage + ; i++)
{
if (i == IPage)
{
sbr.Append("<a href=\"news.aspx?p=" + i.ToString() + "\" class=\"pageSelect\">" + i.ToString() + "</a>");
}
else
{
sbr.Append("<a href=\"news.aspx?p=" + i.ToString() + "\">" + i.ToString() + "</a>");
} }
sbr.Append("...<a href=\"news.aspx?p=" + ITotalPage.ToString() + "\">" + ITotalPage.ToString() + "</a>"); }
else if (IPage - <= )//前面不够,后面有多余
{
for (int i = ; i <= ; i++)
{
if (i == IPage)
{
sbr.Append("<a href=\"news.aspx?p=" + i.ToString() + "\" class=\"pageSelect\">" + i.ToString() + "</a>");
}
else
{
sbr.Append("<a href=\"news.aspx?p=" + i.ToString() + "\">" + i.ToString() + "</a>");
}
}
sbr.Append("...<a href=\"news.aspx?p=" + ITotalPage.ToString() + "\">" + ITotalPage.ToString() + "</a>");
}
else if (IPage + >= ITotalPage)//前面多余,后面不足
{
sbr.Append("<a href=\"news.aspx?p=1\">1</a>...");
for (int i = ITotalPage - ; i <= ITotalPage; i++)
{
if (i == IPage)
{
sbr.Append("<a href=\"news.aspx?p=" + i.ToString() + "\" class=\"pageSelect\">" + i.ToString() + "</a>");
}
else
{
sbr.Append("<a href=\"news.aspx?p=" + i.ToString() + "\">" + i.ToString() + "</a>");
}
} } }
if (IPage != ITotalPage)
{
sbr.Append("<a href=\"news.aspx?p=" + (IPage + ).ToString() + "\">下一页</a>");
}
divPage.InnerHtml = sbr.ToString();
rptNews.DataSource = pageLogic.QueryNews(IPage);
rptNews.DataBind();
4:实验效果