我把原来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>
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>
这样就好了...
<%#DataBinder.Eval(Container.DataItem,"admin")%>
min/max 是Sql的系统函数,建议将表的名称修改一下更好。
cmdSelect = New oledbCommand("Select * From [min]",conPubs)