add a new row, what do i wrong?

gamedev

I'm tring to add a row at my database .mdb but i get the follow error: "Sintax error in the INSERT INTO instruction" why? what do i wrong? this is the schema of my database: Nome: text 15 Domanda: text 20 Risposta: text 15 Email: text 20 this is the code: System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection(); conn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;" + @"Data source= myDatabase.mdb;"; try { conn.Open(); OleDbDataAdapter myAdapter = new OleDbDataAdapter("SELECT * FROM myTable", conn); OleDbCommandBuilder myCmd = new OleDbCommandBuilder(myAdapter); DataSet myDataSet = new DataSet("myTable"); myAdapter.MissingSchemaAction = MissingSchemaAction.AddWithKey; myAdapter.Fill(myDataSet, "myTable"); DataRow myRow = myDataSet.Tables["myTable"].NewRow(); myRow["Nome"] = mNuovoUtente.mName; myRow["Domanda"] = mNuovoUtente.mQuestion; myRow["Risposta"] = mNuovoUtente.mAnswer; myRow["Email"] = mNuovoUtente.mEmail; myDataSet.Tables["TabellaUtente"].Rows.Add(myRow); myAdapter.Update(myDataSet, "myTable"); catch(Exception ex) { MessageBox.Show(ex.Message); } finally { conn.Close(); }

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Andrzej Wegierski21y ago
Additionally, add to writed lines: Console.WriteLine("SQLInsert: {1}", myDataAdapter.InsertCommand.CommandText);
miker21y ago
It's really hard to say. I would first check the values. And, of course, Iwould try to narrow dow the exception, something like this: catch (SqlException e) { for (int i=0; i < e.Errors.Count; i++) { Console.WriteLine("Class: {1}", e.Errors[i].Class); Console.WriteLine("Error #{1}: {2} on line {3}.", e.Errors[i].Number, e.Errors[i].Message, e.Errors[i].LineNumber); Console.WriteLine("Error reported by {1} while connected to {2}", e.Errors[i].Source, e.Errors[i].Server); } }