unit1.pas

来自「Delphi7应用编程150例附书源码.rar」· PAS 代码 · 共 40 行

unit Unit1;

interface

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

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

var
  Form1: TForm1;

implementation

{$R *.dfm}

procedure TForm1.FormCreate(Sender: TObject);
var
    str:String;
begin
    self.ADODataSet1.Active:=false;
    str:='select orders.EmpNo,orders.SaleDate,employee.LastName ';
    str:=str+' from orders,employee where orders.EmpNo=employee.Empno';
    self.ADODataSet1.CommandText:=str;
    self.ADODataSet1.Active:=true;
end;

end.