用数据字段用 image 也可以,
直接用数据感知控间DBimage进行数据存储
直接用数据感知控间DBimage进行数据存储
解决方案 »
- 求delphi网页自动登陆代码..
- 我坚持上了
- 数据库显示问题
- 我用dspack控件来显示两块视频卡的内容,运行两三小时后弹出窗口windows device出错。
- 往Excel表里写类似:“1-15”的内容,怎样阻止自动变成日期型?
- 软考通过。散分!!
- 强烈支持WGYKING(修罗是谁?!)做语言基础版斑竹
- 请问如何获得dos下的消息,我执行一个dos计算程序后,如何获得它的输出结果了?
- 谁有ActiveForm的例子(源码),或者告诉哪个网站有?
- 那个叫做stretchdraw的东东到底有什么用?怎么用?多谢大虾指点!!最好有例子哦!
- 程序自身复制的问题?
- 难道真的没人知道吗???难道真的没人知道吗???难道真的没人知道吗???难道真的没人知道吗???难道真的没人知道吗???
thanks advanced
TMemStream TempStream;
TempStream := TMemStream.Create;
{Here put picture data int TempStream }
TBlobField(X).LoadFromStream(TempStream);
TempStream.Free;
TBlobField(table.FieldByName('reportitem')).LoadFromFile('c:\.bmp');
TBlobField(table.FieldByName('reportitem')).LoadFromFile('c:\.bmp');
如果你的图片是bitmap还可以这样用:
TBlobField(X).Assign(TPicture(Y));
我现很穷,你可要。
procedure Tfrm_writecar.saveImageintoDB(car_id: string); //保存图片
var
buf2,buf:pchar;
f1:file;
filelen:integer;
begin
try
buf2:=pchar(car_id);;
assignfile(f1,vps_name);
reset(f1,1);
filelen:=filesize(f1);
buf:=allocmem(filelen);
blockread(f1,buf^,filelen);
closefile(f1);
with query2 do
begin
close;
sql.clear;
sql.add('update t_manager_car set ima_car=:ima_car where car_no=:car_no');
end;
try
query2.ParamByName('car_no').DataType:=ftString;
query2.ParamByName('car_no').SetData(buf2);
query2.ParamByName('ima_car').SetBlobData(buf,filelen);
query2.ExecSQL;
except
statusbar1.Panels[1].text:='图片保存出错!';
exit;
end;
//buf2:=nil;
freemem(buf);
except
statusbar1.Panels[1].text:='图片保存出错!';
exit;
end;
end;procedure Tfrm_writecar.GetImagefromDB(car_id: string); //取出图片
var
m_jpegstream:tmemorystream;
begin
with query2 do
begin
close;
sql.clear;
sql.Add('select ima_car from t_manager_car where car_no='''+car_id+'''');
try
Open;
except
exit;
end;
end;
if (query2.FieldByName('ima_car') as tblobfield).asstring='' then
begin
exit;
end
else
//(query2.FieldByName('ima_car') as tblobfield).savetofile(car_id+'.jpg');
begin
try
try
m_jpegStream:=TMemoryStream.Create;
(query2.fieldbyname('ima_car') as TBlobField).SaveToStream(m_JpegStream);
image1.Picture.Graphic:=nil;
image1.Picture.Graphic:=TJpegImage.Create;
m_JpegStream.Position:=0;
image1.Picture.Graphic.LoadFromStream(m_JpegStream);
except
end;
finally
m_JpegStream.Free;
query2.Close;
query2.UnPrepare;
end;
end;
end;