如何用delphi控制Access中的ole字段类型 由于技术需要,需要在Access中使用ole字段,请问哪为人兄知道如何在delphi中利用ado控制access的ole字段的输入和显示,高分酬谢! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 unit Unit1;interfaceuses Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms, Dialogs,jpeg, DB, ADODB, DBCtrls, Grids, DBGrids, StdCtrls, ExtCtrls;type TForm1 = class(TForm) Image1: TImage;{用来存放图片以备用} Image2: TImage;{用来显示从数据库中提取出来的图片} Button1: TButton; Button2: TButton; DBGrid1: TDBGrid; ADOQuery1: TADOQuery; DataSource2: TDataSource; procedure Button1Click(Sender: TObject); procedure Button2Click(Sender: TObject); private { Private declarations } public { Public declarations } end;var Form1: TForm1;implementation{$R *.dfm}procedure TForm1.Button1Click(Sender: TObject);var MyJPEG : TJPEGImage; MS: TMemoryStream;begin Image1.picture.loadfromfile('d:\work\pic.bmp'); MyJPEG:=TJPEGImage.Create; Try MyJPEG.Assign(Image1.Picture.Graphic); {图像转成JPEG格式,如为JPEG图片则不必加} MS:=TMemoryStream.Create; MyJPEG.SaveToStream(MS); MS.Position:=0; ADOQuery1.Append; ADOQuery1.FieldByName('name').Value:='1'; TBlobField(ADOQuery1.FieldByName('pic')).LoadFromStream(MS); ADOQuery1.Post; messagebox(getactivewindow(),'图像保存完毕!','保存',mb_ok); MS.Free; Finally MyJPEG.Free; end;end;procedure TForm1.Button2Click(Sender: TObject);var MyJPEG : TJPEGImage; MS: TMemoryStream;begin MS:=TMemoryStream.Create; MyJPEG:=TJPEGImage.Create; ADOQuery1.Requery; try TBlobField(ADOQuery1.FieldByName('pic')).SaveToStream(MS); MS.Position:=0; MyJPEG.LoadFromStream(MS); Image2.Picture.Bitmap.Assign(MyJPEG); finally MS.Free; MyJPEG.Free; end;end;end. 借光:怎么判断olecontainer里是不是有数据对象?即是否为空? 删除记录报错:bof,eof中有一个为真!哪位大哥快帮忙啊 DELPHI界面嵌入其他软件用什么控件? 有一个小问题:{0 delphi开发与组态软件开发的异同 为何又是这样错??? 录求bold for delphi6 注册码 谁有关于运行期动态创建水晶报表的例子给我一份吧. 新手请教~~~~~~~~~~~~望各位帮忙~ 如何替换网页中的JS函数 神呀,救救我吧---.doc文件乱码 如何更新adoquery中修改的数据? 关于程序员合订本的质量问题,欢迎进入 up有分!!!!
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs,jpeg, DB, ADODB, DBCtrls, Grids, DBGrids, StdCtrls,
ExtCtrls;type
TForm1 = class(TForm)
Image1: TImage;{用来存放图片以备用}
Image2: TImage;{用来显示从数据库中提取出来的图片}
Button1: TButton;
Button2: TButton;
DBGrid1: TDBGrid;
ADOQuery1: TADOQuery;
DataSource2: TDataSource;
procedure Button1Click(Sender: TObject);
procedure Button2Click(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
end;var
Form1: TForm1;implementation{$R *.dfm}procedure TForm1.Button1Click(Sender: TObject);
var
MyJPEG : TJPEGImage;
MS: TMemoryStream;
begin
Image1.picture.loadfromfile('d:\work\pic.bmp');
MyJPEG:=TJPEGImage.Create;
Try
MyJPEG.Assign(Image1.Picture.Graphic); {图像转成JPEG格式,如为JPEG图片则不必加}
MS:=TMemoryStream.Create;
MyJPEG.SaveToStream(MS);
MS.Position:=0;
ADOQuery1.Append;
ADOQuery1.FieldByName('name').Value:='1';
TBlobField(ADOQuery1.FieldByName('pic')).LoadFromStream(MS);
ADOQuery1.Post;
messagebox(getactivewindow(),'图像保存完毕!','保存',mb_ok);
MS.Free;
Finally
MyJPEG.Free;
end;
end;procedure TForm1.Button2Click(Sender: TObject);
var
MyJPEG : TJPEGImage;
MS: TMemoryStream;
begin
MS:=TMemoryStream.Create;
MyJPEG:=TJPEGImage.Create;
ADOQuery1.Requery;
try
TBlobField(ADOQuery1.FieldByName('pic')).SaveToStream(MS);
MS.Position:=0;
MyJPEG.LoadFromStream(MS);
Image2.Picture.Bitmap.Assign(MyJPEG);
finally
MS.Free;
MyJPEG.Free;
end;
end;
end.