先作菜单,然后visible=false
在node_click事件里加
PopupMenu YourMenuName菜单事件里:
If txtUserName = "" Then
MsgBox "请输入用户名称", vbInformation, "用户修改"
Exit Sub
End If
'数据验证
Dim strSql As String
strSql = "sp_User "
strSql = strSql & "@n_UserID=" & txtID & ","
strSql = strSql & "@s_UserID='" & Trim(txtLoginName) & "',"
strSql = strSql & "@s_Password='" & Trim(txtPassWord) & "',"
strSql = strSql & "@s_Name='" & Trim(txtUserName) & "',"
strSql = strSql & "@s_Dept='" & Trim(cmbDept.List(cmbDept.ListIndex)) & "',"
strSql = strSql & "@s_UserMark='" & Trim(cmbUserMark.List(cmbUserMark.ListIndex)) & "',"
strSql = strSql & "@s_Tel='" & Trim(txtTel) & "',"
strSql = strSql & "@s_Email='" & Trim(txtMail) & "',"
strSql = strSql & "@s_Note='" & Trim(txtnote) & "',"
strSql = strSql & "@s_Editor='" & UserInfo(2) & "'" On Error Resume Next
cn.Execute strSql
If Err.Number <> 0 Then
MsgBox Err.Description, vbInformation, "错误"
Exit Sub
End If
MsgBox "已经保存此用户", vbInformation, "用户修改"
'sp_user 为一存储过程,用来保存修改
在node_click事件里加
PopupMenu YourMenuName菜单事件里:
If txtUserName = "" Then
MsgBox "请输入用户名称", vbInformation, "用户修改"
Exit Sub
End If
'数据验证
Dim strSql As String
strSql = "sp_User "
strSql = strSql & "@n_UserID=" & txtID & ","
strSql = strSql & "@s_UserID='" & Trim(txtLoginName) & "',"
strSql = strSql & "@s_Password='" & Trim(txtPassWord) & "',"
strSql = strSql & "@s_Name='" & Trim(txtUserName) & "',"
strSql = strSql & "@s_Dept='" & Trim(cmbDept.List(cmbDept.ListIndex)) & "',"
strSql = strSql & "@s_UserMark='" & Trim(cmbUserMark.List(cmbUserMark.ListIndex)) & "',"
strSql = strSql & "@s_Tel='" & Trim(txtTel) & "',"
strSql = strSql & "@s_Email='" & Trim(txtMail) & "',"
strSql = strSql & "@s_Note='" & Trim(txtnote) & "',"
strSql = strSql & "@s_Editor='" & UserInfo(2) & "'" On Error Resume Next
cn.Execute strSql
If Err.Number <> 0 Then
MsgBox Err.Description, vbInformation, "错误"
Exit Sub
End If
MsgBox "已经保存此用户", vbInformation, "用户修改"
'sp_user 为一存储过程,用来保存修改
解决方案 »
- 你的礼物我很喜欢,谢谢
- agent发不出声,请问那两个TTS发声引擎在哪下载,最好是微软本站的下载地址
- [讨论]作为一个版主,应该怎样管理论坛?作为一个网友,应该如何在论坛上生存?
- 简单问题:对ACCESS2000数据库只能用ACCESS2000进行编辑吗?
- 问题出在哪?谢谢!
- 导入文本文件时,可以取得文本文件的行数吗?
- DTPicker1控件的DTPicker1.Value属性怎样设为空,我在程序中需要其为空.
- 请教各位一个sql server的问题,急!!!
- VB编程的问题
- vb6 + 水晶报表9 , 如何让代码设定打印报表的打印机,而不是人工选择? 因为可能要在非默认的打印机上打印.
- 将Word文件转换成Rtf格式或读入到Richtextbox中呢
- 我想利用一个datagrid控件来显示一个record对象记录集的全部记录,请问怎么用?
dim mdownRight as boolean
Private Sub TreeView1_NodeClick(ByVal Node As MSComctlLib.Node)
If mdownRight = True Then
PopupMenu mnuEdit1'mnuEdit1为右健菜单的名字
End If
End Sub
Private Sub TreeView1_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
'判断鼠标右键按下
If Button = vbRightButton Then
mdownRight = True
End If
End Sub