Question

DataList AspNetPager 分页不对，该怎么改？

Sub gg()
Dim str As String = "Select * From product order by id DESC"
Dim ds As DataSet = CreateDataSetaa("SELECT count(*) s from product", "product")

AspNetPager1.RecordCount =
pager.RecordCount = ds.Tables[0].Rows.Count
Dim ConnString As String = ConnallString
Dim df As New DataSet
Dim objCmd As New OleDbDataAdapter(str, ConnString)
objCmd.Fill(df, pager.PageSize * (pager.CurrentPageIndex - 1), pager.PageSize, "product")

DataList1.DataSource = df
DataList1.DataBind()
End Sub

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
If IsPostBack = False Then
gg()
End If '在此处放置初始化页的用户代码
End Sub

Answer 1

不是很喜欢用datalist自带的翻页的。
我一般用的自己写的：加四个控件控制翻页方向（上一页，下一页。第一页，最末页）用“属性”或者“session”来存当前页数和总页数，点四个按钮的时候对页数进行修改就可以了。
strSql = "select top 10 * from tableName where id not in(select top " + 10 * Convert.Toint32(Session["PageId"]) + " id order by inputTime desc) order by inputTime desc"
条件自己加，not in里面的条件和外面的条件一样就可以了
上一页按钮
Session["PageId"]=(Convert.Toint32(Session["PageId"])-1).ToString()
下一页按钮
Session["PageId"]=(Convert.Toint32(Session["PageId"])+1).ToString()
第一页按钮
Session["PageId"]="1"
最末页按钮
Session["PageId"]=Session["PageCount"]
注意：上一页和下一页的时候需要判断PageId的大小范围是否在1到PageCount之间