Private Sub DataGrid1_HeadClick(ByVal ColIndex As Integer) adc1.RecordSource = "select * from ..... order by " & datagrid1.Columns(ColIndex).DataField adc1.refresh end sub
Private Sub dtgProducts_HeadClick(ByVal intColIndex As Integer) 'Sort by clicked column With envData.rsProducts .Sort = .Fields(intColIndex).Name & " ASC" End With dtgProducts.Refresh End Sub
Private Sub DataGrid1_HeadClick(ByVal ColIndex As Integer) adc1.RecordSource = "select * from ..... order by " & datagrid1.Columns(ColIndex).DataField adc1.refresh end sub应该是datagrid1.Columns(ColIndex + 1).DataField
Private Sub DataGrid1_HeadClick(ByVal ColIndex As Integer) Adodc1.Recordset.Sort = DataGrid1.Columns(ColIndex).DataFieldEnd Sub
Private Sub DataGrid1_HeadClick(ByVal ColIndex As Integer) Adodc1.Recordset.Sort = DataGrid1.Columns(ColIndex).DataField '正序排序 '反序排序 Adodc1.Recordset.Sort = DataGrid1.Columns(ColIndex).DataField + " desc" End Sub 注意:在逆序排序中 desc 前有个空格!!...
Select Case ColIndex
case 0
'在此插入排序语句
case 1
....
End Select
End Sub
adc1.RecordSource = "select * from ..... order by " & datagrid1.Columns(ColIndex).DataField
adc1.refresh
end sub
这个排序倒是挺好的,可是反向排序去不知道用什么属性?
'Sort by clicked column
With envData.rsProducts
.Sort = .Fields(intColIndex).Name & " ASC"
End With
dtgProducts.Refresh
End Sub
adc1.RecordSource = "select * from ..... order by " & datagrid1.Columns(ColIndex).DataField
adc1.refresh
end sub应该是datagrid1.Columns(ColIndex + 1).DataField
Adodc1.Recordset.Sort = DataGrid1.Columns(ColIndex).DataFieldEnd Sub
Adodc1.Recordset.Sort =
DataGrid1.Columns(ColIndex).DataField '正序排序
'反序排序
Adodc1.Recordset.Sort =
DataGrid1.Columns(ColIndex).DataField + " desc"
End Sub
注意:在逆序排序中 desc 前有个空格!!...