How to save the image into the database in Delphi7?

Sam80,
  TImage does not support JPEG files.
  Use TJpegImage for image1.
  i.e.

Var
  MyImg : TJpegImage;
Begin
...
  MyImg := TJpegImage.Cleate;
  MyImg.LoadFromFile('MyImg.jpg');
  MyImg.SaveToStream(MS);
 
...


*-*-*-*-*

Also, remember to add jpeg in uses .


HTH,
...Shu

I think it's better:

var
  F:TFileStream;
begin
  F:=TFileStream.create('YourFileNameHere',fmOpenRead);
  //...
  TBolbfield(table1.fieldbyname('image')).loadfromstream(F);
  //...
  F.free;

Thank you for your suggestion.

I wanna load both jpeg and bitmap file , further more , load the file in the openpicturedialg supported format(emf,wmf), not just a single format and neednt  specify different way to load the different format file . I will try the TFileStream later.    

Thank you all .

Regards,
Sam

Hi,

Just add jpeg to your uses clause and keep using TImage. This works fine here.

Regards, Geo

I have use Tbitmap to load the picture in the TImage. And then use table.fieldbyna,e('image').assign(bmp) to save the img to the database.

but I now doubt there will be a mess data in the database for all the image format is bitmap.

================

To Geo,
  In delphi7 , I dont have to add the jpeg unit and use Tjpegimage as well.  but if i add that unit, delphi report that there has no such unit.

To delphized,
  I have try your method , but it's so strange that I read the jpeg file into a memorystream type object and save it into the field like the way you show to me , but in that step , the exception message "bitmap is not valid " still comes out,in contrast , if i save a bitmap memorystream, it works !! . I doubt it's the database's problem . in my sql, I define the field "image" as image type, length is 16. why it can verify my memorystream is bitmap or not??

To all ,
    The another problem I meet  is the Tgraphic problem. I cannot use Tgraphic.loadfromfile because of the error "abstract error" . I have tried to do :   gra:Tgraphic;
gra:=Tgraphic.create;
gra:=Timage.picture.Graphic; // not gra.assign(..)
in this way, the gra has the picture's width and height same as that in Timage  !

Regards,
Sam

I told you TFileStream... and I didn't know you were usin a Image field (Ithought a blob field).

You can't use the TGraphic method because TGraphic is a abstract class that is derived in different subclasses for every king of image (bitmab,jpeg, ...).

After having known this last information, you could make this way;

var
  bmp:TBitmap;
begin
  bmp:=TBitmap.create;
  bmp.height:=Image1.picture.height;
  bmp.width:=Image1.picture.width;
  bmp.canvas.draw(0,0,Image1.picture);
 
and then assign the bmp object to your field

  bmp.free;
end;