unitdata.~pas

Delphi与sqlserver应用。适用于初学者

unit UnitData;

interface

uses
  SysUtils, Classes, DB, ADODB,Forms,Dialogs,Windows,Messages;
type
  TDataModule1 = class(TDataModule)
    ADOCon: TADOConnection;
    ADOQ: TADOQuery;
    ADOQReg: TADOQuery;
    ADOQEnq: TADOQuery;
    procedure DataModuleCreate(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  DataModule1: TDataModule1;

implementation

{$R *.dfm}
procedure TDataModule1.DataModuleCreate(Sender: TObject);
var
  s: string;
begin
  try
    s := ExtractFilePath(Application.Exename)+'MainServer.udl';
    ADOCon.Close;
    ADOCon.Provider := 'SQLOLEDB';
    ADOCon.LoginPrompt := false;
    ADOCon.ConnectionTimeout :=5;
    ADOCon.CommandTimeout :=10;
    ADOCon.ConnectionString := 'File name=' + s;
    ADOCon.Open;
  except
    Application.MessageBox('数据库连接失败，请使用程序目录下MainServer.udl测试连接!', '提示', 0);
    ExitProcess(0);
  end;
end;

end.