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 stackoverflow.com/a/5894003/4795214 — user586399
– user586399, Commented Jan 26, 2016 at 12:24
I know it may be a nonsense but...did you try to remove the "[" and "]" in your table name? — Pikoh
– Pikoh, Commented Jan 26, 2016 at 12:28
Also use using statement to dispose your connection and command automatically instead of calling Close or Dispose methods manually. — Soner Gönül
– Soner Gönül, Commented Jan 26, 2016 at 12:41

sr28 · Accepted Answer · 2016-01-26 12:37:18Z

2

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

answered Jan 26, 2016 at 12:37

sr28

5,2586 gold badges48 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Soner Gönül Over a year ago

Wow. I didn't expect this as a reserved keyword. Nice find. +1

sr28 Over a year ago

@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.

user5467760 Over a year ago

This solved it! I cannot believe it, was racking my brain! massive thank you!

sr28 Over a year ago

@user5467760 - no problem. Glad I could help.

M. Schena · Accepted Answer · 2016-01-26 12:36:58Z

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, 2016 at 12:36

answered Jan 26, 2016 at 12:30

M. Schena

2,1071 gold badge24 silver badges30 bronze badges

2 Comments

Soner Gönül Over a year ago

But why do you think this can solve OP's problem? What is the problem anyway?

M. Schena Over a year ago

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.

Collectives™ on Stack Overflow

Insert error C# when inserting into access database

2 Answers 2

4 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related