Repeater Source Code

Repeater Example, source code file repeater.aspx

<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>

<script runat="server">
public void Page_Load(object sender, EventArgs e)
{
    // Create and configure connection string.
    OleDbConnection c = new OleDbConnection( );
    c.ConnectionString =
        "Provider=Microsoft.ACE.OLEDB.12.0;" +
        "Data Source=e:/ectserver/sjost/Database/groceries.accdb;";

// Create Command object with query from drop down list.
    OleDbCommand sc = new OleDbCommand("SELECT * FROM Groceries;", c);
    
    // Create DataAdapter object.
    OleDbDataAdapter da = new OleDbDataAdapter(sc);

// Create and populate DataSet object.
    DataSet ds = new DataSet( );    
    int n = da.Fill(ds, "Groceries");

// Display data withRepeater control.
    repGroceries.DataSource = ds;
    repGroceries.DataBind();
}
</script>

<title>Repeater Example</title>

</head>

<body>

<h2>Repeater Example</h2>

<p>
<asp:Repeater ID="repGroceries" runat="server">
<HeaderTemplate>
    <table>
    <tr>
        <th>Item</th>
        <th>Code</th> 
        <th>Quantity</th> 
        <th>Price</th> 
        <th>OnSale</th> 
    </tr>
</HeaderTemplate>
<ItemTemplate>
    <tr class="pink">
        <td><%# Eval("Item") %> </td>
        <td><%# Eval("Code") %> </td>
        <td><%# Eval("Quantity") %> </td>
        <td><%# Eval("Price") %> </td>
        <td><%# Eval("OnSale") %> </td>
    </tr>
</ItemTemplate>
<AlternatingItemTemplate>
    <tr class="blue">
        <td><%# Eval("Item") %> </td>
        <td><%# Eval("Code") %> </td>
        <td><%# Eval("Quantity") %> </td>
        <td><%# Eval("Price") %> </td>
        <td><%# Eval("OnSale") %> </td>
    </tr>
</AlternatingItemTemplate>
<SeparatorTemplate>
    <tr>
        <td colspan="5"><hr /></td>
    </tr>
</SeparatorTemplate>
<FooterTemplate>
    </table>
</FooterTemplate>
</asp:Repeater>
</p>

</form>

</body>

</html>