在DBGRID的OnTitleClick事件里写,如: procedure TfrmKH.DBGrid1TitleClick(Column: TColumn); begin ADOQuery1.Sort:='FieldName1 [ASC|DESC],FieldName2 [ASC|DESC]'; end;
如果是table或cilentdataset procedure TForm1.DBGrid1TitleClick(Column: TColumn); begin with (DBGrid1.DataSource.DataSet as TclientDataset)do //或 with (DBGrid1.DataSource.DataSet as TTable)do IndexFieldNames:=column.FieldName; end;
用Order by +FieldName
procedure TfrmKH.DBGrid1TitleClick(Column: TColumn);
begin
ADOQuery1.Sort:='FieldName1 [ASC|DESC],FieldName2 [ASC|DESC]';
end;
procedure TForm1.DBGrid1TitleClick(Column: TColumn);
begin
with (DBGrid1.DataSource.DataSet as TclientDataset)do
//或 with (DBGrid1.DataSource.DataSet as TTable)do IndexFieldNames:=column.FieldName;
end;
procedure TfrmKH.DBGrid1TitleClick(Column: TColumn);
begin
ADOQuery1.Sort:=column.FieldName;
end;