store image in database

Question

how can i store image to MS access database using odbc

Answer 1

Hi, I assume your field in the db is of type byte[] (OleObject or Blob). Then

- save the image to a MemoryStream.

- use the [YourMemoryStreamVariable].ToArray() Method of the MemoryStream to get the byte[].

- write the byte[] to the db-field.

regards,

  Thorsten

Answer 2

Have a look on these links

http://programming.top54u.com/post/Store-and-Display-Images-from-MS-Access-Database-Using-C-Sharp.aspx

http://www.dreamincode.net/forums/topic/56022-store-bmp-image-in-access-using-c%23/

---

Regards Thurupathan My blog : http://thuruinhttp.wordpress.com

Answer 3

Have a look on these links

http://programming.top54u.com/post/Store-and-Display-Images-from-MS-Access-Database-Using-C-Sharp.aspx

http://www.dreamincode.net/forums/topic/56022-store-bmp-image-in-access-using-c%23/

---

Regards Thurupathan My blog : http://thuruinhttp.wordpress.com

how to display byte image to pictureBox and richtextbox, what datatype i need to convert so that both (pictureBox and richtextbox) can be display image. 

Answer 4

Hi,

This article describes on how to create a bye array to image and an image to bye array.

http://www.codeproject.com/KB/recipes/ImageConverter.aspx

In this article byteArrayToImage() returns an Image object.

Once you get the Image object you can directly display it in a pictureBox using the following code

pictureBox1.Image = your image object;

And inserting images in the RichtextBox is little tricky and lengthy. But have a look on this article. You'll get it.

http://www.codeproject.com/KB/edit/MyExtRichTextBox.aspx

---

My blog : http://thuruinhttp.wordpress.com