- <%@ Page Language="VB" %>
- <%@ Import Namespace="System.Data" %>
- <%@ Import Namespace="System.Data.OleDb" %>
-
- <script runat="server">
- sub Page_Load(obj as Object, e as EventArgs)
-
- ' On définit la connection
- dim myConnection as new OleDbConnection ("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & Request.MapPath("\testnet\test.mdb"))
-
- ' On ouvre la connection
- dim myCommand as new OleDbDataAdapter ("select * from CLIENT", myConnection)
-
- ' On alimente le DATASET
- dim ds as DataSet = new DataSet()
- myCommand.Fill(ds, "CLIENT")
-
- 'Sélectionner l'affichage et le lier au contrôle serveur
- Repeater1.DataSource = ds.Tables("CLIENT").DefaultView
- DataBind()
- end sub
- </script>
-
- <html><body>
- <ASP:Repeater id="Repeater1" runat="server" >
- <HeaderTemplate>
- <table>
- <tr>
- <td bgcolor="#cccc99" width=200><b>ID</b></td>
- <td bgcolor="#cccc99" width=200><b>NOM</b></td>
- <td bgcolor="#cccc99" width=200><b>PRENOM</b></td>
- </tr>
- </HeaderTemplate>
-
- <ItemTemplate>
- <tr>
- <td bgcolor="#cccc99">
- <%# Container.DataItem("CL_ID") %>
- </td>
- <td bgcolor="#cccc99">
- <%# Container.DataItem("CL_NOM") %>
- </td>
- <td bgcolor="#cccc99">
- <%# Container.DataItem("CL_PRENOM") %>
- </td>
- </tr>
- </ItemTemplate>
-
-
- <FooterTemplate>
- </table>
- </FooterTemplate>
- </ASP:Repeater>
- </body></html>
-
<%@ Page Language="VB" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<script runat="server">
sub Page_Load(obj as Object, e as EventArgs)
' On définit la connection
dim myConnection as new OleDbConnection ("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & Request.MapPath("\testnet\test.mdb"))
' On ouvre la connection
dim myCommand as new OleDbDataAdapter ("select * from CLIENT", myConnection)
' On alimente le DATASET
dim ds as DataSet = new DataSet()
myCommand.Fill(ds, "CLIENT")
'Sélectionner l'affichage et le lier au contrôle serveur
Repeater1.DataSource = ds.Tables("CLIENT").DefaultView
DataBind()
end sub
</script>
<html><body>
<ASP:Repeater id="Repeater1" runat="server" >
<HeaderTemplate>
<table>
<tr>
<td bgcolor="#cccc99" width=200><b>ID</b></td>
<td bgcolor="#cccc99" width=200><b>NOM</b></td>
<td bgcolor="#cccc99" width=200><b>PRENOM</b></td>
</tr>
</HeaderTemplate>
<ItemTemplate>
<tr>
<td bgcolor="#cccc99">
<%# Container.DataItem("CL_ID") %>
</td>
<td bgcolor="#cccc99">
<%# Container.DataItem("CL_NOM") %>
</td>
<td bgcolor="#cccc99">
<%# Container.DataItem("CL_PRENOM") %>
</td>
</tr>
</ItemTemplate>
<FooterTemplate>
</table>
</FooterTemplate>
</ASP:Repeater>
</body></html>