Någon som ser vad som är fel. Har stirrat mig blind.
<%@ Page Language="VB" Debug="true" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<script runat="server">
sub page_load(obj as object, e as eventargs)
'Skapa koppling
dim objConn as New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Webbsidor\dot.net\books\aspnet3veckor\data\bank.mdb")
'Öppna kopplingen
dim objAdapter as New OleDbDataAdapter("SELECT * FROM user", objConn)
'Fyll ett datasetobjekt
dim objDataSet as New DataSet()
objAdapter.Fill(objDataSet, "user")
dim objDataview as New DataView(objDataSet.Tables("user"))
'Välj ett dataviewobjekt och bind till serverkontrollen
MyDataList.DataSource = objDataview
MyDataList.DataBind()
end sub
</script>
...
Felmeddelande:
Syntaxfel i FROM-instruktion.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.OleDb.OleDbException: Syntaxfel i FROM-instruktion.
Source Error:
Line 13: 'Fyll ett datasetobjekt
Line 14: dim objDataSet as New DataSet()
Line 15: objAdapter.Fill(objDataSet, "user")
Line 16:
Line 17: dim objDataview as New DataView(objDataSet.Tables("user"))
Source File: C:\Webbsidor\dot.net\books\aspnet3veckor\dag8\ovning01_GetDataFromDataBas.aspx Line: 15
Stack Trace:
[OleDbException (0x80040e14): Syntaxfel i FROM-instruktion.]
System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr) +41
System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) +154
System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) +92
System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) +65
System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +112
System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) +57
System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +5
System.Data.Common.DbDataAdapter.Fill(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +121
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +36
ASP.ovning01_GetDataFromDataBas_aspx.page_load(Object obj, EventArgs e) in C:\Webbsidor\dot.net\books\aspnet3veckor\dag8\ovning01_GetDataFromDataBas.aspx:15
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +29
System.Web.UI.Page.ProcessRequestMain() +724
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.0.3705.288; ASP.NET Version:1.0.3705.288