masterfield.pas

《delphi数据库设计与实例开发》随书光盘

unit MasterField;

interface

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

type
  TForm1 = class(TForm)
    ADOTable1: TADOTable;
    ADOTable2: TADOTable;
    ADOConnection1: TADOConnection;
    DataSource1: TDataSource;
    Panel1: TPanel;
    Splitter1: TSplitter;
    Panel2: TPanel;
    DBGrid1: TDBGrid;
    DBGrid2: TDBGrid;
    DataSource2: TDataSource;
    procedure FormCreate(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;

implementation

{$R *.dfm}

procedure TForm1.FormCreate(Sender: TObject);
var
 CurDir:String;
 begin
 GetDir(0,CurDir); //获得当前路径
 ADOConnection1.ConnectionString:='Provider=Microsoft.Jet.OLEDB.4.0;Data Source='+Curdir+'\DB\dbdemos.mdb;Persist Security Info=False';
 //建立连接字符串
 ADOConnection1.Connected:=True;//打开连接
 ADOTable1.TableName:='employee';
 ADOTable2.TableName:='orders';
 DataSource1.DataSet:=ADOTable1;
 ADOTable2.MasterSource:=DataSource1;
 ADOTable2.MasterFields:='EmpNo';
 ADOTable1.Open;
 ADOTable2.Open;
end;

end.