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:UsersHPdocumentsvisual studio 2013ProjectsCSGObetsAdvisorCSGObetsAdvisorApp_DataDatabase.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 :
Advertisement
Answer
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