How do store pictures in Sql Database?

Question

In Vb I want show employee details(id,name,doj,deprt, and his picture).
In crystal report i want to show his picture in employee details reports.
Please any body knows please tell me how i can programe

Answer 1

It depends how large the pictures are, but you could make a BLOB (64KB) or MEDIUMBLOB (4MB) field in your employee details table. (A BLOB is much like a binary varchar with a preset maximum length.) Then using mysql_real_query you can enter and extract the binary data from the table.



mysql_real_query is the same as mysql_query, but you must give it a query length, since it cannot rely on a NULL character to terminate the query string.

Answer 2

As the others said, don't store the pictures in the DB. Store them somewhere on the server. Important is to have a dummy picture if there exist no picture for something, for example a gray picture with a question mark. This picture will be shown if no picture exists.



Here is the VB-Source code to get them from the server:



Me.imgMyImage.Stretch = True

Me.imgMyImage.Visible = True

Me.imgMyImage.Picture = LoadPicture(App.Path & "\MyImages\" & Trim(rsMyDatabase!PictureFilename) & ".jpg")



That was it. Very simple.

Answer 3

In a Sql Database or all database for that mater you ca only tore alphanumeric strings.No pictures,no music.In order to get the desired effect you need to configure the java script used fore the query.

Answer 4

You can store and access image from SQL Server its possible.



While creating a table you can set a column type as image.



Please see the fallowing examples.

Answer 5

Keep the picture on a server somewhere and store the UNC path (or a URL, depending on your app) to it in your database.



e.g.

\\server1\employees\pics\terrytester.jpg

http://server1/employees/pics/terrytester.jpg

Answer 6

you can write image in binary formad to text field in db