How to put source code of image from sql server.

Question

3.40/5 (3 votes)

See more:

I have a database in which I am storing path of the image as varchar. Now in my page I want to put the path of the image in Image source.

Posted 23-Sep-13 1:54am

Rohit 2247

Add a Solution

Comments

[no name] 23-Sep-13 7:56am

Okay so go right ahead and do that. You have my permission to proceed.

Eduard Keilholz 23-Sep-13 8:35am

Are you voting all questions down? Makes no sense... This question is easy to understand. It would have been nice if the poster added a piece of code of what he tried already, but I see no reason to vote this question down.

[no name] 23-Sep-13 8:44am

What makes you think for even a single instant that I am voting all question down? What "question" is it that you are referring to? There is no question here. You should verify your facts before jumping to conclusions.

Eduard Keilholz 23-Sep-13 8:51am

I didn't bring anything as a fact. As you can see my first sentence starts with a question. Furthermore I've seen a couple of questions with only off topic comment. Telling posters they're stupid doesn't help them. Telling them how to improve they're questions does!

Kirill NoNick 23-Sep-13 9:33am

troll? :P

[no name] 28-Sep-13 14:16pm

What the heck are you talking about? At no time have I ever told a user they were stupid. If you can see questions where none exist then by all means feel free to have a guess at an answer. By no stretch of the imagination can this posting be called a question.

1 solution

Add a Solution

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)

Eduard Keilholz · Accepted Answer · 2013-09-23T02:34:00

Answer to this question can be pretty complicated, because it depends on where your images repository sits. If the images are within the scope of your website it's wise to store a relative path to the image in your database as well and just render that relative path in a tag

HTML

<img src="/Relative/DbPath.jpg" />

If your images are outside the scope of your website, you need to make sure that the folder the images are in, is readable to IIS. You can then open the image as a binary file and pass is through. This also depends on the type of ASP website you have, if you're using MVC it's even more easy, else you may want to add an ashx file to your project hand handle the image processing from there.

Your images will look like