Test Programme <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default3.aspx.cs" Inherits="Default3" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title></title> </head> <body> <form id="form1" runat="server"> <div> <asp:ScriptManager ID="ScriptManager1" runat="server"> </asp:ScriptManager> <br /> <asp:UpdatePanel ID="UpdatePanel1" runat="server" UpdateMode="Conditional"> <ContentTemplate> <asp:DataList ID="DataList1" runat="server"> <ItemTemplate> <table> <tr><td> <%# DataBinder.Eval(Container.DataItem,"c2name") %><br> </td></tr> </table> </ItemTemplate> </asp:DataList> <br /> </ContentTemplate> <Triggers> <asp:AsyncPostBackTrigger ControlID="Button1" /> <asp:AsyncPostBackTrigger ControlID="Button2" /> </Triggers> </asp:UpdatePanel> <asp:Button ID="Button1" runat="server" Text="Button" οnclick="Button1_Click" /> <asp:Button ID="Button2" runat="server" οnclick="Button2_Click" Text="Button" /> </div> </form> </body> </html> using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data.SqlClient; using System.Data; public partial class Default3 : System.Web.UI.Page { public PagedDataSource pagedDataSource = new PagedDataSource(); int xx = 1; protected void Page_Load(object sender, EventArgs e) { SqlConnection con = new SqlConnection(); //create the first connection with table cat1 con.ConnectionString = "server=.//KIDD;User ID=sa;Password=19860914;database=db_02"; SqlDataAdapter adpt = new SqlDataAdapter("select * from cat2", con); DataSet ds = new DataSet(); adpt.Fill(ds,"cat2"); DataView dv = new DataView(); pagedDataSource.DataSource=ds.Tables["cat2"].DefaultView; pagedDataSource.AllowPaging = true; pagedDataSource.PageSize = 1; pagedDataSource.CurrentPageIndex = Convert.ToInt32("0"); pagedDataSource.CurrentPageIndex = Convert.ToInt32(Page.Session["page"]); DataList1.DataSource = pagedDataSource; DataList1.DataBind(); } protected void Button1_Click(object sender, EventArgs e) { xx = pagedDataSource.CurrentPageIndex; xx++; Page.Session["page"] = xx; UpdatePanel1.Update(); } protected void Button2_Click(object sender, EventArgs e) { Page.Session["page"] = 0; UpdatePanel1.Update(); } }