Question

C#编程中要怎么处理错误Incorrect syntax near the keyword 'insert'.Incorrect syntax near ''.

sql2 = "insert into Person ( ID,name,sex,place,level,specialty,work,department,busi";
sql3 = "values('" + textBox1.Text.ToString() + "','" + textBox2.Text.ToString() + "','" + comboBox1.Text.
ToString() + "','" + textBox3.Text.ToString() + "','" + textBox5.Text.
ToString() + "','" + textBox6.Text.ToString() + "','" + textBox7.Text.ToString() + "','" + textBox8.Text.
ToString() + "','" + textBox9.Text.ToString() + "'"
sql1 = sql2 + ")" + sql3 + ")";
cmd.CommandText = sql1;
cmd.ExecuteNonQuery();
在执行的时候系统提示错误Incorrect syntax near the keyword 'insert'.
Incorrect syntax near ''.，要怎么处理这个错误呢？

Answer 1

你的sql2有问题（字段数据类型，你自已注意一下。如果有数值型的，就要用'小分号） ：
改成以下的试试：
sql2 = "insert into Person ( name,sex,place,level,specialty,work,department,busi";
sql3 = " values('" + textBox1.Text.ToString() + "','" + textBox2.Text.ToString() + "','" + comboBox1.Text.
ToString() + "','" + textBox3.Text.ToString() + "','" + textBox5.Text.
ToString() + "','" + textBox6.Text.ToString() + "','" + textBox7.Text.ToString() + "','" + textBox8.Text.
ToString() + "','" + textBox9.Text.ToString() + "'"

另外那个ID，在数据库中要改为自动增加。

Answer 2

你把那个sql1输出一下看看 结构时候正确 如果不行就把sql1粘到查询分析器试试

Answer 3

insert into table (字段)
少括号