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());

   }  

  }