Trong asp.net thì có rất nhiều cách để phân trang như: sử dụng paging trong Datagrid, hay sử dụng các câu lệnh SQL như cursor hay dùng bảng tạm… Nhưng đây là một cách khác. Sử dụng method Fill của DataAdapter để thêm vào DataSet các row theo index (chỉ mục).
Source code:
WebForm1.aspx
WebForm1.aspx.cs:
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
/********************************************************************
created: 2005/11/01
created: 1:11:2005 14:51
filename: WebForm1.aspx.cs
file base: WebForm1.aspx
file ext: cs
author: Tran Vinh
purpose: Paging in Datalist and Repeater
*********************************************************************/
namespace paging_datalist
{
///
/// Summary description for WebForm1.
///
public class WebForm1 : System.Web.UI.Page
{
protected System.Web.UI.WebControls.DataList DataList1;
protected System.Web.UI.WebControls.TextBox TextBox2;
protected System.Web.UI.WebControls.LinkButton LinkButton1;
protected System.Web.UI.WebControls.DataGrid DataGrid1;
protected System.Web.UI.WebControls.Repeater Repeater1;
protected System.Web.UI.WebControls.Label Label1;
protected System.Web.UI.WebControls.LinkButton LinkButton2;
private void Page_Load(object sender, System.EventArgs e)
{
if(!IsPostBack)
{
Label1.Text=”0″;
TextBox2.Text=”5″;
Build_List();
}
}
private void Build_List()
{
try
{
int ItemOfPage=int.Parse(TextBox2.Text);
string dsn = “uid=sa;pwd=123456;server=(local);database=Northwind”;
SqlConnection con = new SqlConnection(dsn);
con.Open();
string strsql=”select * from Products”;
SqlDataAdapter da = new SqlDataAdapter(strsql,con);
DataSet ds = new DataSet();
int index = int.Parse(Label1.Text);
da.Fill(ds,index,ItemOfPage,”Products”);
DataList1.DataSource=ds.Tables["Products"].DefaultView;
DataList1.DataBind();
Repeater1.DataSource=ds.Tables["Products"].DefaultView;
Repeater1.DataBind();
con.Close();
}
catch(Exception ex)
{
Response.Write(ex.Message+” “+ex.StackTrace);
}
}
#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: This call is required by the ASP.NET Web Form Designer.
//
InitializeComponent();
base.OnInit(e);
}
///
/// Required method for Designer support – do not modify
/// the contents of this method with the code editor.
///
private void InitializeComponent()
{
this.LinkButton1.Click += new System.EventHandler(this.LinkButton1_Click);
this.LinkButton2.Click += new System.EventHandler(this.LinkButton2_Click);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
private void LinkButton1_Click(object sender, System.EventArgs e)
{
int index = int.Parse(Label1.Text);
index-=int.Parse(TextBox2.Text);
index=index<0?0:index;
Label1.Text= index.ToString();
Build_List();
}
private void LinkButton2_Click(object sender, System.EventArgs e)
{
int index = int.Parse(Label1.Text);
index+=int.Parse(TextBox2.Text);
Label1.Text= index.ToString();
Build_List();
}
}
}
