inserting a picture into a sql server database

[twright]

hello all. how can i allow a user to insert a picture into a sql server database from a form on a webpage? thanks for the help.

 

[tlbroadbent]

First an opinion - shared by many. "Do not store binary files, image files, or BLOBs inside a SQL database. Store the path to the binary/image file in the database and use the path as a pointer to the actual file. Storing, retrieving and manipulating large binary files is better performed outside the database. A database is not meant for storing files."

HOWTO: Display an Image on a Web Page When the Path Is Stored in a Database

http://support.microsoft.com/support/kb/articles/Q299/3/20.ASP

-----------------------------------

Now if you insist, here are some resources to help you store and retrieve image files.

http://www.stardeveloper.com/articles/033101-1.shtml

http://p2p.wrox.com/archive/pro_vb/2000-07/4.asp

http://www.4guysfromrolla.com/webtech/060100-1.shtml

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvbpj01/html/gs0102.asp

Terry Broadbent

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin