Insert error C# when inserting into access database

Question

I get an error when trying to insert a record into the database.

Here's the error:

The Code:

connection.Open();
            OleDbCommand command = new OleDbCommand();
            command.Connection = connection;
            command.CommandText = "INSERT INTO [Booking] (TableID, BookingName, BookingNumber, BookingDate, PartySize) VALUES (@TableID, @BookingName, @BookingPhoneNumber, @BookingDate, @PartySize)";
            command.Parameters.AddRange(new OleDbParameter[] {
                    new OleDbParameter("@TableID", textBoxResTableID.Text),
                    new OleDbParameter("@BookingName", textBoxResName.Text),
                    new OleDbParameter("@BookingPhoneNumber", textBoxResNum.Text),
                    new OleDbParameter("@BookingDate", DateTime.Today),
                    new OleDbParameter("@PartySize", textBoxResPartySize.Text)
                });

            command.ExecuteNonQuery();
            connection.Close();

The DB:

It could be due to incorrect parameter syntax. Check this answer http://stackoverflow.com/a/5894003/4795214 — , Jan 26 '16 at 12:24
I know it may be a nonsense but...did you try to remove the "[" and "]" in your table name? — Pikoh, Jan 26 '16 at 12:28
Also use [`using` statement](https://msdn.microsoft.com/en-us/library/yh598w02.aspx) to dispose your connection and command automatically instead of calling `Close` or `Dispose` methods manually. — Soner Gönül, Jan 26 '16 at 12:41

score 2 · Accepted Answer · answered Jan 26 '16 at 12:37

2

Looks like TABLEID may be a reserved word according to this. To get round it enclose it in [].

answered Jan 26 '16 at 12:37

sr28

4,728
5
36
67

Wow. I didn't expect this as a reserved keyword. Nice find. `+1` – Soner Gönül Jan 26 '16 at 12:38
@SonerGönül - it was a surprise to me as well. I almost didn't look as I thought it would be a dead end. – sr28 Jan 26 '16 at 12:39
This solved it! I cannot believe it, was racking my brain! massive thank you! – user5467760 Jan 26 '16 at 12:50
@user5467760 - no problem. Glad I could help. – sr28 Jan 26 '16 at 12:51

M. Schena · Answer 2 · 2016-01-26T12:36:58.737

0

I had same problem and solved it adding parameters with following syntax:

 command.Parameters.Add("@UserName", OleDbType.BSTR).Value = username;

EDIT: pasted wrong command first.

edited Jan 26 '16 at 12:36

answered Jan 26 '16 at 12:30

M. Schena

2,039
1
21
29

But _why_ do you think this can solve OP's problem? What is the problem _anyway_? – Soner Gönül Jan 26 '16 at 12:31
I have no clue why. But with his method i had the same error. Not shure if it's the solution, but worked for me. – M. Schena Jan 26 '16 at 12:33

Insert error C# when inserting into access database

2 Answers2