0
SqlConnection conn = new SqlConnection();
            DataSet ds = new DataSet();
            SqlDataAdapter da = new SqlDataAdapter();
            byte[] arrContent ;
            DataRow dr;
            string strSql;
            strSql = "Select Image from productItems where productid = 18";
            da = new SqlDataAdapter(strSql, connectionString);
            da.Fill(ds);
            dr = ds.Tables[0].Rows[0];
            arrContent = (byte[])dr["Image"];
            Response.OutputStream.Write(arrContent,0,6306);
            Response.End();

I am unable to write the bytes data on my page which is actually an image. what I see is a series of special characters. what am i doing wrong?

sly_Chandan
  • 3,437
  • 12
  • 54
  • 83

5 Answers5

3

I suspect you're trying to write the image straight into the HTML, where it doesn't belong. Your page should have an img element which refers back to your server using a URL which will let you fetch the ID when that request comes in... and that's when you serve the actual image data, along with an appropriate content type.

Of course I may be off-base here... you haven't provided us any context (like what else is being served by this request...).

Other points:

  • You should use a using statement on your SqlConnection so it gets closed whatever happens
  • I see no point in using a DataSet or SqlDataAdapter. Why not just call ExecuteReader and then use GetBytes to fetch the data?
  • You're always writing 6306 bytes to the response regardless of how much data there really is. Why?
Jon Skeet
  • 1,421,763
  • 867
  • 9,128
  • 9,194
1

You need to convert the byte array into a valid image and then display that image in web page.

C#: How to convert BITMAP byte array to JPEG format?

Community
  • 1
  • 1
A G
  • 21,087
  • 11
  • 87
  • 112
  • there is no fromstream function in web applications. what u are talking about is in windows apps – sly_Chandan Dec 10 '10 at 07:43
  • The function is part of the .NET framework. It does not matter what type of application you are developing. – A G Dec 10 '10 at 07:47
1

According to MSDN, "if no ContentType is specified, the default is text/HTML.". That means that when you are sending the image bytes, the browser considers it as an ordinary webpage, and tries to display it as it would display HTML content.

To avoid this behavior, you must explicitly set the content type to one of the MIME types specifying an image.

For example, for PNG images, you can use:

this.Response.ContentType = "image/png";

before sending actual content.

Arseni Mourzenko
  • 50,338
  • 35
  • 112
  • 199
1

You need to covert what you have to string and render.

Response.ContentType = dRow["Image"].ToString();
byte[] imageContent = (byte[])((dRow["img_stream"]));

Response.BinaryWrite(imageContent);
Jinesh Parekh
  • 2,131
  • 14
  • 18
0

Another way you can take is to use inline images (though not all browsers support it yet). Simple example:

<img src="data:image/gif;base64,R0lGODlhEAAOALMAAOazToeHh0tLS/7LZv/0jvb29t/f3//Ub/ /ge8WSLf/rhf/3kdbW1mxsbP//mf///yH5BAAAAAAALAAAAAAQAA4AAARe8L1Ekyky67QZ1hLnjM5UUde0ECwLJoExKcpp V0aCcGCmTIHEIUEqjgaORCMxIC6e0CcguWw6aFjsVMkkIr7g77ZKPJjPZqIyd7sJAgVGoEGv2xsBxqNgYPj/gAwXEQA7" width="16" height="14" alt="embedded folder icon">

This will even optimize your site loading. You can read more about inline images here

anthares
  • 11,070
  • 4
  • 41
  • 61
  • If the image is genuinely 6K, that's going to be a pretty big chunk when base64 encoded. Given that pages are generally more dynamic (and thus less cacheable) than images, I think it's a stretch to claim "this will even optimize your site loading" - if the whole page *has* to be served, and you're including 6K + base64 encoding overhead on each request, I suspect it will hurt more than harm. It's good for small images, but I doubt that it's appropriate here. – Jon Skeet Dec 10 '10 at 07:46