Learning Resources
 

Repeating yourself with the Repeater


Repeater can be understood by an example. If we store the menu categories in a table called “Sub_Category” in SQL Server, so that if to ever need to add one, I just add it to the table and it will appear on the menu. There are two fields in the table: Sub_Category_ID, and Sub_Category_Text.

Step 1 — Create the Page and Insert the Repeater Control
The Repeater control allows you to create templates to define the layout of its content. The templates are:

  • ItemTemplate — Use this template for elements that are rendered once per row of data.
  • AlternatingItemTemplate — Use this template for elements that are rendered every other row of data. This allows you to alternate background colors, for example.
  • HeaderTemplate — Use this template for elements that you want to render once before your ItemTemplate section.
  • FooterTemplate — Use this template for elements that you want to render once after your ItemTemplate section.
  • SeperatorTemplate — Use this template for elements to render between each row, such as line breaks.


Here is a part of the Web Form (subcategories.aspx) that contains the Repeater:

  1. ....  
  2.  
  3.  
  4.  
  5.  
  6.  
  7.  
  8.  
  9.  
  10.  
  11.  
  12.  
  13.  
  14. NavigateUrl="<%# "mainframeset.aspx?CatType=" +  
  15. DataBinder.Eval(Container.DataItem,"Sub_Category_ID")%>"  
  16. Text="<%#DataBinder.Eval(Container.DataItem, "Sub_Category_Text")%>"  
  17. runat="server" target="mainFrame" ID="Hyperlink1" NAME="Hyperlink1"/>  

 
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  • ....  
  •  

    The Repeater has a name of “catlist“. It uses the HeaderTemplate to print out the Areas image. It then uses the ItemTemplate to display a Hyperlink control that has our data in it. We’ll come back to this in Step Two.


    Step 2 — Get the Data
    Now let’s look at the data retrieval. Here is the Page_Load event in the Code Behind file.

    1. private void Page_Load(object sender, System.EventArgs e)  
    2. {  
    3. SqlConnection conDotNet = new SqlConnection  
    4. "Server=xxxxxxx;UID=xxxx;PWD=xxxxx;Database=DotNetGenius");  
    5. string sSQL = "Select sub_category_id, sub_category_text  
    6. from Sub_Category";  
    7. SqlCommand cmd = new SqlCommand(sSQL, conDotNet);  
    8. conDotNet.Open();  
    9. SqlDataReader dtrCat = cmd.ExecuteReader();  
    10. catlist.DataSource = dtrCat;  
    11. catlist.DataBind();  
    12. }  


    The first five lines open a database connection and retrieve the contents of the Sub_Category table. The last two lines bind our Repeater control to the DataReader. Now, let’s look again at the ItemTemplate section:

    1.  
    2.  
    3. NavigateUrl="<%# "mainframeset.aspx?CatType=" +  
    4. DataBinder.Eval(Container.DataItem,"Sub_Category_ID")%>"  
    5. Text="<%#DataBinder.Eval(Container.DataItem, "Sub_Category_Text")%>"  
    6. runat="server" target="mainFrame" ID="Hyperlink1" NAME="Hyperlink1"/>  

     
  •  

  • Once the DataBind method of the Repeater control is called, ASP.NET will loop through the DataReader and populate the Repeater with the data we specify. The Databinder.Eval method uses reflection to parse and evaluate a data-binding expression against an object at run time, in this case the object is our Repeater. So this line of code:
    view plainprint?

    1. NavigateUrl="<%# "mainframeset.aspx?CatType=" +  
    2. DataBinder.Eval(Container.DataItem,"Sub_Category_ID")%>"  

    will render the contents of the "Sub_Category_ID" field for each row in the DataReader.