display varbinary image in asp.net with c#

Question

so i have this method:

    string sql = string.Format("EXECUTE getPlayerImage @playerID = '{0}'", bio.playerID);


    SqlCommand cm = baseballConnection.CreateCommand();

    baseballConnection.Open();
    cm.CommandText = sql;
    baseballConnection.Close();
    return cm.ExecuteScalar() as byte[];

and it works, at least i get no errors. but now all i have is a byte array, how can i display this on the screen? i have an image tool on the screen but the only way i know how to display an image is if its saved on the server and has a file path. i wouldnt know how to save the byte array to the server, but that would be cheesing it and there would be no point to my already saving the image in the db as a varbinary and now retrieving it.

how can i get this byte array to display?

I'd rather have the server transmit the file from the hard drive than have it fire up the bloated asp.net lifecycle, hit the database, pass the data through memory, then transmit the file. — Malk
– Malk, Commented Jun 5, 2013 at 18:33
i understand. i just wanted to see if i could do this. ive come so far, it is easier, i know, but nonetheless, id like to see this succeed — dwarf
– dwarf, Commented Jun 5, 2013 at 18:35

JAKEtheJAB · Accepted Answer · 2013-06-05 19:08:28Z

To render the image in asp.net, you have to create an asp.net page or generic handler to save the bytes in the output response stream.

You would then set the an HTML image or control to link to the page or generic handler.

For instance,

<img src="getimage.aspx?id=1" style="width:100px; height:100px" alt="" />

So in your case it would be something like this:

using System.Web;

namespace ImageUtil
{
    public class ImageProvider : IHttpHandler
    {
        publicvoid ProcessRequest(HttpContext context)
        {
            context.Response.ContentType = "image/jpeg";

            string sql = string.Format("EXECUTE getPlayerImage @playerID = '{0}'", bio.playerID);

            SqlCommand cm = baseballConnection.CreateCommand();
            baseballConnection.Open();
            cm.CommandText = sql;
            byte[] img = (byte[])cm.ExecuteScalar();
            baseballConnection.Close();

            context.Response.BinaryWrite(img);
        }

        publicbool IsReusable
        {
            get
            {
                returnfalse;
            }
        }
    }
}

Here is a link: http://samiradel.wordpress.com/2011/08/03/how-to-display-image-byte-array-in-a-an-img-tag/

Bill Gregg · Accepted Answer · 2013-06-05 18:30:56Z

0

Have you tried Response.BinaryWrite?

http://msdn.microsoft.com/en-us/library/ms524318%28v=VS.90%29.aspx

answered Jun 5, 2013 at 18:30

Bill Gregg

7,1472 gold badges24 silver badges40 bronze badges

Collectives™ on Stack Overflow

display varbinary image in asp.net with c#

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related