Select可以用排序参数啊,例如帮助的代码是:
For Each dr1 As DataRow In DataTables("表A").Select("[金额] > 100")
Dim dr2 As DataRow = DataTables("表B").AddNew()
For Each dc As DataCol in DataTables("表A").DataCols
dr2(dc.Name) = dr1(dc.name)
Next
Next
你要根据日期顺序填充,只需:
For Each dr1 As DataRow In DataTables("表A").Select("[金额] > 100","日期")
Dim dr2 As DataRow = DataTables("表B").AddNew()
For Each dc As DataCol in DataTables("表A").DataCols
dr2(dc.Name) = dr1(dc.name)
Next
Next
您看一下Select的帮助:
http://www.foxtable.com/help/topics/0400.htm