procedure Tysmain.N4Click(Sender: TObject); var dbname: string; begin if fadoconnect.ado.Connected = true then fadoconnect.ado.Connected:=false;
dbname := ExtractFilePath(Application.ExeName)+FormatDateTime('yyyy"年"mm"月"dd"日" hh"时"nn"分"ss"秒"', now())+ '备份.bak'; if FileExists(dbname) then DeleteFile(dbname); CopyFile(Pchar('mdb.mdb'), Pchar(dbname), true); MessageBox(handle, '数据库备份成功!', '提示', mb_IconInformation + mb_Ok); if fadoconnect.ado.Connected = false then fadoconnect.ado.Connected := true; end;
procedure Tysmain.N8Click(Sender: TObject); var dbname, dbbname: string; begin if MessageBox(self.Handle, '确认要还原数据么? ', '提示', mb_IconQuestion + mb_YesNo) = idYes then begin if fadoconnect.ado.Connected = true then fadoconnect.ado.Connected:=false; dbname := ExtractFilePath(Application.ExeName)+ 'mdb.mdb'; if opendialog.Execute then dbbname :=opendialog.FileName; //showmessage('当前目录为---"'+dbbname+'"'); if not FileExists(dbbname) then MessageBox(self.Handle, '没有备份数据,不能还原', '提示', mb_IconInformation + mb_Ok) else begin CopyFile(Pchar(dbbname), Pchar(dbname), true); MessageBox(handle, '数据库还原成功!', '提示', mb_IconInformation + mb_Ok); end; if fadoconnect.ado.Connected =false then fadoconnect.ado.Connected:=true; end; end;文字自己看看下面的代码,反正我用此方法可以备份数据,也可以还原!
----------------------------------------------
小弟乃初学者!多多指教!拜托拉!!