How to retrive an image from sql server

Question

0.00/5 (No votes)

See more:

I want to display an image from SQL server to my web page.
Iam following Layered architecture, I got the image on my presentation layer(ASPX.Cs)
like {byte[6317]}

How to convert it into an image on my webpage

Posted 26-Sep-14 1:18am

MAGuru

Add a Solution

Comments

ZurdoDev 26-Sep-14 7:32am

There are lots of samples online. Where are you stuck?

MAGuru 26-Sep-14 8:02am

please give me a link

ZurdoDev 26-Sep-14 8:14am

google.com

Serious. Just do a little bit of work on your own first. You'll learn more that way.

[no name] 26-Sep-14 7:34am

use image hander file for this

3 solutions

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)

felix pascal · Answer 1 · 2014-09-30T08:39:00

Solution 3

Thanks a lot for your answers. I appreciate you all. But my problem is the picture is in an asp image control.

i am not using the file uploader. i am saving the image in an image control to database.

That is my problem.

Thanks.

Posted 30-Sep-14 8:39am

felix pascal

JR009 · Answer 2 · 2014-09-26T01:49:00

Hi,

Check the follow link to display image without using generic handler :

http://www.aspsnippets.com/Articles/Display-image-from-database-in-Image-control-without-using-Generic-Handler-in-ASPNet.aspx[^]

Or you can achieve this by using generic handler :

Generic Image Handler Using IHttpHandler[^]

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Answer 3 · 2014-09-26T01:45:00

Solution 1

Refer -
Display Byte Array as Image without using Generic Handler in ASP.Net[^].

Very simple...

C#

Byte[] bytes = br.ReadBytes((Int32)fs.Length);
string base64String = Convert.ToBase64String(bytes, 0, bytes.Length);
Image1.ImageUrl = "data:image/png;base64," + base64String;

Posted 26-Sep-14 1:45am

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)