Custom Page Items

In some scenarios we need to page the data source but not using a standard partition. For example, in a page with a list of customers, we may be interested to have a pager that contains all the letters, and when a letter is clicked, the customers whose name starts with that letter are shown.

The PagerDataSource has support for that scenario. In order to provide custom page items instead of the usual numbers, we have to set the UseCustomPageItems property to true and we also have to supply the custom page items using the CustomPageItems collection.

One implication of this mode is that each page of data can have any number of items and it is not limited by the PageSize. If we are using a DataSourceControl to supply the data to the PagerDataSource, it has to support paging and the startRowIndexParameter will contain the page item clicked (the maximumRowsParameter is not used in this case). If we are not using a DataSourceControl to supply the data to the PagerDataSource we can supply the data in the PageChanged event as the example Paging a DataSource (2) shows.

In this sample what we are going to use ficticious data showing IP addresses, access time and data downloaded. What we want is to populate the GridView with that data ( obtained from an ObjectDataSource) and let the user to see the data grouped by country. The PagerDataSource is used for this. In this sample, the custom page items are created in code, but they can be created also using the design-time editor.

The source code for this page is shown after the live sample.

IP addresses list

Id	IPAddress	ConnectionTime	KB downloaded	Country
4	240.98.27.81	9/6/2010 8:48:47 PM	953	US
6	75.33.235.140	9/6/2010 8:13:47 AM	325	US
9	238.252.253.209	9/6/2010 4:21:47 AM	397	US
13	23.146.184.156	9/7/2010 12:02:47 AM	130	US
14	136.157.253.182	9/7/2010 5:40:47 AM	536	US
19	246.217.22.122	9/6/2010 4:17:47 AM	637	US
26	214.66.175.153	9/5/2010 9:51:47 PM	333	US
36	140.208.88.109	9/6/2010 10:16:47 AM	508	US
39	251.140.96.150	9/6/2010 1:52:47 AM	348	US
44	169.143.34.106	9/6/2010 12:29:47 PM	224	US
56	35.152.240.203	9/5/2010 3:32:47 AM	471	US
65	144.132.59.224	9/5/2010 10:50:47 PM	530	US
81	68.163.81.85	9/5/2010 12:37:47 AM	665	US
89	24.129.53.231	9/6/2010 4:18:47 PM	397	US
95	247.111.170.225	9/5/2010 6:36:47 PM	744	US
97	222.39.163.241	9/5/2010 1:23:47 PM	739	US
100	209.67.224.67	9/5/2010 7:24:47 PM	67	US

Sample source code

The ASPX file for this sample is:.

                    <%@
                    Page Language="C#" MasterPageFile="~/DefaultMaster.master" AutoEventWireup="true" CodeFile="CustomPageItems.aspx.cs" Inherits="CustomPageItems" Title="Custom Page Items" %>

                    <%@
                    Register Assembly="PagerDataSource" Namespace="Manu.Web.UI.WebControls" TagPrefix="manu" %>

                    <asp:Content 
                            ID="Content1" ContentPlaceHolderID="Content" Runat="Server">

                        <h2>IP addresses list</h2>

                        <manu:PagerDataSource
                    ID="PagerDataSource1"
                    runat="server"
                
                            DataSourceID="ObjectDataSource1"
                    UseCustomPageItems="True">

                        </manu:PagerDataSource>

                        <asp:GridView 
                            ID="GridView1" runat="server" AutoGenerateColumns="False" 
                                        
                                                BackColor="#335789"

                            BorderColor="#133769"
                    BorderStyle="Solid"
                    BorderWidth="1px"
                    
                    DataKeyNames="Id"

                            DataSourceID="PagerDataSource1"
                    CssClass="gridview"
                    AllowSorting="True">

                            <Columns>

                                <asp:BoundField
                    DataField="Id"
                    HeaderText="Id"
                    ReadOnly="True"
                    
                                    SortExpression="Id"
                    />

                                <asp:BoundField
                    DataField="IPAddress"
                    HeaderText="IPAddress" 

                                    SortExpression="IPAddress"
                    />

                                <asp:BoundField
                    DataField="ConnectionTime"
                    HeaderText="ConnectionTime"
                    
                                    SortExpression="ConnectionTime"
                    />

                                <asp:BoundField
                    DataField="KB downloaded"
                    HeaderText="KB downloaded"
                    
                                    SortExpression="KB
                            downloaded" />

                                <asp:BoundField
                    DataField="Country"
                    HeaderText="Country" 

                                    SortExpression="Country"
                    />

                            </Columns>

                            <RowStyle
                    BackColor="White"

                                ForeColor="#436799" />

                            <HeaderStyle
                    ForeColor="White"
                    />

                        </asp:GridView>

                        <manu:PagerDataSource
                    ID="PagerDataSource2"
                    runat="server"
                
                            DataSourceID="PagerDataSource1"
                    UseCustomPageItems="True">

                        </manu:PagerDataSource>

                        <asp:ObjectDataSource
                    ID="ObjectDataSource1"
                    runat="server"
                    TypeName="IPDataDAL"
                
                            SortParameterName="sortedBy"  SelectMethod="GetDataByCountry" 

                                        SelectCountMethod="CountAll"
                    EnablePaging="True"

                            MaximumRowsParameterName="maxRows" StartRowIndexParameterName="countryId" 

                                            OldValuesParameterFormatString="original_{0}">

                        </asp:ObjectDataSource>

                    </asp:Content>

The code-behind file (ASPX.CS) is:

 
                    using System;

                    using System.Collections.Specialized;

                    public partial
                    class CustomPageItems
                : System.Web.UI.Page

                    {

                        protected void
                Page_Load(object sender, 
                    EventArgs e)

                        {

                            // the first time, set the custom
                        pages items

                            if (!IsPostBack) {

                                string
                    image = "<img src='images/{0}.gif' />";

                                StringCollection
                    customPages = new StringCollection();

                                // adds each image
                        to the collection of custom page items

                                foreach
                    (string code in
                    Countries.codes) {

                                    customPages.Add(String.Format(image,
                    code));

                                }

                                // set the custom
                        page items for each PagerDataSource

                                PagerDataSource1.CustomPageItems.AddRange(customPages);

                                PagerDataSource2.CustomPageItems.AddRange(customPages);

                            }

                        }

                    }