unit4.~pas

Delphi结合Access

unit Unit4;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, DBCtrls, DB, ADODB, ExtCtrls, Mask, ComCtrls;

type
  TForm4 = class(TForm)
    GroupBox3: TGroupBox;
    DBNavigator1: TDBNavigator;
    ADOConnection1: TADOConnection;
    DataSource1: TDataSource;
    ADOTable1: TADOTable;
    DBMemo1: TDBMemo;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    Label8: TLabel;
    Label9: TLabel;
    StatusBar1: TStatusBar;
    DBEdit1: TDBEdit;
    DBEdit2: TDBEdit;
    DBEdit3: TDBEdit;
    DBEdit4: TDBEdit;
    DBEdit5: TDBEdit;
    DBEdit6: TDBEdit;
    DBComboBox1: TDBComboBox;
    DBComboBox2: TDBComboBox;
    procedure DataSource1DataChange(Sender: TObject; Field: TField);
    procedure FormCreate(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form4: TForm4;

implementation

{$R *.dfm}

procedure TForm4.DataSource1DataChange(Sender: TObject; Field: TField);
var
  i:integer;
begin
  i:=ADOTable1.RecNo;
  Statusbar1.Panels[0].Text:='第' + IntToStr(i) + ' 条记录，总共' + IntToStr(ADOTable1.RecordCount) + ' 条记录';
end;

procedure TForm4.FormCreate(Sender: TObject);
begin
  try
    ADOConnection1.Open;
    ADOTable1.Active:=true;   
  except
    application.MessageBox('找不到数据库，引起该问题的原因是数据库文件可能被人为删除或改名。','无法打开数据库',0);
    application.Terminate;
  end;    
end;

procedure TForm4.FormClose(Sender: TObject; var Action: TCloseAction);
begin
  Action:=cafree;
end;

end.