image

[mylogics]

i want to save image in my sql database and also i want to show image from database. what shud i do and how plz guide.m new to win application....

[JHizzle]

If you are storing the image directly to the database, convert to a Binary large Object and save it to an SQL table field of type varbinary, then just reverse the process when you're pulling it back out.

[Ray Cassick]

Just be aware that can grossly inflate the size of your DB. I have typically used the 'store the image in the file system and then put the path to the image into the DB' method. It's slightly more to manage and backup, but i think you will see that DB performance is better.

---

LinkedIn[^] | Blog[^] | Twitter[^]

[carlecomm]

Please try this: http://www.shabdar.org/store-save-images-in-sql-server.html

[yu jian]

I know that there has the image type in the SQL SERVER, you can store the picture as the image type to the SQL SERVER

[JHizzle]

That's going to be removed in future versions of SQL server.