unitdatamodule.pas

此程序是可以将数据库表中的数据导出转为EXCEL、也可将EXCEL中的数据导入至数据库的表中。

unit UnitDataModule;

interface

uses
  SysUtils, Classes,Forms, DB, ADODB;

type
  TDM = class(TDataModule)
    ADOConnection1: TADOConnection;
    procedure DataModuleCreate(Sender: TObject);
    procedure ADOConnection1AfterConnect(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  DM: TDM;

implementation

{$R *.dfm}

procedure TDM.DataModuleCreate(Sender: TObject);
begin
  {try
    ADOConnection1.Connected:=true;
  except
    Application.MessageBox('连接数据库错误!','提示');
    Application.Terminate;
  end;
  }
end;

procedure TDM.ADOConnection1AfterConnect(Sender: TObject);
begin
  //Application.MainForm.Caption :='连接成功';
end;

end.