clientindexesu1.pas

Delphi7从入门到精通及附书源码 Delphi7从入门到精通及附书源码

unit ClientIndexesU1;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, Grids, DBGrids, DB, ADODB;

type
  TForm1 = class(TForm)
    ADODataSet1: TADODataSet;
    DataSource1: TDataSource;
    DBGrid1: TDBGrid;
    procedure DBGrid1TitleClick(Column: TColumn);
    procedure FormCreate(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;

implementation

{$R *.dfm}

procedure TForm1.DBGrid1TitleClick(Column: TColumn);
begin
  if ADODataSet1.IndexFieldNames = Column.Field.FieldName then
    ADODataSet1.IndexFieldNames:=Column.Field.FieldName + ' DESC'
  else
    ADODataSet1.IndexFieldNames:=Column.Field.FieldName
end;

procedure TForm1.FormCreate(Sender: TObject);
begin
  ADODataSet1.Open;
end;

end.