Data Binding ASP.Net Tutorial

  1. Home
  2. ASP.Net Tutorial
  3. Data Binding
  4. Creating a Custom User Interface for Paging
<%@ Page Language="C#" %>
 "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

    protected void pg_PagerCommand(object sender, DataPagerCommandEventArgs e)
    {
        e.NewMaximumRows = e.Item.Pager.MaximumRows;
        switch (e.CommandName)
        {
            case "Previous":
                if (e.Item.Pager.StartRowIndex > 0)
                    e.NewStartRowIndex = e.Item.Pager.StartRowIndex - 2;
                break;
            case "Next":
                e.NewStartRowIndex = e.Item.Pager.StartRowIndex + 2;
                break;
        }
    }



    DataPager Template


    
    

                    ID="lstProducts"
            DataSourceId="srcProducts"
            runat="server">
            
                

                                        id="itemPlaceholder"
                        runat="server" />
                    

                                    id="pg"
                    PageSize="2"
                    Runat="server">
                    
                                                    OnPagerCommand="pg_PagerCommand">
                            
                                                            id="lnkPrevious"
                                Text="Previous"
                                CommandName="Previous"
                                Runat="server" />
                                                            id="lnkNext"
                                Text="Next"
                                CommandName="Next"
                                Runat="server" />
                            
                        
                    
                
            
            
                

  •                 <%# Eval("Title") %>
                    

    •             
            
                        id="srcProducts"
                SelectCommand="SELECT Id, Title, Director FROM Product"
                ConnectionString='<%$ ConnectionStrings:Products %>'
                Runat="server" />
        

        


    File: Web.config

      
                 connectionString="Data Source=.\SQLEXPRESS;
             AttachDbFilename=|DataDirectory|MyDatabase.mdf;Integrated Security=True;User Instance=True" />