procedure TFrm_BrigeInfo.ShowPicture; var TStream:TMemoryStream; JpgFile:TjpegImage; Query_Picture:TADOQuery; begin TStream:=TMemoryStream.Create; JpgFile:=TjpegImage.Create; Query_Picture:=TADOQuery.Create(self); Query_Picture.Connection:=Config.ADOCon;//Config.ADOCon是Config单元中定义的ADO对象 Query_Picture.SQL.Clear; Query_Picture.Close; Query_Picture.SQL.Add(‘select 桥梁照片 from 桥涵设施普查基层表 where 桥梁名称=:a'); Query_Picture.Parameters.ParamByName('a').Value:=trim(Edt_name.Text); Query_Picture.Active:=true; Query_Picture.Open; if Query_Picture.FieldByName('桥梁照片').IsNull then begin Messagebox(Handle,'未存入图片!','信息',MB_ICONEXCLAMATION); end else begin TBlobField(Query_Picture.FieldByName('桥梁照片')).SaveToStream(TStream); TStream.Position:=0; JpgFile.LoadFromStream(TStream); Image_Brige.Picture.Assign(JpgFile); TStream.Free; JpgFile.Free; end; end; 前段时间刚写的,用流文件的方式显示,窗口中使用的Image_Brige是一个TImage对象,库文件中要加上jpeg,
var
TStream:TMemoryStream;
JpgFile:TjpegImage;
Query_Picture:TADOQuery;
begin
TStream:=TMemoryStream.Create;
JpgFile:=TjpegImage.Create;
Query_Picture:=TADOQuery.Create(self);
Query_Picture.Connection:=Config.ADOCon;//Config.ADOCon是Config单元中定义的ADO对象
Query_Picture.SQL.Clear;
Query_Picture.Close;
Query_Picture.SQL.Add(‘select 桥梁照片 from 桥涵设施普查基层表 where 桥梁名称=:a');
Query_Picture.Parameters.ParamByName('a').Value:=trim(Edt_name.Text);
Query_Picture.Active:=true;
Query_Picture.Open;
if Query_Picture.FieldByName('桥梁照片').IsNull then
begin
Messagebox(Handle,'未存入图片!','信息',MB_ICONEXCLAMATION);
end else
begin
TBlobField(Query_Picture.FieldByName('桥梁照片')).SaveToStream(TStream);
TStream.Position:=0;
JpgFile.LoadFromStream(TStream);
Image_Brige.Picture.Assign(JpgFile);
TStream.Free;
JpgFile.Free;
end;
end;
前段时间刚写的,用流文件的方式显示,窗口中使用的Image_Brige是一个TImage对象,库文件中要加上jpeg,
在Delphi Demo中,有实例,自己找参阅即可。