C# SQL Syntax Error

Question

Can anyone tell me why when I try to add a field into this SQL Server database I get the error

Incorrect Syntax near the keyword 'Table'.

Code:

{
    // TODO: This line of code loads data into the 'tBoxDataSet.Table' table. You can move, or remove it, as needed.
    this.tableTableAdapter.Fill(this.tBoxDataSet.Table);
}

private void button1_Click(object sender, EventArgs e)
{
         SqlConnection cn = new SqlConnection(global::TicketBox.Properties.Settings.Default.TBoxConnectionString);
        try
        {
            using (SqlConnection connect = new SqlConnection(global::TicketBox.Properties.Settings.Default.TBoxConnectionString))
            using (SqlCommand runsql = new SqlCommand(@"INSERT INTO Table (Event_ID,Artist,Venue,Date,Time,Tickets) values(@EventID,@Artist, @Venue, @Date, @Time,@Tickets)", connect))
            {
                runsql.Parameters.Add("@EventID", SqlDbType.Int).Value = textBox1.Text;
                runsql.Parameters.Add("@Artist", SqlDbType.VarChar).Value = textBox2.Text;
                runsql.Parameters.Add("@Venue", SqlDbType.VarChar).Value = textBox3.Text;
                runsql.Parameters.Add("@Date", SqlDbType.Date).Value = textBox4.Text;
                runsql.Parameters.Add("@Time", SqlDbType.Time).Value = textBox5.Text;
                runsql.Parameters.Add("@Tickets", SqlDbType.Int).Value = textBox6.Text;
                connect.Open();
                runsql.ExecuteNonQuery();
            }

            MessageBox.Show("Event Added", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
            this.tableTableAdapter.Fill(this.tBoxDataSet.Table);
        }
        catch (Exception ex)
        {
            MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
        }
        finally
        {
            cn.Close();
        }

I think 'Table' is a keyword. do you actualy have a table called 'Table'? I suggest you rename it to 'Concerts' or something — Ewan
– Ewan, Commented Mar 17, 2015 at 15:59

Soner Gönül · Accepted Answer · 2015-03-18 07:06:52Z

5

Table and Time are reserved keyword in T-SQL. You need to use them with square brackets like [Table] and [Time].

As a best practice, change them to non-reserved words.

Also Date can be a reserved keyword in future releases of SQL Server. You might need to use it with square brackets as well.

edited Mar 18, 2015 at 7:06

answered Mar 17, 2015 at 15:59

Soner Gönül

99.1k103 gold badges224 silver badges375 bronze badges

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

3 Comments

Topher Over a year ago

I cant believe I forgot that, been looking at this too long. Thanks fixed :)

Marc Gravell Over a year ago

Databases can be case sensitive; it the OP calls the table Table, it should be [Table] - not [TABLE], which can be an entirely different table ;p

Soner Gönül Over a year ago

@MarcGravell Exactly. Even their case are different, both Table and TABLE are behaves as reserved word. But yes, I edited to based on OP's original column names. Thanks.

Osvier · Accepted Answer · 2015-03-17 16:00:45Z

2

if your table name is TABLE, then.. that is a keyword for sql...

change your query to

INSERT INTO [Table]

using [ ] will override the keyword

answered Mar 17, 2015 at 16:00

Osvier

8491 gold badge8 silver badges25 bronze badges

Comments

A_Sk · Accepted Answer · 2015-03-17 16:09:13Z

0

as Tabel is a reserved keyword , you need to use like this [table]

change the query to.

INSERT INTO [Table] (Event_ID,Artist,Venue,Date,Time,Tickets)  
values(@EventID,@Artist, @Venue, @Date, @Time,@Tickets)

answered Mar 17, 2015 at 16:09

A_Sk

4,6505 gold badges31 silver badges55 bronze badges

Collectives™ on Stack Overflow

C# SQL Syntax Error

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related