What’s the best way to display an image from a sql server database in asp.net?

by

Two options:

Create a temp file – The problem with this approach is that you have to create the file, which means your web must have write access to a directory which is not a great thing. You also need to have a way to clean up the images.

Serve it from another URL – This is my preferred method, as you have no disk access required. A simple http handler (ashx) is a great method to serve up the image.

Edit

If you need session state in the ashx, check out: Asp.net System.Web.HttpContext.Current.Session null in global.asax.

Edit

Couple more thoughts. There are some cases where using a temp file might be better. For example if your images are requested frequently by a lot of users. Then storing the images on the disk would make sense, since you could write the file once, this does increase the maintance complexity but depending on traffic it might be worth it since this would let you avoid calling back into the .net stack and leverage IIS caching of static content.

More Related Contents:

  1. Can an ASP.NET MVC controller return an Image?
  2. what’s the issue with AttachDbFilename
  3. How can I force entity framework to insert identity columns?
  4. Out Of Memory exception on System.Drawing.Image.FromFile()
  5. bytearray to image asp.net
  6. Get Image dimensions using Javascript during file upload
  7. A network-related or instance-specific error occurred while establishing a connection to SQL Server [closed]
  8. Display image from database in ASP.net with C#
  9. Why does the 2nd T-SQL query run much faster than the first when called by Reporting Services 2005 in a web-app
  10. Preventing SQL Injection in ASP.Net
  11. ASP.NET Image uploading with Resizing
  12. How to bind a MemoryStream to asp:image control?
  13. Streaming Databased Images Using HttpHandler
  14. Images that are in App_Data folder not shown in browser
  15. Can’t find microsoft.sqlserver.batchparser.dll
  16. How to retrieve binary image from database using C# in ASP.NET
  17. call aspx page to return an image randomly slow
  18. Is there a recommended way to return an image using ASP.NET Web API
  19. Deploying website: 500 – Internal server error
  20. Fixing slow initial load for IIS
  21. Advantage of creating a generic repository vs. specific repository for each object?
  22. Why would one use a third-party DI Container over the built-in ASP.NET Core DI Container?
  23. Post-Redirect-Get with ASP.NET
  24. Is it a good practice to avoid using Session State in ASP.NET MVC? If yes, why and how?
  25. Why am I getting “Thread was being aborted” in ASP.NET?
  26. ASP.NET URL Rewriting
  27. Make MSDeploy (Visual Studio) not delete App_Data folder but delete everything else
  28. User ASP.NET runs under
  29. ASP.NET session state and multiple worker processes
  30. How to detect/track postback in javascript?

Leave a Comment