Tjena!
Jag får det här felmeddelandet när jag ska använda en Repeater:
Compiler Error Message: BC30518: Overload resolution failed because no accessible 'Fill' can be called with these arguments:
Source Error:
Line 7: Dim SQL As New OleDbDataAdapter("SELECT * FROM users", Connection)
Line 8: Dim ds As DataSet = New DataSet()
Line 9: SQL.Fill("users",Connection)
Line 10: Repeater1.DataSource = ds.Tables("Fnamn").DefaultView
Line 11: DataBind()
<% @ Page Language="VB" %>
<% @ Import Namespace="System.Data" %>
<% @ Import Namespace="System.Data.OleDb" %>
<script runat="server">
Sub Page_Load(Obj As Object, E As Eventargs)
Dim Connection As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("bank.mdb"))
Dim SQL As New OleDbDataAdapter("SELECT * FROM users", Connection)
Dim ds As DataSet = New DataSet()
[red]SQL.Fill("users",Connection)[/red]
Repeater1.DataSource = ds.Tables("Fnamn").DefaultView
DataBind()
End Sub
</script>
<html>
<head>
<title>Kodlista 9.8</title>
</head>
<body>
<asp:Repeater id="Repeater1" runat="server">
<HeaderTemplate>
<table>
<tr>
<td bgcolor="#CCCC99" width="200"><b>Namn:</b></td>
<td bgcolor="#CCCC99" width="200"><b>Telefon</b></td>
</tr>
</HeaderTemplate>
<ItemTemplate>
<tr>
<td>
<%# Container.DataItem("Fnamn") %> <%# Container.DataItem("Enamn") %>
</td>
<td>
<%# Container.DataItem("Telefon") %>
</td>
</tr>
</ItemTemplate>
<AlternatingItemTemplate>
<tr>
<td bgcolor="#CCCC99">
<%# Container.DataItem("Fnamn") %>
<%# Container.DataItem("Enamn") %>
</td>
<td bgcolor="#CCCC99">
<%# Container.DataItem("Tele") %>
</td>
</tr>
</AlternatingItemTemplate>
<SeparatorTemplate>
<tr>
<td colspan="2" align="center">
---
</td>
</tr>
</SeparatorTemplate>
<FooterTemplate>
</table>
</FooterTemplate>
</asp:Repeater>
</body>
</html>
Någon som kan hjälpa stackars lilla mig? :stud
/Mika3l