text 已绑定adodc1
我的代码如下
Private Sub Cmdadd_Click()'Adodc1.Recordset.AddNew
'Adodc1.Recordset.Fields("wno") = Txtwno.Text
'Adodc1.Recordset.Fields("wname") = Txtwname.Text
'Adodc1.Recordset.Fields("storenum") = Txtstorenum.Text
''Adodc1.Recordset.Fields("unit") = Txtunit.Text
'Adodc1.Recordset.Update
End Sub
每次新增数据就会把指针指向的记录修改掉
'Adodc1.Recordset.AddNew
'Adodc1.Recordset.Fields("wno") = Txtwno.Text
'Adodc1.Recordset.Fields("wname") = Txtwname.Text
'Adodc1.Recordset.Fields("storenum") = Txtstorenum.Text
''Adodc1.Recordset.Fields("unit") = Txtunit.Text
'Adodc1.Recordset.Update
End Sub
Adodc1.Recordset.AddNew
Adodc1.Recordset.Fields("a") = Text1.Text
Adodc1.Recordset.Fields("b") = Text2.Text
Adodc1.Recordset.Fields("c") = Text3.Text
Adodc1.Recordset.Fields("d") = Text4.Text
Adodc1.Recordset.Update
End SubPrivate Sub Command2_Click()'逐条显示记录
If Not Adodc1.Recordset.EOF Then
Text1.Text = Adodc1.Recordset.Fields("a")
Text2.Text = Adodc1.Recordset.Fields("b")
Text3.Text = Adodc1.Recordset.Fields("c")
Text4.Text = Adodc1.Recordset.Fields("d")
Adodc1.Recordset.MoveNext
End If
End Sub