参考的datalist分页helper

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;  
/// <summary>   
///Connection 的摘要说明   
/// </summary>   
public class SqlHelper  
{  
    public SqlConnection connect()//连接数据库   
    {  
        SqlConnection con = new SqlConnection(@"Data Source=.\SQL2005;Initial Catalog=school;Integrated Security=True");  
        con.Open();  
        return con;  
    }  
    public SqlDataReader sdr(string sqlstr)//DataReader读取   
    {  
        SqlCommand cmd = new SqlCommand(sqlstr, connect());  
        SqlDataReader dr = cmd.ExecuteReader();  
        return dr;  
    }  
    public DataList dl(string sqlstr,DataList DataListName)//将DataList与DataReader绑定   
    {  
        DataListName.DataSource = sdr(sqlstr);  
        DataListName.DataBind();  
        sdr(sqlstr).Close();  
        connect().Close();  
        return DataListName;  
    }  
    public DataSet datas(string sqlstr)  
    {  
        SqlDataAdapter sda = new SqlDataAdapter(sqlstr,connect());  
        DataSet dd = new DataSet();  
        sda.Fill(dd);  
        connect().Close();  
        return dd;  
    }  
    public void NewsScroll(string sqlstr,int i, ImageButton IB,HyperLink HL,string PostBackUrl)  
    {  
        DataSet ds=datas(sqlstr);  
        IB.ImageUrl = ds.Tables[0].Rows[i]["NewsImage"].ToString();  
        IB.PostBackUrl = PostBackUrl + "?Id=" + ds.Tables[0].Rows[i]["Id"].ToString();  
        HL.Text = ds.Tables[0].Rows[i]["NewsTitle"].ToString();  
        HL.NavigateUrl = IB.PostBackUrl;  
    }  
    public PagedDataSource ContentPaging(string sqlstr,int PageSize,int CurrentPageIndex,Label CurrentPageIndexLabel, Label DataSourceCount,Label PageCount,DataList DataListName)//内容分页函数   
    {  
        //PagedDataSource和DataSet绑定   
        PagedDataSource pds=new PagedDataSource();  
        pds.DataSource = datas(sqlstr).Tables[0].DefaultView;  
        pds.AllowPaging = true;  
        pds.PageSize = PageSize;  
        pds.CurrentPageIndex = CurrentPageIndex-1;  
        //   
        CurrentPageIndexLabel.Text = CurrentPageIndex.ToString();  
        DataSourceCount.Text = pds.DataSourceCount.ToString();  
        PageCount.Text = pds.PageCount.ToString();  
        //DataList和PagedDataSource绑定   
        DataListName.DataSource = pds;  
        DataListName.DataBind();  
        return pds;  
    }  
}