How do I display multiple images of multiple users stored in SQL Server 2012 in my ASP.NET website without data URI

Question

4.00/5 (1 vote)

See more:

, +

I am trying to develop my website in ASP.NET which takes in pictures from user's, stores them in SQL Server 2012 and displays them when they visit Photos page, and only working approach I found online was to read byte[] stream of data from SQL Server and converting it to Base64 and then displaying via DataURI specification. Since some websites can show multiple images that are cached and don't need to be re-downloaded, so I wanted to know how do I implement caching of images on client side, some approach that doesn't use data uri and still works? Any suggestion/idea would be appreaciated.

Posted 16-Sep-14 0:29am

Akshay Raut

Updated 16-Sep-14 0:30am

v2

Add a Solution

Comments

Thomas Nielsen - getCore 17-Sep-14 3:06am

First of all, if you have the time, consider storing something else than the image in the database?
Images are big things and you may discover that when space begin to run low on your database server, that the tables taking up space is pictures.
Were you to store the location on your fileserver or webserver of the images you will see that the browsers are anyway caching the images and the access time will naturally get faster.
Generally it is not recommended architecture to store binaries in RDBMS

Akshay Raut 18-Sep-14 2:22am

@Thomas Thank you, could I trouble you for one more thing? Can you provide me with aspx.cs code for FileUpload control that saves images with unique names and how do I determine if these images are large or small, that's another problem I am unable to solve because large images are filling up the screen. It will be enough if you can just explain the logic. Thanks again for that idea. I'm gonna try that for sure.

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)