Library Dbinstall;
{Important note about DLL memory management: ShareMem must be the first unit in your library's USES clause AND your project's (select Project-View Source) USES clause if your DLL exports any procedures or functions that pass strings as parameters or function results This applies. to all strings passed to and from your DLL -.. even those that are nested in records and classes ShareMem is the interface unit to the BORLNDMM.DLL shared memory manager, which must be deployed along with your DLL to avoid using BORLNDMM.DLL PASS STRING INFORMATION USING PCHAR OR SHORTSTRING Parameters.
Uses Comserv, Sysutils, Classes, Forms, ufrmmain in 'ufrmmain.pas' {frmmain};
{Open the MainForm, the entertance of Library} function OpenForm (): integer; stdcall; var FrmMain: TFrmMain; begin FrmMain: = TFrmMain.Create (nil); FrmMain.ShowModal (); result: = 0; FrmMain.Free; END;
Exports DllgetClassObject, DllcanunloadNow, DllregisterServer, Dllunregisterserver, OpenForm; {$ r * .res}
Begund.
Unit ufrmmain;
Interface
Uses Windows, Messages, Sysutils, Variants, Classes, Graphics, Controls, Forms, Dialogs, Stdctrls, DB, AdoDB;
type TFrmMain = class (TForm) GroupBox1: TGroupBox; Label1: TLabel; Label2: TLabel; txtUserName: TEdit; txtPassword: TEdit; btnOK: TButton; dbConn: TADOConnection; ADOQuery1: TADOQuery; procedure FormShow (Sender: TObject); procedure btnOKClick ( Sender: TOBJECT); private {private declarations}
IMPLEMentation
{$ R * .dfm}
Procedure tfrmmain.FormShow (sender: TOBJECT); begin txtusername.text: = 'sa'; txtpassword.text: = '; END;
procedure TFrmMain.btnOKClick (Sender: TObject); var isErrRetry: bool; begin isErrRetry: = false; dbConn.ConnectionString: = 'Provider = SQLOLEDB.1;' 'Password =' Trim (txtPassword.Text) '; Persist Security Info = True; User ID = ' Trim (txtUserName.Text) '; Data Source = localhost '; try dbConn.Open (); ADOQuery1.SQL.Text: =' RESTORE DATABASE MyNwind FROM MyNwind_1 '; ADOQuery1.ExecSQL Except ON E: Exception Do Begin if Messagedlg ('existing error:' E.Message 'ignore', mTerror, [Mbretry, Mbignore], 0) = mRRRETRY THEN ISERRRRETRY: = true else iSerRRRETRY: = false; End; dbconn.close (); if not iSerRRRETRY THEN MODALRESULT: = mrok;
End.
