Incorrect syntax near the keyword 'Table' C# SQL

19,333

That happens because TABLE is a reserved keyword for T-SQL.
If you really need to use that name, your query should enclose TABLE in square brackets

SqlCommand cmd = new SqlCommand(@"INSERT INTO [Table] 
                                  (ItemID,ItemName) VALUES 
                                  (@ItemIDss,@Namess)");

I strongly suggest to change that name and use a more descriptive word for the content of that table

Share:
19,333
Bart
Author by

Bart

Updated on July 31, 2022

Comments

  • Bart
    Bart over 1 year

    Hello I'm trying to figure out why i have this error

    Incorrect syntax near the keyword 'Table'.

    Thx in advance

    Code :

    using System;
    using System.Collections.Generic;
    using System.Data;
    using System.Data.SqlClient;
    using System.Linq;
    using System.Web;
    
    namespace CSGObetsAdvisor
    {
        public class SQLInsertData
        {
            public void InsertToSQL(string LoungeItemName)
            {
                string connectionString = @"Data Source=(LocalDB)\v11.0;AttachDbFilename=" + @"C:\Users\HP\documents\visual studio 2013\Projects\CSGObetsAdvisor\CSGObetsAdvisor\App_Data\Database.mdf" + ";Integrated Security=True";
                using (SqlConnection connection = new SqlConnection(connectionString))
                {
                    SqlCommand cmd = new SqlCommand("INSERT INTO Table (ItemID,ItemName) VALUES (@ItemIDss,@Namess)");
                    cmd.CommandType = CommandType.Text;
                    cmd.Connection = connection;
                    cmd.Parameters.AddWithValue("@ItemIDss", 50);
                    cmd.Parameters.AddWithValue("@Namess", LoungeItemName);
    
                    connection.Open();
                    cmd.ExecuteNonQuery();
                }
    
            }
    
    
        }
    }
    

    Server Explorer :

    enter image description here