Question Best method to store image in SQL

[tqmd1]

Dear Experts

I have loaded a picture in PICTUREBOX1 by this command

Me.PictureBox1.Image = Drawing.Image.FromFile("D:\C2007\BITMAPS\pict.jpg")

How to store this picture SQL server 2005 table1's IMAGE column?

I do not want to store image path in table.
I want to store picture in image column in any format.

Reason: If I run my project to some other computer that has not images'path stored in database.
Then images will be displayed by image field of database.


Table1 has following two columns
student_no int
student_pict image


Please help

 

[alander]

Hi..

Have a read at this article

Store and Retrieve Images in SQL Server database Articles, samples and tutorials