asp.net翻页代码无效，，，急急
我用的是vs2008，数据库是sql 2005,c#
更多后台代码
using BLL;
public partial class gengduo : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//bd();//这句话加上就提示：无法找到表 0。
}
}
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 = 2;
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: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>
[解决办法]
DAL.DataBase d = new DAL.DataBase(); DataSet ds = new DataSet(); //d.runSQL("select * from news where newsID=" + Request["id"].ToString() [color=#FF0000]+ "order (order前面加个空格)[/color]by newsID DESC", ref ds);[color=#FF0000]这里注释了？？？[/color] PagedDataSource p = new PagedDataSource(); p.DataSource = ds.Tables[0].DefaultView; p.AllowPaging = true; p.PageSize = 2;
[解决办法]
DAL.DataBase d = new DAL.DataBase(); DataSet ds = new DataSet(); d.runSQL("select * from news where newsID=" + Request["id"].ToString() [color=#FF0000]+ "order (order前面加个空格)[/color]by newsID DESC", ref ds);[color=#FF0000]这里注释了？？？[/color] PagedDataSource p = new PagedDataSource(); p.DataSource = ds.Tables[0].DefaultView; p.AllowPaging = true; p.PageSize = 2;
[解决办法]
用个分页空间不是很好吗
[解决办法]
看错问题了，我以为“无法找到表 0。”呢...
lz想url分页，aspnetpage也可以实现，不用你写这么代码...
lz断点跑下看看吧...
[解决办法]
p.CurrentPageIndex = cp; 改成
p.CurrentPageIndex = Request["page"]==null?1:Convert.ToInt32(Request["page"]);
[解决办法]
http://www.webdiyer.com/controls/aspnetpager
[解决办法]