<%@ Import Namespace="System.Data.SqlClient" %>
<Script Runat="Server">
Sub Page_Load
Dim conNorthwind As SqlConnection
Dim cmdSelect As SqlCommand
Dim dtrEmployees As SqlDataReader
' Retrieve data from the database Northwind
conNorthwind=New SqlConnection( "Server=localhost; UID=sa;PWD= secret;
Database=Northwind" )
cmdSelect = New SqlCommand( "Select * From Employees", conNorthwind )
conNorthwind.Open()
dtrEmployees = cmdSelect.ExecuteReader()
' Binding to Repeater
rptEmployees.DataSource = dtrEmployees
rptEmployees.DataBind()
dtrEmployees.Close()
conNorthwind.Close()
End Sub
</Script>
<html>
<head><title>RepeaterItemTemplate.aspx</title></head>
<body>
<form Runat="Server">
<asp:Repeater
ID="rptEmployees"
Runat="Server">
<HeaderTemplate>
<table border=1 cellpadding=5>
<tr bgcolor="orange">
<th>First Name</th>
<th>Last Name</th></tr>
</HeaderTemplate>
<ItemTemplate>
<tr bgcolor="blue">
<td><%# Container.DataItem( "firstname" ) %></td>
<td><%# Container.DataItem( "lastname" ) %></td>
</tr>
</ItemTemplate>
<AlternatingItemTemplate>
<tr bgcolor="lightgrey">
<td><%# Container.DataItem( "firstname" ) %></td>
<td><%# Container.DataItem( "lastname" ) %></td>
</tr>
</AlternatingItemTemplate>
<FooterTemplate>
</table>
</FooterTemplate>
</asp:Repeater>
</form>
</body>
</html> |
