|
有些看不懂,比如k1,k2..是啥啊
strSQL = "SELECT DISTINCT Year([Èë¿âÈÕÆÚ]) AS MyYear FROM Èë¿â²éѯ ORDER BY Year([Èë¿âÈÕÆÚ]);"
Rec.Open strSQL, conn, adOpenKeyset, adLockOptimistic
Do While Not Rec.EOF
Set nodindex = TreeView.Nodes.Add("a", tvwChild, "b" & Rec("MyYear"), Rec("MyYear"), "K1", "K2")
nodindex.Sorted = True
nodindex.Tag = Rec("MyYear")
Rec.MoveNext |
|