一个用VB加Access写的用户信息管理实例,小弟想把它改成SQL的,无奈不是很懂,哪位大哥给改下让我参考啊。100分重谢!!
Private Sub Form_Load()
'建立数据源的连接
Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=usermanage.mdb;Persist Security Info=False"
'查询所有记录,并按"部门编号"排序
Adodc1.RecordSource = "select * from 用户信息表 order by 操作员编号"
Adodc1.Refresh
For i = 0 To 4
Text1(i).Enabled = False
Next i
CmdSave.Enabled = False
End Sub
Private Sub Text1_KeyDown(Index As Integer, KeyCode As Integer, Shift As Integer)
Select Case Index
Case Is = Index
If KeyCode = vbKeyReturn And Index < 4 Then Text1(Index + 1).SetFocus '回车获得焦点
If KeyCode = vbKeyReturn And Index = 4 Then CmdSave.SetFocus
If KeyCode = vbKeyUp And Index > 1 Then Text1(Index - 1).SetFocus
End Select
End Sub
Private Sub CmdAdd_Click() '添加记录
Adodc1.Recordset.AddNew
For i = 0 To 4
Text1(i).Enabled = True
Text1(i).Text = ""
Next i
Text1(0).SetFocus
CmdAdd.Enabled = False
CmdDelete.Enabled = False
CmdModify.Enabled = False
CmdSave.Enabled = True
End Sub
Private Sub CmdModify_Click() '修改记录
If Adodc1.Recordset.RecordCount <> 0 Then
For i = 0 To 4
Text1(i).Enabled = True
Next i
CmdSave.Enabled = True
CmdAdd.Enabled = False
CmdModify.Enabled = False
CmdDelete.Enabled = False
Else
MsgBox ("没有要修改的数据!")
End If
End Sub
Private Sub CmdDelete_Click() '删除记录
Dim myval As String
myval = MsgBox("是否要删除该记录?", vbYesNo)
If myval = vbYes Then
Adodc1.Recordset.Delete
Adodc1.Recordset.MoveNext
If Adodc1.Recordset.EOF = True Then Adodc1.Recordset.MoveLast
For i = 0 To 4
Text1(i).Enabled = False
Next i
End If
End Sub
Private Sub CmdSave_Click()
If Text1(0).Text = "" Then
MsgBox "操作员编号不允许为空!"
Exit Sub
End If
If Text1(1).Text = "" Then
MsgBox "姓名不允许为空!"
Exit Sub
End If
If Text1(2).Text = "" Then
MsgBox "用户ID号不允许为空!"
Exit Sub
End If
If Text1(3).Text = "" Then
MsgBox "密码不允许为空!"
Exit Sub
End If
If Text1(4).Text = "" Then
MsgBox "所属部门不允许为空!"
Exit Sub
End If
Adodc1.Recordset.Update '更新记录
'设置控件不可用
For i = 0 To 4
Text1(i).Enabled = False
Next i
CmdSave.Enabled = False
CmdAdd.Enabled = True
CmdModify.Enabled = True
CmdDelete.Enabled = True
End Sub
Private Sub CmdExit_Click()
Unload Me
End Sub