Foxtable(狐表)用户栏目专家坐堂 → 怎样让combolist由多到少排列?


  共有5297人关注过本帖平板打印复制链接

主题:怎样让combolist由多到少排列?

帅哥哟,离线,有人找我吗?
有点甜
  1楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:版主 帖子:85326 积分:427815 威望:0 精华:5 注册:2012/10/18 22:13:00
  发帖心情 Post By:2013/8/12 23:05:00 [只看该作者]

代码

Dim cb1 As WinForm.ComboBox = e.Form.Controls("ComboBox1")

Dim dics As new SortedDictionary(Of Integer, String)
For Each data As String In  DataTables("表A").GetUniqueValues("", "第一列")
    Dim count As Integer = DataTables("表A").Compute("count(_Identify)", "第一列 = '" & data & "'")
    dics.Add(count, data)
Next

Dim x As Integer = 0
For Each i As Integer In dics.keys
    cb1.Items.Insert(0, dics(i))
    x += 1
Next

 回到顶部