Question

asp.NET 的 update 语句 哪里有错啊

string mystr;
mystr = ConfigurationManager.ConnectionStrings["myconnstring"].ToString();
OleDbConnection myconn = new OleDbConnection();
myconn.ConnectionString = mystr;
myconn.Open();
OleDbCommand mycomm = new OleDbCommand();
mycomm.CommandText = "update Culture set [书名]='TextBox2.Text',[价格]='TextBox3.Text',[出版社]='TextBox4.Text', where [书号]="+TextBox1.Text+";

mycomm.CommandType = CommandType.Text;
mycomm.Connection = myconn;
mycomm.ExecuteNonQuery();
myconn.Close();
Label1.Text = "修改成功";

Answer 1

"update Culture set [书名]='TextBox2.Text',[价格]='TextBox3.Text',[出版社]='TextBox4.Text', where [书号]="+TextBox1.Text+";
该为：
string.Foramt("update Culture set [书名]='{0}', [价格]='{1}', [出版社]='{2}' where [书号]='{3}' ", TextBox2.Text, TextBox3.Text, TextBox4.Text, TextBox1Text);
对于多个string字符串拼接，可以使用 string.Format（）进行格式化~~~~

Answer 2

"update Culture set [书名]="&TextBox2.Text&",[价格]="&TextBox3.Text&",[出版社]="&TextBox4.Text&", where [书号]="&TextBox1.Text;

Answer 3

Text', where [书号] 中的，怎么回事？