我在窗口中设了加载树,怎么窗口中的缴费表(副本)、缴费情况表(正本)都没安日期倒序、单号倒序排序?
Dim cmd1 As New SQLCommand
Dim dt1 As DataTable
'cmd.C
cmd1.CommandText = "SELECT DISTINCT 住址_序号,住址_巷,住址_号,住址_房,户主姓名,手机号码,车牌号码 Fro m {缴费情况}"
dt1 = cmd1.ExecuteReader()
Dim trv1 As WinForm.TreeView = e.Form.Controls("TreeView1")
trv1.BuildTree(dt1,"住址_巷|住址_号|住址_房|户主姓名|手机号码|车牌号码","","住址_序号,住址_号,住址_房")
trv1.Nodes.Insert("加载数据",0)
'加载第一页数据
With DataTables("缴费情况")
.LoadFilter = "" '清除加载条件
.LoadPage = 0 '加载第一页
.LoadTop = 20 '每页5行
.LoadOrder = "日期 DESC,单号 DESC"
.LoadReverse = True
.Load()
e.Form.Controls("TextBox3").Value = 1 & "/" & .TotalPages
End With