在控件的page_load中写如下代码
Dim objConn As SqlConnection = New SqlConnection(SQLHelper.ConnnectionString)
Dim objCommand As SqlDataAdapter
Dim userID As String = Session("UserID")
If CommonMethod.IsManager(userID) Then
objCommand = New SqlDataAdapter("select * from Questions ", objConn)
Else
Dim selectStr As String = "select * from Questions where userID=" & userID
objCommand = New SqlDataAdapter(selectStr, objConn)
End If
Dim ds As DataSet = New DataSet()
objCommand.Fill(ds)
Dim objPds As PagedDataSource = New PagedDataSource()
objPds.DataSource = ds.Tables(0).DefaultView
objPds.AllowPaging = True
objPds.PageSize = 5
Dim CurPage As Integer
If Not (Request.QueryString("Page") Is Nothing) Then
CurPage = Convert.ToInt32(Request.QueryString("Page"))
Else
CurPage = 1
End If
objPds.CurrentPageIndex = CurPage - 1
lblCurrentPage.Text = "CurPage:" + CurPage.ToString()
If Not objPds.IsFirstPage Then
lnkPrev.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage - 1)
End If
If Not objPds.IsLastPage Then
lnkNext.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage + 1)
End If
Repeater1.DataSource = objPds
Repeater1.DataBind()
objConn.Close()
我是得到具体哪一类型的用户的信息的, 在做的时候,你们可以根据自己的需要对适配器进行处理。
这个的知识点是要想到用 PagedDataSource 这个类,问题解决了。