彩票走势图

在控件的 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 这个类，问题解决了。