treeview中NODEMOUSECLICK事件代码:
以下内容为程序代码:
1 Dim Value()As String
2 Dim Filter As String
3
4 Value = e.Node.FullPath.Split("\")
5 If user.Name = "开发者" Or user.name = "管理员"
6 Select Case e.Node.Level
7 Case 0
8 Filter ="[nt] = '" & Value(0) & "'"
9 End Select
10 Else
11 Select Case e.Node.Level
12 Case 0
13 Filter ="[nt] = '" & Value(0) & "' And [qzh] = '" & User.Group & "'"
14 End Select
15 End If
16
17 If e.Node.Name="加载全部记录" Then
18 If user.Name = "开发者" Or user.name = "管理员"
19 Filter = "[_Identify] Is not null"
20 Else
21 Filter = "[qzh] = '" & User.Group & "'"
22 End If
23 End If
24
25 DataTables("ajk").LoadFilter = Filter
26 DataTables("ajk").Load()
问题:如何修改代码,使得点击某结点加载的数据按照“dh”排序,他这样点击结点后显示的数据实际上是按照主键递增排序的,现在我想要按照“dh”字段值递增排序,该怎么做?