string sql = @"Update Course set Course.CourseName ='" + TextBox2.Text + "' Course.Hours ='" + TextBox3.Text
+ "'Course.Credit ='" + TextBox4.Text + "'Course.Types ='" + RadioButtonList1.SelectedValue
+"' Course.FacultyId = Faculty.FacultyId from Course,Faculty where Faculty.FacultyName ='"
+ DropDownList4.SelectedValue + "'";他为什么老是说我Course附近有语法错误?求各位大侠指点、、、
update tb set c1='a',c2='b',c3='c'
更改的每个字段之间要有逗号
你的没有
"' , Hours ='" + TextBox3.Text+
"' , Credit ='" + TextBox4.Text +
"' , Types ='" + RadioButtonList1.SelectedValue +
"' , FacultyId = Faculty.FacultyId from Course,Faculty where Faculty.FacultyName ='" + DropDownList4.SelectedValue + "'";
Course和Faculty这两个表貌似还缺少连接条件.