main.pas

来自「Delphi7数据库开发教程,包含该书21套实例」· PAS 代码 · 共 62 行

unit main;

interface

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

type
  TForm1 = class(TForm)
    ADOStoredProc1: TADOStoredProc;
    DataSource1: TDataSource;
    DBGrid1: TDBGrid;
    ADOConnection1: TADOConnection;
    cbxActive: TCheckBox;
    ADOQuery1: TADOQuery;
    btnExecuteProc: TButton;
    procedure cbxActiveClick(Sender: TObject);
    procedure btnExecuteProcClick(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;

implementation

{$R *.dfm}

procedure TForm1.cbxActiveClick(Sender: TObject);
begin
  //根据复选框的状态设置是否调用存储过程
  with ADOStoredProc1 do
  begin
    Active := cbxActive.Checked ;
    //设置数据源
    if Active then
       DataSource1.DataSet := ADOStoredProc1;
  end;
end;

procedure TForm1.btnExecuteProcClick(Sender: TObject);
begin
  //通过execute执行存储过程
  with ADOQuery1 do
  begin
    if Active then
       Close;
    SQL.Clear ;
    SQL.Add('execute up_books_info;1');
    Open;
    //设置数据源
    if Active then
       DataSource1.DataSet := ADOQuery1;
  end;
end;

end.