请问这小段的代码哪里错了?谢谢!!
tylrr 2005-04-25 05:21:40 我把原来sql数据库的代码修改为access数据库使用,可是提示
System.Data.OleDb.OleDbException: FROM 子句语法错误。
请教哪里错了?谢谢~~~ < min表是存在的.>
<%@ Import Namespace="System.Data.oledb" %>
<%@ Import Namespace="System.Data" %>
<Script Runat="Server">
Sub Page_Load
Dim conPubs As oledbConnection
Dim cmdSelect As oledbCommand
Dim dtrAuthors As oledbDataReader
' Retrieve records from database
conPubs = New oledbConnection( "Provider=microsoft.jet.oledb.4.0;data source=" & server.mappath("1.mdb" ))
cmdSelect = New oledbCommand("Select * From min",conPubs)
conPubs.Open()
dtrAuthors = cmdSelect.ExecuteReader()
' Bind to Repeater
rptAuthors.DataSource = dtrAuthors
rptAuthors.DataBind()
dtrAuthors.Close()
conPubs.Close()
End Sub
</Script>
<html>
<head><title>Repeater.aspx</title></head>
<body>
<form Runat="Server">
<asp:Repeater
ID="rptAuthors"
Runat="Server">
<ItemTemplate>
<%# Container.DataItem( "admin" ) %>
</ItemTemplate>
</asp:Repeater>
</form>
</body>
</html>