shuoyin1.pas

一个不错的信息管理系统

unit shuoyin1;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, ExtCtrls;

type
  TForm27 = class(TForm)
    Panel1: TPanel;
    Label3: TLabel;
    Label2: TLabel;
    Label1: TLabel;
    Bevel1: TBevel;
    ComboBox1: TComboBox;
    Button1: TButton;
    Button2: TButton;
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form27: TForm27;

implementation

uses shuoyin;

{$R *.dfm}

procedure TForm27.Button1Click(Sender: TObject);
var
s:string;
begin
s:=combobox1.text;
form26.adoquery1.Active :=false;
if combobox1.Text='' then begin
   beep();
   showmessage('你的条件不能为空，请重新输入!');
   end
else begin
  form26.ADOQuery1.SQL.Clear;
  form26.adoquery1.SQL.Add('select * from a01 order by ');
  form26.ADOQuery1.SQL.Add(s);
  form26.adoquery1.ExecSQL;
  form26.adoquery1.Active:=true;
  form27.Close;
end;
end;
procedure TForm27.Button2Click(Sender: TObject);
begin
form27.Close;
end;

procedure TForm27.FormCreate(Sender: TObject);
begin
combobox1.Text:='';
end;

procedure TForm27.FormClose(Sender: TObject; var Action: TCloseAction);
begin
combobox1.Text:='';
end;

end.