Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
sorting data in a datagrid
- Thread starter DeepBlerg
- Start date
Hi Deepblerg
I do it like this.
Adodc1 is a adodc datacontrol connected to a database.
The datagrid is set like this:
Set Datagrid1.DataSource = Adodc1
Than you can sort every column in a wanted direction up or down like this:
With Adodc1.Recordset
.Sort = .Fields(ColChosen).Name & " ASC"
End With
Colchosen is the selected column.
or down with:
.Sort = .Fields(ColChosen).Name & " DESC"
Hope this works for you (I use VB6/Access2000 database)
ICET
I do it like this.
Adodc1 is a adodc datacontrol connected to a database.
The datagrid is set like this:
Set Datagrid1.DataSource = Adodc1
Than you can sort every column in a wanted direction up or down like this:
With Adodc1.Recordset
.Sort = .Fields(ColChosen).Name & " ASC"
End With
Colchosen is the selected column.
or down with:
.Sort = .Fields(ColChosen).Name & " DESC"
Hope this works for you (I use VB6/Access2000 database)
ICET
- Status
