为什么数据不能更新。。。。。？答对给分。。。。

[qaqaqa]

private void button1_Click(object sender, System.EventArgs e)
{
this.oleDbConnection1.Open ( ) ;
// 打开数据连接oleDbCommand1.CommandText
string udstr="UPDATE Persons set name='"
+textBox2.Text+"', HomePhone='"
+textBox3.Text+"', WorkPhone='"
+textBox4.Text+"', City='"
+textBox5.Text+"',Address='"+textBox6.Text+"',Email='"+textBox7.Text+"' WHERE (id="+textBox1.Text+")";
//string newstr="update persons set name="+textBox2.Text+" where id ="+textBox1.Text+"";
OleDbCommand cmd = new OleDbCommand (udstr, oleDbConnection1) ;
this.oleDbConnection1.Close();
MessageBox.Show("数据存储成功！"+udstr,"系统提示：");
}

[iambusy]

好像cmd没有execute

[arfeiz]

如果没有忘记cmd.execute,那么建议检查WHERE子句：WHERE (id="+textBox1.Text+")"

[doubleclick]

要执行cmd.ExecuteNonQuery方法才可以的

[netcar]

arfeiz(凌飞)说的有道理,改为如下:
WHERE (id='"+textBox1.Text+"')" //单引号将textBox1.Text括起