http://forums.asp.net/t/298832.aspx/1?How+do+I+store+an+image+to+sql2000+Wed, 06 Aug 2003 02:41:30 -0400298832298832http://forums.asp.net/p/298832/298832.aspx/1?How+do+I+store+an+image+to+sql2000+ I want to store some images in the database. I've set the data type as image. Now comes to the storage of images into the database. How do I do that? 2003-08-04T02:20:56-04:00298941http://forums.asp.net/p/298832/298941.aspx/1?Re+How+do+I+store+an+image+to+sql2000+ well, you can use the postedFile functionality included in ASP.NET ( http://rtfm.atrax.co.uk/infinitemonkeys/articles/asp.net/995.asp ) but instead of saving to the filesystem, you'd assign the binary content of the image to an image-type field in SQL2000 however, it's not always the best way to go - it's less efficient than just using the filesystem in the majority of cases. Usually I recommend you store the images as files and just insert the PATH to the image into the DB, though there are circumstances where it's acceptable to do this. What's your actual requirement (I mean, why do you want to put them into SQL Server?) j 2003-08-04T07:06:23-04:00299052http://forums.asp.net/p/298832/299052.aspx/1?Re+How+do+I+store+an+image+to+sql2000+ Actually they are small icons, and we don't want people to mess around with them or try to copy and use them somewhere else. I cannot think of any other way safeguard them... unless you guys can suggest? :) 2003-08-04T11:09:43-04:00300945http://forums.asp.net/p/298832/300945.aspx/1?Re+How+do+I+store+an+image+to+sql2000+ Storing them in the database will not stop people from hiting 'save image as' in their browser. no way. there's nothing, and I mean nothing, you can do about that. You can stop people leeching from your site with solutions like this one : http://rtfm.atrax.co.uk/infinitemonkeys/articles/asp/935.asp but you can't stop someone saving the content they've already downloaded to their computer in order to view. it's how the web works.... j 2003-08-06T01:00:20-04:00