 09-15-2006, 10:36 PM
|
hotwebideas
Joined on 03-25-2006
Posts 6
|
Database Connection Not Working with ASP:Repeater Control. Help
|
|
|
|
|
For you ASP.NET experts, this is driving me crazy. If anyone can give
me some directions, that would be great. This was working fine with
classic ASP. So, I know my DSN is setup correctly.
I get the ole: Server Error in '/' Application. error
I have a DB connection set up in my server form:
sub page_load
dim dbconn,sql,dbcomm,dbread
dbconn=New
OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;
data source=" & server.mappath("DATABASENAME"))
dbconn.Open()
sql="select html from text_links where category='sports'"
dbcomm=New OleDbCommand(sql,dbconn)
dbread=dbcomm.ExecuteReader()
textlinks.DataSource=dbread
textlinks.DataBind()
dbread.Close()
dbconn.Close()
end sub
My ASP.NET Repeater Control:
<form runat=:server">
<asp:repeater runat="server" id="textlinks">
<ItemTemplate>
<%#Container.DataItem("html")%><br />
</ItemTemplate>
</asp:repeater>
</form>
Thanks to all who can answer this,
Bruce
|
|
|
|
|
Report
|
|
|
|