![Repeater和DataList Repeater和DataList](http://static13.photo.sina.com.cn/middle/6b138dadt7497f0d67f0c&690)
因为项目需要,要用到DataList和Repeater的分页,但这两种加载数据的控件,本身并不自带分页功能,要控制查询语句来进行分页,但是语句过于复杂,或是条件太多,语句很难写,但用PagedDataSource进行分页,就简单多了,代码分配清晰,容易理解。
下面实例是用PagedDataSource类实现DataList控件的数据分页,也可用于Repeater。
页面后台代码
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data;
using System.Data.SqlClient;
public partial class Demo : System.Web.UI.Page
{
protected SqlConnection conn; //添加数据库的操作对象
protected SqlDataAdapter da;
protected DataSet ds;
protected SqlCommand comm;
protected void Page_Load(object sender, EventArgs e)
{
getArticle();
}
private void getArticle() //取得Article数据
{
conn = new SqlConnection("server=127.0.0.1;database=ObtainEmployment;user id=sa;password=;");//取连接字符串,建立连接
da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand("SELECT top 50 * FROM db_Article where checkup='1' ORDER BY intime DESC ", conn);
ds = new DataSet();
try
{
conn.Open();
da.Fill(ds, "Article");
conn.Close();
}