c# access update语句出错

Question

初学，UPDATE tb_BookOnSell SET [图书名称] = '" + textBox1.Text + "',[出版社] = '" + textBox2.Text + "',[图书作者] = '" + textBox3.Text + "',[图书成色] = '" + textBox4.Text + "',[出售者] = '" + textBox5.Text + "',[图书简介] = '" + textBox6.Text + "',[图书价格] = '" + textBox7.Text + "',[图书类别]＝'" + textBox8.Text + "'WHERE [图书编号] ='" + bianhao+"'";问题在哪呢，关键字也没有冲突，总是提示update语句的语法错误。

Answer 1

谢谢大家，我的问题已经解决了
UPDATE tb_BookOnSell SET tb_BookOnSell.图书名称 = '" + textBox1.Text + "', tb_BookOnSell.出版社 = '" + textBox2.Text + " ', tb_BookOnSell.图书作者 = '" + textBox3.Text + "', tb_BookOnSell.图书成色 = '" + textBox4.Text + "', tb_BookOnSell.出售者 = '" + textBox5.Text + "', tb_BookOnSell.图书简介 = '" + textBox6.Text + "', tb_BookOnSell.图书价格 = '" + textBox7.Text + "', tb_BookOnSell.图书类别 = '" + textBox8.Text + "'WHERE [图书编号]='" + bianhao + "'";