搞定了,是这样的,
把update cx set (入帐日期,入帐租金) values('{0}','{1}') where ID='{2}'
改成update cx set 入帐日期='{0}',入帐租金='{1}' where ID='{2}'
就OK了,原来这么简单呀,我没想到,一开始,现在OK了!
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Me.OleDbConnection1.Open()
Me.OleDbDataAdapter1.UpdateCommand.Connection = Me.OleDbConnection1
Me.OleDbDataAdapter1.UpdateCommand.CommandText = String.Format("update cx set (入帐日期,入帐租金) values('{0}','{1}') where ID='{2}'", Me.TextBox5.Text, Me.TextBox2.Text, Me.TextBox9.Text)
Me.OleDbDataAdapter1.UpdateCommand.ExecuteNonQuery()
Me.OleDbConnection1.Close()
End Sub