Question

VB数据库“添加”代码错在哪

Private Sub Command1_Click()
Form1.Adodc1.Recordset.AddNew

Form1.Adodc1.Recordset.Fields("学号") = Text1.Text
Form1.Adodc1.Recordset.Fields("姓名") = Text2.Text
Form1.Adodc1.Recordset.Fields("性别") = Combo1.Text
Form1.Adodc1.Recordset.Fields("班级") = Text3.Text
Form1.Adodc1.Recordset.Fields("语文") = Text4.Text
Form1.Adodc1.Recordset.Fields("数学") = Text5.Text
Form1.Adodc1.Recordset.Fields("英语") = Text6.Text
Form1.Adodc1.Recordset.Fields("VB") = Text7.Text

Form1.Adodc1.Recordset.Save
Form1.Adodc1.Refresh
End Sub

Answer 1

Form1.Adodc1.Recordset.Save改成 Form1.Adodc1.Recordset.update

Answer 2

“学号”之类的属性最好不用使用汉字，改用英文做属性