Inserting pictures in SQL database

Do NOT store pictures to SQL server!!!

This will KILL the database and it's performances.
A better solution is to store the pictures in a folder and keep the pointer to the pictures in the database. This will also allow you to query the database for the pictures.

I know this is not an answer, but it's a friendly advice.

i agree what yronnen said. but i have try to use the VB to develop the program to store and retrived it from the SQL server.

but i don't know are you using the VB to do that or not.

mail me Clivenyong@hotmail.com
i will post the source code here

Cliven , I'm sure you have read the membership agreement,so for your information...in my university students are asked to do this as homework assignment in ....VB

fbyk, if it is homework assignment, try to do it on your own, with maybe some help of Experts when you are stuck on some problem, I'm sure you want to learn how to do it, not just blindly copy some code

good luck

To me storing the pictures outside of SQL server and only a reference to the path in a table is the best solution.
I'm using an intranet application (ASP pages and MS SQL 7 server). Users can select pictures from any location, these are then uploaded to a folder on a server and only the path is stored in the sql table.
I'm using AspUpload from Persists Software (www.persists.com) to store the picture in the central folder.

see see http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=39566&lngWId=1 

Gula, This is not my home work pliz! I'm working on a project that requires the record of employee's pictures kept.

Otherwise, thanx for your comments.

have you checked the link I gave to you?