How can I display an image from SQL Server using ASP.NET?

Question

Here is my class (product.cs) where is the method to insert the image:

public static void InsertProductIMG(byte[] image, string contentType) 
{
   string cs = "Data Source=(local);Initial Catalog=myApp;Integrated Security=True";
   string comandoSql = "INSERT INTO [myApp].[dbo].[product] (image, ContentType) VALUES (@image, @contentType)";

   using (SqlConnection conn = new SqlConnection(cs))
   {
       conn.Open();

       using (SqlTransaction trans = conn.BeginTransaction())
       {
           SqlCommand cmd = new SqlCommand(comandoSql, conn, trans);
           SqlParameter[] parms = new SqlParameter[2];
           parms[0] = new SqlParameter("@image", image);
           parms[1] = new SqlParameter("@contentType", contentType);
           foreach (SqlParameter p in parms)
           {
              cmd.Parameters.Add(p);
           }

           cmd.ExecuteNonQuery();
           trans.Commit();
       }
    }
}

Here is the code behind of the apsx page where I call the method above:

byte[] imageBytes = new byte[fupld.PostedFile.InputStream.Length];
product.InsertProductIMG(imageBytes, "image/jpeg");//product is the class where the method is

Now I'd like to know how can I display this image?

Would I have to read the byte[] from sql (SELECT), convert to string and so convert to byte[]? And after do that convert to bitmap (System.Drawing). But how I show this bitmap in a aspx page?

I've no idea how to do it. Please help!! :]

Thanks

Obs.: In SQL Server, the column image is of type varbinary(MAX).

I am curious why do you throw(ex)? instead of just throw;.. why do you have try/catch at all for that matter? if you don't commit the tran will rollback automatically and the unhandled exception would bubble up — JDPeckham
– JDPeckham, Commented Jul 1, 2012 at 20:42

Sascha · Accepted Answer · 2012-07-01 20:41:51Z

5

Create a web page that returns the image. You would select the bytes from the database (as you have already code written to insert, I think you know how to select). Once you have the bytes, you need to set the mime type and write the bytes to the response stream.

var bytesFromDatabase = getImageFromDatabase();
context.Response.ContentType = "image/jpeg";
context.Response.BinaryWrite(bytesFromDatabase);

Edit:

Just use a img tag with the cource tet to the aforementioned aspx web page. Eg:

<img src="http://www.example.com/image.aspx?id=1" alt="image" />

edited Jul 1, 2012 at 20:41

answered Jul 1, 2012 at 17:45

Sascha

10.4k4 gold badges44 silver badges68 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

João Paulo Over a year ago

but i need to show in a specific place. In this way can i put anywhere i want?

Dinesh · Accepted Answer · 2012-07-01 17:49:30Z

4

You need to use a handler to do this

Read this, a very nice example

http://www.dotnetcurry.com/ShowArticle.aspx?ID=129

answered Jul 1, 2012 at 17:49

Dinesh

3,8002 gold badges30 silver badges35 bronze badges

1 Comment

Rodney Ellis Over a year ago

7 years on ... and this is still really useful... thank you!

Collectives™ on Stack Overflow

How can I display an image from SQL Server using ASP.NET?

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related