There is a sort property of the data control without having the requery the server (I believe)

USAGE:

Adodc1.Recordset.Sort = "FieldName [ASC/DESC]"