Private Sub TreeView1_Click()
Dim Focuskey As String
'根据关键字获取部门信息
Focuskey = TreeView1.SelectedItem.Key
CurDepart.Depart_Name = TreeView1.SelectedItem.Text
CurDepart.Depart_Id = Val(Right(TreeView1.SelectedItem.Key, Len(TreeView1.SelectedItem.Key) - 1))
If Focuskey = "a0" Then '根结点 AdoStaffNameList.RecordSource = "SELECT * FROM Staff WHERE Depart_Id<0"
AdoStaffNameList.Refresh DataList1.ReFill
Exit Sub
End If
注:数据库是连接了的,表名也正确
Dim Focuskey As String
'根据关键字获取部门信息
Focuskey = TreeView1.SelectedItem.Key
CurDepart.Depart_Name = TreeView1.SelectedItem.Text
CurDepart.Depart_Id = Val(Right(TreeView1.SelectedItem.Key, Len(TreeView1.SelectedItem.Key) - 1))
If Focuskey = "a0" Then '根结点 AdoStaffNameList.RecordSource = "SELECT * FROM Staff WHERE Depart_Id<0"
AdoStaffNameList.Refresh DataList1.ReFill
Exit Sub
End If
注:数据库是连接了的,表名也正确
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货