Question

C#数据库insert 操作

SqlConnection cns = new SqlConnection(constr);

cns.Open();
SqlCommand sqlcom = new SqlCommand("insert into Finfo (Path,info) values( " + filefullpath + ",'" + "aaa" + "')", cns);
sqlcom.ExecuteNonQuery();

前面我读数据正常 写这段代码就报错 说sqlcom.ExecuteNonQuery();行 Incorrect syntax near ' '.

Answer 1

明显你的values里的两给值没有带单引号么！SQL里的insert语句规则是这样的：
insert into table (var1,var2) values( ‘value1’,'value2')；要加单引号的，你的值虽然是变量，但也是要加单引号的：改成：
SqlCommand sqlcom = new SqlCommand("insert into Finfo (Path,info) values( ‘" + filefullpath + "’,’aaa‘)", cns);
还有你这个aaa就是给字符串 干嘛用++号？

Answer 2

如果变量里面没问题，应该是少了单引号，如下即可
SqlCommand sqlcom = new SqlCommand("insert into Finfo (Path,info) values( '" + filefullpath + "','" + "aaa" + "')", cns);

Answer 3

values('"+filefullpath+"','aaa')
字符串变量两边都要有单引号

Answer 4

SqlCommand sqlcom = new SqlCommand("insert into Finfo (Path,info) values( '" + filefullpath + "','aaa')", cns);