显示(从数据库中得来) with query1 do begin close; sql.Clear; sql.Add('select p_image from t_park where p_no=:p_no'); parambyname('p_no').asstring:=pstring(tv.selected.Data)^; open; end; pr_query_detail(pstring(tv.selected.Data)^); if (query1.RecordCount<>0) and (not(query1.FieldByName('p_image').IsNull)) then begin try m_JpegStream:=TMemoryStream.Create; (Query1.FieldByName('p_image') as tblobfield).savetostream(m_JpegStream); image1.Picture.Graphic:=nil; image1.Picture.Graphic:=TJpegImage.Create; m_JpegStream.Position:=0; image1.Picture.Graphic.LoadFromStream(m_JpegStream); finally m_JpegStream.Free; end; end else image1.Picture.Graphic:=nil
LoadFromStream()
[email protected]
with query1 do
begin
close;
sql.Clear;
sql.Add('select p_image from t_park where p_no=:p_no');
parambyname('p_no').asstring:=pstring(tv.selected.Data)^;
open;
end; pr_query_detail(pstring(tv.selected.Data)^);
if (query1.RecordCount<>0) and (not(query1.FieldByName('p_image').IsNull)) then
begin
try
m_JpegStream:=TMemoryStream.Create;
(Query1.FieldByName('p_image') as tblobfield).savetostream(m_JpegStream);
image1.Picture.Graphic:=nil;
image1.Picture.Graphic:=TJpegImage.Create;
m_JpegStream.Position:=0;
image1.Picture.Graphic.LoadFromStream(m_JpegStream);
finally
m_JpegStream.Free;
end;
end
else image1.Picture.Graphic:=nil
任何文件不都是二进制文件?或者说都是文本文件!
...
ADOTable1.Edit;
...
TBlobField(ADOTable1.FieldByName('Text')).LoadFromFile('图片文件名');
...
ADOTable1.Post;
ADOTable1.Edit;
...
TBlobField(ADOTable1.FieldByName('Text')).LoadFromFile('图片文件名');
...
ADOTable1.Post;
取:
TBlobField(ADOTable1.FieldByName('Text')).SaveToFile('图片文件名');