<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<html>
<head>
<title>Repeater ItemCreated Event Example</title>
<link rel="stylesheet" href="/shared/netdemos.css">
<script language="C#" runat="server" src="fetchData_sql.cs" />
<script language="C#" runat="server">
void Page_Load ( Object src, EventArgs e ) {
if ( !IsPostBack ) {
string query = "SELECT * FROM Shippers";
myRepeater.DataSource = fetchData ( query );
myRepeater.DataBind ( );
}
}
void showItem ( Object src, RepeaterItemEventArgs e ) {
if ( e.Item.ItemType == ListItemType.Item ||
e.Item.ItemType == ListItemType.AlternatingItem ) {
object [ ] dataitems = ( ( DataRowView ) e.Item.DataItem ).Row.ItemArray;
msg.Text += "<br>" + dataitems [ 0 ] + " " + dataitems [ 1 ] + " " + dataitems [ 2 ];
}
else {
msg.Text += "<br>" + e.Item.ItemType.ToString ( );
}
}
</script>
</head>
<body>
<!-- #include virtual="~/shared/top.inc" -->
<div class="header"><h2>Repeater ItemCreated Event Example</h2></div>
<hr size=1 width=92%>
<form runat="server">
<div align="center">
<asp:repeater id="myRepeater" runat="server" onItemCreated="showItem">
<headertemplate>
<table class="data" cellspacing=1>
<tr>
<th>ShipperID</th>
<th>Company Name</th>
<th>Phone</th>
</tr>
</headertemplate>
<itemtemplate>
<tr>
<td><%# Eval ( "ShipperID" ) %></td>
<td><%# Eval ( "CompanyName" ) %></td>
<td><%# Eval ( "Phone" ) %></td>
</tr>
</itemtemplate>
<footertemplate>
</table>
</footertemplate>
</asp:repeater>
</div>
<p style="padding-left:10"><asp:label id="msg" runat="server" />
</form>
<hr size=1 width=92%>
<!-- #include virtual="~/shared/viewsrc.inc" -->
</body>
</html>