|
Hab das aus ner HowTo bekomm aber immer nachstehenden Fehler. --Code------------- string sDBFile =
Server.MapPath("../mdb-database/") + "g_members.mdb"; OleDbConnection myConnection =
new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" +
sDBFile); OleDbCommand mySqlCommand =
new OleDbCommand("INSERT INTO Members_Data (User) Values ('ABC')",
myConnection); ��� try ��� { ����� myConnection.Open(); ����� mySqlCommand.ExecuteNonQuery(); ����� firstname.Text = "New Record
inserted into Customers table in northwind."; ��� } ��� catch(Exception u) ��� { ����� firstname.Text = "Couldn't insert
record: " + u.ToString(); ��� } ��� finally ��� { ����� myConnection.Close(); ��� } --Error-------------- Couldn't insert record: System.Data.OleDb.OleDbException: Syntaxfehler
in der INSERT INTO-Anweisung.�� at
System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr)�� at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS
dbParams, Object& executeResult)�� at
System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object&
executeResult)�� at
System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior,
Object& executeResult)�� at
System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior,
String method)�� at
System.Data.OleDb.OleDbCommand.ExecuteNonQuery()�� at SignUp.abort_Click(Object sender,
EventArgs e) Hab schon mehreres versucht und die INSERT INTO Anweisung hab ich auch
aus dem HOW TO kopiert und �berpr�ft. Was istn da? K�nnt ihr mir helfen danke |
