Question

asp.net翻页代码上下页不管用，，急

这是更多后台代码
using BLL;
public partial class gengduo : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{ }

public void bd()
{
DAL.DataBase d = new DAL.DataBase();
DataSet ds = new DataSet();
d.runSQL("select * from news where newsID=" + Request["id"].ToString() + "order by newsID DESC", ref ds);

PagedDataSource p = new PagedDataSource();
p.DataSource = ds.Tables[0].DefaultView;
p.AllowPaging = true;
p.PageSize = 3;

int cp = 0;
if (Request["page"] != null)
{
cp = Convert.ToInt32(Request["page"]);

}
p.CurrentPageIndex = cp;
if (!p.IsFirstPage)
{
HyperLink1.NavigateUrl = "?id=" + Request["id"].ToString() + "&page=" + (cp - 1);

}
if (!p.IsLastPage)
{
HyperLink2.NavigateUrl = "?id=" + Request["id"].ToString() + "&page=" + (cp + 1);
}
HyperLink3.NavigateUrl = "?id=" + Request["id"].ToString() + "&page=" + 0;
HyperLink4.NavigateUrl = "?id=" + Request["id"].ToString() + "&page=" + (p.PageCount - 1);
showPage.Text = "第" + (p.CurrentPageIndex + 1) + "页共" + p.PageCount + "页";
DataList1.DataSource = p;
DataList1.DataBind();
d.close();

}
}

这是更多页面
<asp:DataList ID="DataList1" runat="server" DataSourceID="SqlDataSource1" >

<HeaderTemplate><ul></HeaderTemplate>
<ItemTemplate>
<li>
<asp:HyperLink ID="HyperLi" runat="server" Target="_blank" NavigateUrl='<%#Eval("newsID","shouNews.aspx?id={0}") %>' Text='<%#Eval("newsTitle").ToString().Length >17?Eval("newsTitle").ToString().Substring(0,15)+"...":Eval("newsTitle").ToString() %>'></asp:HyperLink>
<asp:Literal ID="Literal1" runat="server" Text='<%#"<i>"+Convert.ToDateTime(Eval("newsDate")).ToString("yyyy-MM-dd") +"</i>" %>'></asp:Literal>
</li>
</ItemTemplate>
<FooterTemplate></ul></FooterTemplate>
</asp:DataList>
<asp:Literal ID="showPage" runat="server"></asp:Literal>
<asp:HyperLink ID="HyperLink1" runat="server">上一页</asp:HyperLink>
<asp:HyperLink ID="HyperLink2" runat="server">下一页</asp:HyperLink>
<asp:HyperLink ID="HyperLink3" runat="server">首页</asp:HyperLink>
<asp:HyperLink ID="HyperLink4" runat="server">尾页</asp:HyperLink>

Answer 1

方法可以用，我经常这么用，但数据库查询语句有问题，给你个参考

if (nowpage == 1)
{
str = "select top " + size + " * from com_people order by id desc ";
}
else
{
int temp1 ;
temp1 = size * (nowpage - 1);
str = "select top " + size + " * from com_people where id<(SELECT Min(id) FROM (SELECT TOP " + temp1 + " id FROM com_people ORDER BY id desc) AS T) order by id desc";
}
DataSet ds = da.GetDataSet(str);

Answer 2

我比较懒，都是直接用自带的分页功能，定义了 PageIndexChanging 就搞定了，自定义的一直想搞，一直懒得搞。。。

占个前排坐等答案

Answer 3

翻页我觉得用存储过程写比较好

Answer 4

最好别用PagedDataSource ，数据量大的时候就很慢了
不是有那个aspnetpage分页控件吗，好用都不要啊

追问

分页控件，效果不好，我是vs2008 c# ,

Answer 5

可以用 AspNetPager 这个我在用比较不错 各种设置和各种简单 不过需要写存储过程的