ADO连接,Datagrid显示数据,按字段No排序adoSearch.CommandType = adCmdText
adoSearch.RecordSource = "SELECT * FROM tabProject order by No"
adoSearch.Refresh排序结果如下:
CHN0400013
CHN0300001
CHN0300002
CHN0400003
CHN0400007
CHN0400006
CHN0400008
CHN0400009
CHN0400010
CHN0400012
CHN0400014
CHN0400005
CHN0400004
CHN0400011
adoSearch.RecordSource = "SELECT * FROM tabProject order by No"
adoSearch.Refresh排序结果如下:
CHN0400013
CHN0300001
CHN0300002
CHN0400003
CHN0400007
CHN0400006
CHN0400008
CHN0400009
CHN0400010
CHN0400012
CHN0400014
CHN0400005
CHN0400004
CHN0400011
谢谢,解决问题啦,但要注意顺序adoSearch.RecordSource = "SELECT * FROM tabProject order by No"
adoSearch.Refresh
adoSearch.recordset.sort='No'
还有我的程序为什么之前能实现该排序,而后的排序结果却混乱不堪?