Re: Paging in datalist??

rexlin — Wed, 18 Oct 2006 06:04:10 GMT

Hi,khushak:

You can use PagedDataSource. Here is the sample:

Private Sub Page_Load()Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
2

3        Dim sqlconn As New SqlConnection(ConfigurationSettings.AppSettings.Get("sqlserver"))
4        sqlconn.Open()
5        Dim sqlda As New SqlDataAdapter("select * from vote_items", sqlconn)
6        Dim dt As New DataTable
7        sqlda.Fill(dt)
8        sqlda.Dispose()
9
10
11        Dim pds As New PagedDataSource
12

14        pds.DataSource = dt.DefaultView
15        '==================================================
16        pds.AllowPaging = True
17        pds.PageSize = 3
18
19

20        Dim currentpage As Integer
21        If Request.QueryString.Get("page") <> Nothing Then
22            currentpage = Convert.ToInt32(Request.QueryString("Page"))
23        Else
24            currentpage = 1
25        End If
26

27        pds.CurrentPageIndex = currentpage - 1
28
29        Label1.Text = "共有记录" & pds.DataSourceCount & "条，分" & pds.PageCount & "页显示，每页显示" & _
30        pds.PageSize & "条，当前为第" & currentpage & "页："
31
32
33        If Not pds.IsFirstPage Then
34            lnkPrev.NavigateUrl = Request.CurrentExecutionFilePath & "?Page=" & Convert.ToInt32(currentpage - 1)
35            lnkFirst.NavigateUrl = Request.CurrentExecutionFilePath & "?Page=1"
36        End If
37
38        If Not pds.IsLastPage Then
39            lnkNext.NavigateUrl = Request.CurrentExecutionFilePath & "?Page=" & Convert.ToInt32(currentpage + 1)
40            lnkLast.NavigateUrl = Request.CurrentExecutionFilePath & "?Page=" & pds.PageCount
41        End If
42
43        '

44 rp.DataSource = pds
45 rp.DataBind()

Re: Paging in datalist??

yyy8347 — Wed, 18 Oct 2006 05:48:19 GMT

1.1 does not provide the paging in datalist. the DataGrid control—natively supports paging .

But you can create a Pager Control for DataList . See Creating a Pager Control for ASP.NET .

Paging in datalist??

khushak — Wed, 18 Oct 2006 04:43:03 GMT

Hi,

In my asp.net page i am using datalist and i want to paging but i am not find the any propertie onf paging in datalist i am using .net 1.1.

is 1.1 not provide the paging in datalist

if yes then how??

regard

Data Presentation Controls

Re: Paging in datalist??

Re: Paging in datalist??

Paging in datalist??