“where子句语法错误”

[lucksea521]

string teacherIDNameSql5 = "select teacher_id as 教师编号,teacher_name as 教师姓名,teach_subject as 所授课程,group as 所属教学组,tea_class as 所教班数,tel as 电话,sex as 性别 from teacher where group='"+TeachGroup+"'";
DataSet teacherIDNameDs5 = new DataSet();
MdbConn.Open();
OleDbDataAdapter teacherDA5 = new OleDbDataAdapter(teacherIDNameSql5, MdbConn);
teacherDA5.Fill(teacherIDNameDs5);
dataGridView1.DataSource = teacherIDNameDs5.Tables[0].DefaultView;

这句提示“where子句语法错误”，不知道什么原因

[娃都会打酱油了]

group是关键字 ，改成[group]，话说你这是什么数据库？

[lucksea521]

引用 1 楼 starfd 的回复:

group是关键字 ，改成[group]，话说你这是什么数据库？

多谢，多谢！ 是access

[正怒月神]

1楼正解，[group]