Uploading image to MDF

[Foolygoofy26]

I'm trying to make a form or perhaps simply use Web Developer 2005 or SQL Server 2005 management to populate a database with pictures. So simply I want upload images to an sql database, if I make a form I would like to use asp.net.

Option 1
If I make the form using asp.net, i have no idea what to use to put them in that db. I have use db before with access to put text in the db, that's it.

Option 2
In Web Developer and SQL server I can run a query to pass the data into the db, but I don't know how to write sql besides the basic select, update, delete and insert into with basics one word string.

Can anybody give me a clue, link or code to do this...thanks

[rdove]

I recommend you never store images in a SQL Server database, or any databse for that matter. I think you will find it to be more trouble than it is worth.

My recommendation would be to store the path to the image as a string in the database and use simple uploading to store the image on the server so you can access it later.

Uploading files:
http://www.aspheute.com/english/20000802.asp

But if you must head down this road, this should assist you (he will try to convince you otherwise as well, but he still does show you how to do it):
http://www.sqlteam.com/item.asp?ItemID=986