插入问题

[HXLSJR]

windows窗体应用程序
执行插入的部分代码：
string instr = "insert into 学生考勤信息(studentID,studentname,calls,courseID,grade,age,sex,sequencenum,late,truancy,vacate,attendance,gradeofquestion,recorofquestion) values(" + textBox1.Text + "'," + textBox2.Text + "'," + textBox3.Text + "'," + textBox4.Text + "'," + textBox5.Text + "'," + textBox6.Text + "'," + textBox7.Text + "'," + textBox8.Text + "'," + textBox9.Text + "'," + textBox10.Text + "'," + textBox11.Text + "'," + textBox12.Text + "'," + textBox13.Text + "'," + textBox14.Text + "')";
显示有错误，请问是哪里的问题（不是字符类型不匹配得问题）？谢谢

[HXLSJR]

补加了单引号后：
E:\asp.net程序设计\随机点名系统\随机点名系统\Form3.cs(105,34): 错误 CS1012: 字符文本中的字符太多

[色拉油]

如一楼所言，少单引号，其实可以断点调试一下，看看你最后生成的SQL语句是什么
看不出错就去数据库执行以下，看看报什么错

[bdmh]

其他都懒得看了，第一个就看到问题了

values(" + textBox1.Text + "',"
你这个textBox1.Text 怎么只有后面加了引号，前面没加引号，这不是少半个吗，你好好查查吧

[tangxu12]

呵呵 楼上眼睛厉害

[EnForGrass]

[Quote=引用楼主 的回复:]
windows窗体应用程序
执行插入的部分代码：
string instr = "insert into 学生考勤信息(studentID,studentname,calls,courseID,grade,age,sex,sequencenum,late,truancy,vacate,attendance,gradeofquestion,recorofquestion) values(" + ……
[/Quote]
就是开头少单引号的问题

[全局变量]

)values(
每个"'," + textBox6.Text + "'都少点了
String.Format("insert into 学生考勤信息 (id,value1)values('{0}','{1}')","1","2");

[yp19910928]

你每个(" + textBox1.Text + "'都少了半个引号呢。是吧