Rss & SiteMap
Foxtable(狐表) http://www.foxtable.com
Dim cmd As New S QL Co mmand
cmd.ConnectionName =
"数据源名称"
Dim dt As
DataTable
Dim
cmb As
WinForm.ComboBox
cmd.Comm and Text = "SE\ECT
DISTINCT FORMAT(数量*单价,'F2') as 总价 From {订单}"
dt = cmd.ExecuteReader()
cmb =
e.Form.Controls("ComboBox1")
cmb.Com boLi st= dt.GetComboListString("客户")
这种查询出来的表格,总价进行排序的时候,如何按照数值排列,而不是字符串的形式呢。
比如:
9090.00
74650.00
7000.00
58000.00
数值排序应该是:
74650.00
58000.00
9090.00
7000.00