Problem inserting image into table!

[Branislav Vidovic]

Hy guys, I have a question about images in SQL databses. When I am in database table viewer in Microsoft Visual Web Developer 2005 Express Edition and I am entering data into the table, how do I insert image into the image-type field? What are the pre-conditions for inserting a picture (which is on my hard drive) to image-type field in database? Thank you for your time. Cheers

[Christian Graus]

I am not sure if that's what the image type is for, because your DB will have no idea if the byte array you pass it is a bitmap. Have you googled for info ? I would suggest the best bet is to store the image in the file system, and store paths in your DB, but there's no reason you can't store the image data in your DB.

Christian Graus - Microsoft MVP - C++ "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

[Not Active]

A C# Windows application to store and retrieve photos from a SQL Server database. http://www.codeproject.com/KB/database/albumviewer.aspx[^]

---

only two letters away from being an asset

[Mitesh Darji]

Convert image in to binary data and store into the database. and whenever you want to access the image from the database, read binary data from the database and create .bmp file :)

mitesh

[Branislav Vidovic]

And what about the Gridview control. I know I can use it to display data from database very easy. And if the table in the database contains images will the gridview control display it automaticly as it does for the other fields?