<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<html>
<head>
<title>Introduction to Templated Controls (Repeater)</title>
<link rel="stylesheet" href="/shared/netdemos.css">
<script language="C#" runat="server">
void Page_Load ( Object sender, EventArgs e ) {
OleDbConnection myConn = new OleDbConnection (
"Provider=Microsoft.ACE.OLEDB.12.0; Data Source=|DataDirectory|pubs.mdb" );
OleDbCommand myCmd = new OleDbCommand ( "SELECT * FROM Titles", myConn );
myConn.Open ( );
// return datareader
myRepeater.DataSource = myCmd.ExecuteReader ( CommandBehavior.CloseConnection );
myRepeater.DataBind ( );
}
</script>
</head>
<body topmargin=0 leftmargin=0 marginwidth=0 marginheight=0>
<!-- #include file="dl_header.inc" -->
<asp:repeater id="myRepeater" runat="server">
<headertemplate>
<table width="100%" align="center"cellspacing=1 cellpadding=5 style="font:9pt verdana">
<tr style="background-color:#ddc">
<th>Title</th>
<th>Title ID</th>
<th>Type</th>
<th>Publisher ID</th>
<th>Price</th></tr>
</headertemplate>
<itemtemplate>
<tr style="background-color:#efefef">
<td><%# Eval ( "title" ) %></td>
<td><%# Eval ( "title_id" ) %></td>
<td><%# Eval ( "type" ) %></td>
<td><%# Eval ( "pub_id" ) %></td>
<td><%# Eval ( "price", "{0:c2}" ) %></td></tr>
</itemtemplate>
<footertemplate>
</table>
</footertemplate>
</asp:repeater>
<!-- #include file="dl_footer.inc" -->
<!-- #include virtual="~/shared/viewsrc.inc" -->
</body>
</html>