Retrieve and display image in ASP.NET

Question

0.00/5 (No votes)

See more:

Hi all,

I want to retrieve image from Sql DB in ASP.NET web page and display it.
I already did the Sql proc that retrieve the image but I don't know how to display it in asp.net.
This is the code I write:

public List<Image> select_Image(string Product_Name)
    {
        //Connection.Close();
        Connection.Open();
        SqlCommand select_Product_Image = new SqlCommand("select_Product_Image", Connection);
        select_Product_Image.CommandType = CommandType.StoredProcedure;
        select_Product_Image.Parameters.Add("@Product_Name", SqlDbType.NVarChar);
        select_Product_Image.Parameters["@Product_Name"].Value = Product_Name;
        select_Product_Image.ExecuteNonQuery();
        Connection.Close();
        DataTable dt1 = new DataTable();
        SqlDataAdapter ad = new SqlDataAdapter(select_Product_Image);
        ad.Fill(dt1);
        //for (int i = 0; i < 3; i++)
        {
            MemoryStream ms = new MemoryStream((byte[])dt1.Rows[0][0]);
            Image T ;
            Response.ContentType = "image/gif";
            Response.BinaryWrite(ms);
            //T.Save(ms, System.Drawing.Imaging.ImageFormat.Bmp);
            //Images.Add(T);
            //Temp_id.Add((int)(dt1.Rows[i][1]));
        }
        return Images;
    }

Is it right and what I can do to diplay image?

[edit]
Code block added to improve formatting.
Converted form all lower case to proper capitalisation. (All lower case is considered "childish", just as all upper case is considered "shouting".
Punctuation added.
Spelling improved and vowels added where required.
Some minor grammar.
OriginalGriff
[/edit]

Posted 23-Dec-10 21:18pm

eman88

Updated 23-Dec-10 22:05pm

OriginalGriff

v2

Add a Solution

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)

raju melveetilpurayil · Answer 1 · 2010-12-24T14:57:00

Solution 3

If you need to know more check this, it help you
Image Handling In ASP.NET[^]

Posted 24-Dec-10 14:57pm

raju melveetilpurayil

preethy angela · Answer 2 · 2011-01-10T05:35:00

protected void display_Click(object sender, EventArgs e)
{

string img_id = "1"; //Request.QueryString["img_pk"];

SqlConnection con = new SqlConnection(@"Data Source=...\SQLEXPRESS;Initial Catalog=....;Integrated Security=True");
SqlCommand cmd = new SqlCommand("select img_contenttype,img_data from image where img_pk=" + img_id, con);
con.Open();
SqlDataReader dr;
dr = cmd.ExecuteReader();
while (dr.Read())
{
Response.ContentType = dr[0].ToString();
//Response.BinaryWrite((byte[])dr[1]);
string strURL =" ~/Default.aspx?img_pk=1";
//Image imgload = new Image();
Image1.ImageUrl = strURL;
}
con.Close();

}

for me its not displaying image in image control ..check it pls..

TejuKrishna · Answer 3 · 2010-12-23T22:03:00

can you explain what you want to do? I mean you want to show image on page or in image control. I want to show image in control then you have to go for HttpHandler Class.
Try following Code
Add HttpHandler Class
write this code

C#

<%@ WebHandler Language="C#" Class="Handler" %>

using System;
using System.Web;
using System.Data.SqlClient;
using System.Data;
using System.IO;
using System.Configuration;

public class Handler : IHttpHandler
{
    
    public void ProcessRequest(HttpContext context)
    {
        string _productname;
        if (context.Request.QueryString["_productname"] != null)
           _productname=(context.Request.QueryString["_productname"]).ToString();
        else
            throw new ArgumentException("No parameter specified");

        context.Response.ContentType = "image/gif";
        Stream strm = ShowEmpImage(_productname);
        byte[] buffer = new byte[2525];
        int byteSeq = strm.Read(buffer, 0, 2525);

        while (byteSeq > 0)
        {
            context.Response.OutputStream.Write(buffer, 0, byteSeq);
            byteSeq = strm.Read(buffer, 0, 2525);
        }
        //context.Response.BinaryWrite(buffer);
    }

    public Stream ShowEmpImage(string _productname)
    {
        string conn = ConfigurationManager.ConnectionStrings["sqlcn"].ConnectionString;
        SqlConnection connection = new SqlConnection(conn);
        string sql = "Ur Sp";
        SqlCommand cmd = new SqlCommand(sql, connection);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.AddWithValue("@Product_Name", _productname);
        connection.Open();
        object img = cmd.ExecuteScalar();
        try
        {
            return new MemoryStream((byte[])img);
        }
        catch
        {
            return null;
        }
        finally
        {
            connection.Close();
        }
    }
    

    public bool IsReusable
    {
        get
        {
            return false;
        }
    }


}

write following code in aspx.cs file

C#

Image imgload = new Image();
                imgload.ImageUrl = "~/Handler.ashx?_productname=" + _productname;

if any clarification need feel free to ask

Retrieve and display image in ASP.NET

3 solutions

Solution 3

Solution 4

Solution 1

Add your solution here

Preview 0