How to get the data and image from SQL in ASP.NET using C#?

Question

I have created a table in SQL and stored some fields image. When I want to retrieve the data and image, it's not working. I have stored the image by converting it into byte array. Will you please help me on how to retrieve the data and image into ASP webpage?

http://mitch-wheat.blogspot.com/2007/05/save-and-restore-filesimages-to-sql.html — Mitch Wheat, Oct 20 '11 at 05:08

score 1 · Answer 1 · edited May 23 '17 at 11:55

1

Steps:

Read the byte array from blob (image) field and create a MemoryStream
Save that byte array or Write it to Response buffer.

You may create a Handler to serve these images.

edited May 23 '17 at 11:55

Community

1
1

answered Oct 20 '11 at 05:12

KV Prajapati

93,659
19
148
186

1

There is no reason to decode the bytes into an image just so save it again. Just serve the bytes. – Guffa Oct 20 '11 at 05:28
@Guffa - Appreciate! Thanks for the suggestion. – KV Prajapati Oct 20 '11 at 05:33

How to get the data and image from SQL in ASP.NET using C#?

1 Answers1