procedure TForm1.Button1Click(Sender: TObject);
var
sm:TStream ;
jpeg:TJPEGImage ;
begin
// if ADODataSet1photo.IsNull then exit;
sm:=ADODataSet1.CreateBlobStream(adodataset1.FieldByName('photo'),bmRead);
jpeg:=TJPEGImage.Create ;
jpeg.LoadFromStream(sm);
image1.Picture.Assign(jpeg);
jpeg.Free ;
end;
procedure TForm1.SpeedButton1Click(Sender: TObject);
var
fs:TFileStream ;
begin
if ADODataSet1photo.IsNull then showmessage('nil');
ADODataSet1.Edit ;
fs:=TFileStream.Create('c:\xxx.jpg',fmOpenRead);
ADODataSet1photo.LoadFromStream(fs);
ADODataSet1.Post ;
fs.Free ;
end;
procedure TForm1.Button2Click(Sender: TObject);
var
ms:TMemoryStream ;
begin
ms:=TMemoryStream.Create ;
OleContainer1.CreateObjectFromFile( 'c:\xxx.doc',false);
OleContainer1.SaveToStream(ms);
ADODataSet1.Edit ;
ADODataSet1photo.LoadFromStream(ms);
ADODataSet1.Post ;
ms.Free ;
end;
procedure TForm1.Button3Click(Sender: TObject);
var
sm:TStream ;
begin
sm:=ADODataSet1.CreateBlobStream(adodataset1.FieldByName('photo'),bmRead);
OleContainer1.LoadFromStream(sm);
sm.Free ;
end;
procedure TForm1.Button4Click(Sender: TObject);
var
ms:TMemoryStream ;
begin
ms:=TMemoryStream.Create ;
OleContainer1.SaveToStream(ms);
ADODataSet1.Edit ;
ADODataSet1photo.LoadFromStream(ms);
ADODataSet1.Post ;
ms.Free ;