Private Sub cmdOk_Click()
'On Error Resume Next
If op <> "del" Then '如果是执行添加或编辑操作
Adodc1.Recordset("序号") = stId.Text
Adodc1.Recordset("机柜号") = stCabinet.Text
Adodc1.Recordset("KVM") = stKVM.Text
Adodc1.Recordset("服务器") = stServer.Text
Adodc1.Recordset("IP") = stIP.Text
Adodc1.Recordset("服务器应用") = stServerUse.Text
Adodc1.Recordset("网卡") = stNetwordCard.Text
Adodc1.Recordset("线号") = stLine.Text
Adodc1.Recordset("交换机") = stGuidway.Text
Adodc1.Recordset("端口") = stPort.Text
Else
Adodc1.Recordset.Delete '删除当前记录
End If
Adodc1.Recordset.Updata '更新
Unload Me
End Sub
Private Sub cmdCancel_Click()
Unload Me
End Sub
Private Sub Form_Load()
'On Error Resume Next
Select Case op
Case "add"
DataRegister.Caption = "添加记录"
Case "edit"
DataRegister.Caption = "编辑记录"
Case "del"
DataRegister.Caption = "删除记录"
End Select
'Adodc1.Refresh
If op <> "add" Then '如果是执行删除或编辑操作
Adodc1.Recordset.Bookmark = bm
stId.Text = Adodc1.Recordset("序号")
stCabinet.Text = Adodc1.Recordset("机柜号")
stKVM.Text = Adodc1.Recordset("KVM")
stServer.Text = Adodc1.Recordset("服务器")
stIP.Text = Adodc1.Recordset("IP")
stServerUse.Text = Adodc1.Recordset("服务器应用")
stNetwordCard.Text = Adodc1.Recordset("网卡")
stLine.Text = Adodc1.Recordset("线号")
stGuidway.Text = Adodc1.Recordset("交换机")
stPort.Text = Adodc1.Recordset("端口")
'Else
'Adodc1.Recordset.AddNew
End If
End Sub