unit1.~pas

ado查询经典实例delphi源码.rar

unit Unit1;

interface

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

type
  TForm1 = class(TForm)
    ADOConnection1: TADOConnection;
    DataSource1: TDataSource;
    DBGrid1: TDBGrid;
    Memo1: TMemo;
    Button1: TButton;
    Button3: TButton;
    ADOQuery1: TADOQuery;
    Label1: TLabel;
    Label2: TLabel;
    procedure Button2Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure FormActivate(Sender: TObject);
    procedure Button1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;

implementation

{$R *.dfm}

procedure TForm1.Button2Click(Sender: TObject);
begin
  Memo1.Lines.Clear;
  ADOQuery1.Close;
end;

procedure TForm1.Button3Click(Sender: TObject);
begin
 Try
    ADOQuery1.Close;
    ADOQuery1.SQL.Text := Memo1.Text;
    ADOQuery1.ExecSQL;
    Memo1.SetFocus;
  Except
    Memo1.SetFocus;
    ShowMessage('