asp.net repeater控制使用示例详解

 
  Bob Dylan
  USA
  Columbia
  10.90
  1985


 
  Bonnie Tyler
  UK
  CBS Records
  9.90
  1988


 
  Dolly Parton
  USA
  RCA
  9.90
  1982


 
  Gary Moore
  UK
  Virgin records
  10.20
  1990


 
  Eros Ramazzotti
  EU
  BMG
  9.90
  1997

  protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                this.labPage.Text = "1";
                this.fenye();
            }
        }

        void fenye()
        {

            //获取数据源
            PagedDataSource pds = new PagedDataSource();
            DataTable ds = getalldata();
            pds.DataSource = ds.DefaultView;
            //设置允许分页
            pds.AllowPaging = true;
            //设置在单页上显示的条数
            pds.PageSize = 5;
            //获取或设置当前页的索引
            pds.CurrentPageIndex = Int32.Parse(labPage.Text) - 1;
            //绑定控件的数据源
            Repeater1.DataSource = pds;
            Repeater1.DataBind();
            //设置页的总数
            LabCountPage.Text = pds.PageCount.ToString();
            //设置按钮的可操作性
            lbtnDownPage.Enabled = true;
            lbtnFirstPage.Enabled = true;
            lbtnNextPage.Enabled = true;
            lbtnpritPage.Enabled = true;
            if (pds.CurrentPageIndex < 1)
            {
                lbtnFirstPage.Enabled = false;
                lbtnpritPage.Enabled = false;
            }
            if (pds.CurrentPageIndex == pds.PageCount - 1)
            {
                lbtnDownPage.Enabled = false;
                lbtnNextPage.Enabled = false;
            }

   
        }

        DataTable getalldata()
        {

            using (SqlConnection cons = new SqlConnection("server = .; database = newsrelease; integrated security=SSPI;"))
            {
                string liketitle = string.Format("select * from T_News");
                SqlDataAdapter da = new SqlDataAdapter(liketitle, cons);
                DataTable ds = new DataTable();
                da.Fill(ds);
                if (ds != null)
                {
                    return ds;
                }
                else
                {
                    return null;
                }

            }
        }

        //设置首页按钮功能
        protected void lbtnFirstPage_Click(object sender, EventArgs e)
        {
            labPage.Text = "1";
            this.fenye();
        }
        //设置上一页按钮功能
        protected void lbtnpritPage_Click(object sender, EventArgs e)
        {
            labPage.Text = (Int32.Parse(labPage.Text) - 1).ToString();
            this.fenye();
        }
        //设置下一页按钮功能
        protected void lbtnNextPage_Click(object sender, EventArgs e)
        {
            labPage.Text = (Int32.Parse(labPage.Text) + 1).ToString();
            this.fenye();
        }
        //设置尾页按钮功能
        protected void lbtnDownPage_Click(object sender, EventArgs e)
        {
            labPage.Text = LabCountPage.Text;
            this.fenye();
        }

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;

namespace RepeaterTest
{
public partial class Repeater : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
this.bind();
}
}

private DataSet dataSource
{
get
{
if (ViewState["ds"] != null)
{
return (DataSet)ViewState["ds"];
}
else
{
DataSet ds = DataSource.GetDataSet();
ViewState["ds"] = ds;
return ds;
}
}
}

private void bind()
{
DataSet ds = this.dataSource;

this.Repeater1.DataSource = ds.Tables["tbclass"];
this.Repeater1.DataBind();

this.Repeater2.DataSource = ds.Tables["tbclass"];
this.Repeater2.DataBind();
}

protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
{
if (e.CommandName == "expand")
{
LinkButton btn = (LinkButton)e.CommandSource;
GridView grid =(GridView)btn.Parent.FindControl("grid1");
if (btn.Text == "+")
{
btn.Text = "-";
grid.Visible = true;
}
else
{
btn.Text = "+";
grid.Visible = false;
}
}
}

protected void Repeater1_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
DataTable dt = this.dataSource.Tables["tbstu"];
LinkButton objButton = (LinkButton)e.Item.FindControl("btnExpand");
if (objButton != null && objButton.CommandArgument !="")
{
string classID = objButton.CommandArgument;
dt.DefaultView.RowFilter = "ClassID=" + classID;
DataTable dtStu = dt.DefaultView.ToTable();

GridView grid = (GridView)e.Item.FindControl("grid1");
grid.DataSource = dtStu;
grid.DataBind();
}
}

protected void Repeater2_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
DataTable dt = this.dataSource.Tables["tbstu"];
Label objlbl = (Label)e.Item.FindControl("lblclassid");
if (objlbl != null && objlbl.Text != "")
{
string classID = objlbl.Text;
dt.DefaultView.RowFilter = "ClassID=" + classID;
DataTable dtStu = dt.DefaultView.ToTable();

GridView grid = (GridView)e.Item.FindControl("grid2");
grid.DataSource = dtStu;
grid.DataBind();
}
}
}
}