INSERT INTO Table (Column) VALUE (email)

Question

I want to insert email in Table with only one column. I tried on 2 way. First time I tried with commandText and second time I tried with parapeters. But the both solution give me the same error.

System.Data.OleDb.OleDbException: 'Syntax error in INSERT INTO statement.'

I don't see any error in INSERT STATEMENT. Maybe the problem is in TABLE?

 using (OleDbCommand cmd = new OleDbCommand())
 {
    cmd.Connection = conn;
    cmd.CommandText = "SELECT COUNT (email) FROM [User] WHERE [email] LIKE '" + userEmail + "';";
    conn.Open();
    int count = Convert.ToInt32(cmd.ExecuteScalar()); // This passed
    if (count == 0)
    {
        string query = @"INSERT INTO User (email) VALUES (@email)";
        string cmdText= @"INSERT INTO User (email) VALUES ('"+userEmail+"')";
        OleDbCommand command = new OleDbCommand(cmdText, conn);
   //     command.Parameters.AddWithValue("@email", "userEmail");
       // command.CommandText = query;
        command.ExecuteNonQuery(); // I GOT ERROR HERE
    }
    conn.Close();
}

well I need to insert users in Table. – MiOnIs May 29 '17 at 14:17 — MiOnIs, May 29 '17 at 14:17
[Little Bobby Tables](http://bobby-tables.com/) alert! – Uwe Keim May 29 '17 at 14:18 — Uwe Keim, May 29 '17 at 14:18

score 3 · Accepted Answer · answered May 29 '17 at 14:18

3

User is a keyword. You should INSERT INTO [USER] instead

answered May 29 '17 at 14:18

hardkoded

18,915
3
52
64

as mentioned here: https://support.microsoft.com/en-us/help/286335/list-of-reserved-words-in-access-2002-and-in-later-versions-of-access – Smartis has left SO again May 29 '17 at 14:20
yeah that's it. Thank you. – MiOnIs May 29 '17 at 14:27

score 0 · Answer 2 · answered May 29 '17 at 14:14

0

string cmdText= @"INSERT INTO User (email)) VALUES ('"+userEmail+"')";

you have one ')' too many after (email)

answered May 29 '17 at 14:14

Aleksandar Stanojevic Dante

97
8

that's no problem I didn't have two ) in second string but I got error again. – MiOnIs May 29 '17 at 14:16

INSERT INTO Table (Column) VALUE (email)

2 Answers2