> 
- Home Page
- > Script VB.Net
- > Script VB.Net - Web Controls
- > OleDb Repeater
OleDb Repeater - << VERSIONE C# >>
Popolare un Repeater utilizzando OleDb
<%@ Page language="VB" Debug="false" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<HTML>
<script language="vbscript" runat="server">
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim myConn As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0; Data Source=" & Server.MapPath("database/utenti.mdb"))
Dim myCmd As OleDbCommand = New OleDbCommand("select nome, cognome, email from utenti", myConn)
Try
myConn.Open()
myRepeater.DataSource = myCmd.ExecuteReader()
myRepeater.DataBind()
Finally
myConn.Close()
End Try
End Sub
</script>
<body>
<form id="Form1" method="post" runat="server">
<asp:repeater id="myRepeater" runat="server">
<headertemplate>
<table cellspacing="1" cellpadding="3" style="font:8pt verdana">
<tr style="background:green; color:snow;">
<th>
Nome</th>
<th>
Cognome</th>
<th>
Email</th>
</tr>
</headertemplate>
<itemtemplate>
<tr>
<td><%# DataBinder.Eval(Container, "DataItem.Nome") %></td>
<td><%# DataBinder.Eval(Container, "DataItem.Cognome") %></td>
<td><%# DataBinder.Eval(Container, "DataItem.Email") %></td>
</tr>
</itemtemplate>
<alternatingitemtemplate>
<tr style="background-color:snow">
<td><%# DataBinder.Eval(Container, "DataItem.Nome") %></td>
<td><%# DataBinder.Eval(Container, "DataItem.Cognome") %></td>
<td><%# DataBinder.Eval(Container, "DataItem.Email") %></td>
</tr>
</alternatingitemtemplate>
<footertemplate>
</table>
</footertemplate>
</asp:repeater>
</form>
</body>
</HTML>
