ASP.NET Discussion - Need To Store Image In DataBase

Print Page | Close Window

Need To Store Image In DataBase

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: ASP.NET Discussion
Forum Description: Discussion and chat on ASP.NET related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=29043
Printed Date: 28 March 2026 at 8:42am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Need To Store Image In DataBase

Posted By: yahia
Subject: Need To Store Image In DataBase
Date Posted: 01 January 2011 at 4:40pm

hi every one,
need to store image in data base using visual web and sql server 2005
thx alot

Replies:

Posted By: TheGnomeAtHome
Date Posted: 16 February 2011 at 8:32am

SQL server now has an image object built in which will allow you to save it in binary using a memorystream.

Posted By: WebWiz-Bruce
Date Posted: 16 February 2011 at 9:40am

It is always a bad idea to store images in a database for both database size and performance issues.

The standard way to do this type of thing is store the images on disk and then just store the file location in the browser.

If you are worried about security then you can always place the images in a non public folder and then stream the images to the end user using ADO Streaming, again just storing the file location in the actual database.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: IanSmithISA
Date Posted: 21 February 2011 at 1:34pm

Good afternoon

Whilst appreciating that the original post was just spam, some people may be interested in FILESTREAMS within SQL Server 2008

http://msdn.microsoft.com/en-us/library/cc949109%28v=sql.100%29.aspx" rel="nofollow - http://msdn.microsoft.com/en-us/library/cc949109(v=sql.100).aspx

They move the data out of database file(s) into the OS's filing system whilst appearing to keep them in the database.

However they are an optional component of SQL Servere 2008 that may not be available.

Bye

Ian

-------------
Why does anyone need more than an 80x25 character only VDU?

Posted By: jonathan cole
Date Posted: 04 April 2011 at 11:22am

whats the problem you can do it with SQL Server.

http://www.logicspice.com - E commerce Web Design