Repeatコントロールの使い方と使用
3170 ワード
//1 REPEATER ( )
RepeaterBind.DataSource = ds.Tables["testTable"];
RepeaterBind.DataBind();
<asp:Repeater id="RepeaterBind" runat="server">
<ItemTemplate>
<li>
<%#DataBinder.Eval(Container.DataItem,"TitleOfCourtesy")%>
<%#DataBinder.Eval(Container.DataItem,"LastName")%>
<%#DataBinder.Eval(Container.DataItem,"FirstName")%>
</li>
</ItemTemplate>
</asp:Repeater>
-------------------------------------------------
//2 REPEATER
<asp:Repeater id="RepeaterBind" runat="server">
<HeaderTemplate>
<h3> </h3>
</HeaderTemplate>
<ItemTemplate>
<li>
<%#DataBinder.Eval(Container.DataItem,"LastName")%>
</li>
</ItemTemplate>
<AlternatingItemTemplate>
<h4><font color=red>
<%#DataBinder.Eval(Container.DataItem,"LastName")%>
</font>
</h4>
</AlternatingItemTemplate>
<FooterTemplate>
<h3></h3>
</FooterTemplate>
</asp:Repeater>
//3 ,Repeater
private void Page_Load(object sender, System.EventArgs e)
{
//
if(!IsPostBack)
RepeaterDataBind();
}
private void RepeaterDataBind()
{
// , Web.Config
SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionSqlServer"].ToString());
//
SqlDataAdapter da = new SqlDataAdapter("select LastName,FirstName,TitleOfCourtesy from Employees",conn);
// DataSet
DataSet ds = new DataSet();
try
{
//
da.Fill(ds,"testTable");
//
PagedDataSource objPage = new PagedDataSource();
//
objPage.DataSource = ds.Tables["testTable"].DefaultView;
//
objPage.AllowPaging = true;
//
objPage.PageSize = 5;
//
int CurPage;
//
if (Request.QueryString["Page"] != null)
CurPage=Convert.ToInt32(Request.QueryString["Page"]);
else
CurPage=1;
//
objPage.CurrentPageIndex = CurPage-1;
//
lblCurPage.Text = " : " + CurPage.ToString()+" ";
//
if (!objPage.IsFirstPage)
// " " URL : ,
lnkPrev.NavigateUrl=Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage-1);
//
if (!objPage.IsLastPage)
// " " URL : ,
lnkNext.NavigateUrl=Request.CurrentExecutionFilePath+ "?Page=" + Convert.ToString(CurPage+1);
//
RepeaterPage.DataSource = objPage;
RepeaterPage.DataBind();
}
catch(Exception error)
{
Response.Write(error.ToString());
}
}