关键字'Table'附近的语法不正确C#SQL [关闭](Incorrect syntax near the keyword 'Table' C# SQL [closed])
你好,我想弄清楚为什么我有这个错误
关键字“Table”附近的语法不正确。
Thx提前
代码:
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:
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 :
最满意答案
这是因为TABLE是T-SQL的保留关键字 。 如果确实需要使用该名称,则查询应将TABLE括在方括号中
SqlCommand cmd = new SqlCommand(@"INSERT INTO [Table] (ItemID,ItemName) VALUES (@ItemIDss,@Namess)");我强烈建议更改该名称,并使用该表内容的更具描述性的词语
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 of the content of that table
更多推荐
发布评论