ASP.NET DB Connection Not Working with Repeater Control

[brucec]

If anyone can help, please do. I would appreciate it.

I have an ASP Repeater control bound to a DB Connection. I get the dreaded "Server Error in '/' Application" error:

<form runat="server">
<asp:repeater runat="server" id="textlinks">
<ItemTemplate>
<%#Container.DataItem("html")%><br />
</ItemTemplate>
</asp:repeater>
</form>

And my DB Connection:

<script runat="server">
sub page_load
dim dbconn,sql,dbcomm,dbread
dbconn=New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;data source=" & server.mappath("alh.mdb"))
dbconn.Open()
sql="select html from text_links where category='m'"
dbcomm=New OleDbCommand(sql,dbconn)
dbread=dbcomm.ExecuteReader()
textlinks.DataSource=dbread
textlinks.DataBind()
dbread.Close()
dbconn.Close()
end sub
</script>

If you know why this is not working, please let me know.
Thanks,
Bruce

[Ocean10000]

My first thought is that "page_load" is not being called.

Try renaming it to "load" and seeing if it runs then.

[deepraj]

try embedding <ItemTemplate> inside <Columns> tag.

Example:

<asp:Repeator ...........>
<Columns>
<ItemTemplate ........?
</ItemTemplate>
</Columns>
</asp:Repeator>

try it..... and see whether this helps u in solving your problem.