Private Sub DataGrid1_HeadClick(ColIndex As Integer)
Data1.RecordSource = "Select * From Publishers Order By " & _
DataGrid1.Columns(ColIndex).DataField
Data1.Refresh
End Sub
Private Sub DataGrid1_HeadClick(ByVal ColIndex As Integer)
if FallCom=true then 'FallCom定为全局boolean变量,初值设为true
FallCom=False
'升序排序
else
FallCom=true
'降序排序
end if
End Sub
Private Sub DataGrid1_HeadClick(ByVal ColIndex As Integer)
'...
rs2.open "select * from table where...order by "& rs1.fields(colindex) & iif(" asc "," desc "," asc"),cnn,3,3
set datagrid1.datasource=rs2
End Sub