procedure TForm1.DBGrid1TitleClick(Column: TColumn); begin Str:=Column.Title.Caption; if Adoquery1.Sort=Column.FieldName +' ASC ' then Adoquery1.Sort:=Column.FieldName +' DESC ' //a else Adoquery1.Sort:= Column.FieldName +' ASC '; //b end;
先设一个全局变量FSort:String;procedure TForm1.DBGrid1TitleClick(Column: TColumn); var CTStr:String; begin CTStr:=Column.Title.Caption; if (FSort='ASC') or (FSort='') then begin ADODateSet1.Sort:=Column.FieldName + ' ASC'; Column.Title.Caption:=CTStr+'▲'; FSort:='ASC'; end else begin ADODateSet1.Sort:=Column.FieldName + ' DESC'; Column.Title.Caption:=CTStr+'▼'; FSort:='DESC'; end; end;
begin
Str:=Column.Title.Caption;
if Adoquery1.Sort=Column.FieldName +' ASC ' then
Adoquery1.Sort:=Column.FieldName +' DESC ' //a
else
Adoquery1.Sort:= Column.FieldName +' ASC '; //b
end;
var CTStr:String;
begin
CTStr:=Column.Title.Caption;
if (FSort='ASC') or (FSort='') then
begin
ADODateSet1.Sort:=Column.FieldName + ' ASC';
Column.Title.Caption:=CTStr+'▲';
FSort:='ASC';
end
else
begin
ADODateSet1.Sort:=Column.FieldName + ' DESC';
Column.Title.Caption:=CTStr+'▼';
FSort:='DESC';
end;
end;