如果不用数据控件的话,是比较简单的var
ms:tmemorystream;
begin
ms:=tmemorystream.Create;
image1.Picture.Bitmap.SaveToStream(ms);
ms.Position:=0;
with query1 do
begin
close;
sql.Clear;
sql.Add('insert into image_table (id_im,test_im,image_im) values (:id,:test,:image)');
parambyname('id').asinteger:=2;
parambyname('test').asstring:='图';
try
parambyname('image').LoadFromStream(ms,ftblob);
except
ms.Free;
end;
execsql;
end;
ms.Free;
ms:tmemorystream;
begin
ms:=tmemorystream.Create;
image1.Picture.Bitmap.SaveToStream(ms);
ms.Position:=0;
with query1 do
begin
close;
sql.Clear;
sql.Add('insert into image_table (id_im,test_im,image_im) values (:id,:test,:image)');
parambyname('id').asinteger:=2;
parambyname('test').asstring:='图';
try
parambyname('image').LoadFromStream(ms,ftblob);
except
ms.Free;
end;
execsql;
end;
ms.Free;
解决方案 »
- delphi通过ADO直接连接SQL2005,不通过ODBC,连接串怎么弄
- 求教:系统登陆问题
- 失业了,找工作了~
- 在线等待各位大侠帮忙解决VCLSkin2.3的BUG!
- 老总让做一个信息管理系统,没有范围,各方面的信息。而且类别、字段都得留着给他输,汇总、分析没法弄,这可怎么做?
- 请问如何控制DBGrid的编辑、提交等操作??我现在一旦跑到下一条记录它就自动提交了,怎么办,根本不听我的控制?
- 请问创建控件数组吗
- 请问Oracle的10用户、5用户是怎么回事?
- ◎◎◎ 有没有什么办法把程序的菜单移到窗体的下边。
- 如和用Delphi注册系统热键?
- 如何高速采样
- 请问高手安装Delphi应用程序问题
begin
if openpicturedialog1.Execute=true then
dbimage1.Picture.LoadFromFile(openpicturedialog1.FileName );end;
dm.Adodataset1.Edit;
dm.adodataset1.FieldByName('blobs').AsString:=blobtostring(‘C:\a.bmp’);
function BlobToString(const FileName: string): string;
var
Fstream:Tfilestream;
begin
Fstream:=TFilestream.Create(Filename,fmopenread);
setlength(Result,fstream.Size );
Fstream.Read(pointer(result)^,fstream.Size);
fstream.Free;
end;
end;
procedure TForm_employee.DBImage1MouseDown(Sender: TObject;
Button: TMouseButton; Shift: TShiftState; X, Y: Integer);
var
file_name: string;
FileExt: string[4];
begin
if Button = mbRight then
begin
if OpenPictureDialog1.Execute then
begin
file_name:=OpenPictureDialog1.FileName;
FileExt:=AnsiUpperCase(ExtractFileExt(file_name));
if (FileExt = '.BMP') or (FileExt = '.ICO') or
(FileExt = '.WMF') or (FileExt = '.EMF') then
begin
DBImage1.Picture.LoadFromFile(file_name);
end;
end;
end;
end;