Sql - Reading images from DB

Asked Apr 09 '12 at 23:38

Active Apr 09 '12 at 23:38

Viewed 82 times

I keep getting the error image icon when reading images from my DB.

Here is the HttpHandler code:

public void ProcessRequest(HttpContext context) {
    ....
    //After we got the data table:
    byte[] image = (byte[])dt.Rows[0]["Picture"];
    context.Response.ContentType = dt.Rows[0]["PictureType"].ToString();
    context.Response.BinaryWrite(image);
}

I do check and see that image is not null (Just a really big array, as it should be), and PictureType does save the type of the picture that was previously saved in the db. But I still see the error image icon when calling the handler:

<img src='myhandler.ashx?imgid=someid'/>

Any reason for this to happen?

asked Apr 09 '12 at 23:38

Jong

9,045
3
34
66

what's in the PictureType column? – Mitch Wheat Apr 09 '12 at 23:41
Storing images in databases = bad. Is it at all possible to store them in a public folder and only store the URLs in the database? – Waleed Khan Apr 10 '12 at 00:00
@MitchWheat, When the image is uploaded I keep the `ContentType` property from the file upload control of asp.net. That's kept in `PictureType`. – Jong Apr 10 '12 at 00:50
@arxanas I guess that is an option, too. But the way my website works now, it will just make things more complicated than they should be. I rather solve that problem. – Jong Apr 10 '12 at 00:51
Is your table set with the proper encoding? – Waleed Khan Apr 10 '12 at 04:47
What is the proper encoding, and how do I check it anyway? – Jong Apr 10 '12 at 06:19

Sql - Reading images from DB

0 Answers0