表结构:testword
autoid int 自动增加
fdname varchar(50)
fdtext image
保存文件代码:
procedure TForm1.Button1Click(Sender: TObject);
begin
if OpenDialog1.Execute then
begin
if not ADOQuery1.Active then ADOQuery1.Open;
ADOQuery1.Append;
ADOQuery1fdname.Value:=ExtractFileName(OpenDialog1.FileName);
(ADOQuery1.FieldByName('fdtext') as TBlobField).LoadFromFile(OpenDialog1.filename);
ADOQuery1.Post;
end;
end;
打开文件代码:
procedure TForm1.Button2Click(Sender: TObject);
begin
(ADOQuery1.FieldByName('fdtext') as TBlobField).savetoFile(ExtractFileDir(Application.ExeName)+ADOQuery1fdname.value);
shellexecute(handle,nil,pchar(ADOQuery1fdname.value),nil,nil,sw_shownormal);
end;