Jeg kan altså ikke få det til at virke, så her har I hele koden:
<%@ Page Language="vb" %>
<script runat="server">
Sub Page_Load()
Dim connectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0; Ole DB Services=-4; Data Source=C:\Webprojekter"& _
"\filmnyt\db\filmnyt.mdb"
Dim dbConnection As System.Data.IDbConnection = New System.Data.OleDb.OleDbConnection(connectionString)
Dim queryString As String = "SELECT [Artikler].[Dato], [Artikler].[Overskrift], [Artikler].[ArtikelTekst], [Artikler].[Kilde], [Artikler].[Billedsti] FROM [Artikler] Order by Dato Desc"
Dim dbCommand As System.Data.IDbCommand = New System.Data.OleDb.OleDbCommand
dbCommand.CommandText = queryString
dbCommand.Connection = dbConnection
dbConnection.Open
Dim dataReader As System.Data.IDataReader = dbCommand.ExecuteReader(System.Data.CommandBehavior.CloseConnection)
MyRepeater.DataSource = dataReader
MyRepeater.DataBind()
End Sub
</script>
<html>
<head>
<style>TD {
FONT-SIZE: 10px; FONT-FAMILY: verdana; TEXT-ALIGN: left
}
.dato {
FONT-WEIGHT: bold; BACKGROUND-COLOR: #e3e3e3
}
.Overskrift {
FONT-WEIGHT: bold; FONT-SIZE: 14px; PADDING-BOTTOM: 50px; FONT-FAMILY: verdana
}
BODY {
TEXT-ALIGN: center
}
.Billede {background-color: #aaaaaa;}
</style>
</head>
<body>
<p>
<ASP:Repeater id="MyRepeater" runat="server">
<HeaderTemplate>
<div class="Overskrift">Filmnyt
</div>
<table align="center" border="1">
</HeaderTemplate>
<ItemTemplate>
<tr>
<td class="dato">
<%# DataBinder.Eval(Container.DataItem, "Dato", "{0:D}")%></td>
<td rowspan="3" class="billede">
<asp:image imageURL="<%# DataBinder.Eval(Container.DataItem, "Billedsti")%>" runat="server"></asp:image>
</td>
</tr>
<tr>
<td>
<%# Container.DataItem("Overskrift")%></td>
</tr>
<tr>
<td style="width: 400px; padding-bottom: 20px">
<%# Container.DataItem("ArtikelTekst")%>
</td>
</tr>
</p>
</ItemTemplate>
<FooterTemplate>
</table>
</FooterTemplate>
</ASP:Repeater>
</p>
</body>
</html>
Ny bruger
Nybegynder
Opret
Preview
