Morpheusweb.it - Risorse per webmaster: script, ASP.NET, C#, Visual Basic .Net, tutorial, asp, javascript, css, php, html, java, ADO, VBScript, forms, frames, Active Server Pages, Dynamic HTML, database, gratis per webmaster e webdesigner

OleDb Repeater - << VERSIONE VB.NET >>

Popolare un Repeater utilizzando OleDb

<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<HTML>
<script language="C#" runat="server">
protected void Page_Load ( object src, EventArgs e )
{
  OleDbConnection myConn = new OleDbConnection(
    "Provider=Microsoft.Jet.OleDb.4.0; Data Source=" +
    Server.MapPath("database/utenti.mdb"));
  OleDbCommand myCmd = new OleDbCommand("select nome, cognome, email from utenti", myConn);
  try
  {
    myConn.Open();
    myRepeater.DataSource = myCmd.ExecuteReader();
    myRepeater.DataBind();
  }
  finally
  {
    myConn.Close();
  }
}
</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>

Scarica il Codice...

Stampa la pagina

Inizio pagina