Retrieving a image from database to asp.net page using c#

Question

I am new to this functionality, our company projects are containing similar functionality but the store the image path with in the server and they retreive according to that. But I want to store the image as image type in database and I want show as it is in the Asp.net page(imagebox).

Thanks in Advance

score 0 · Answer 1 · edited May 23 '17 at 12:29

0

You need to serialize the image to a binary format that can be stored in a SQL BLOB column please check this or check that as well.

edited May 23 '17 at 12:29

Community

1
1

answered Jun 30 '14 at 06:17

Rahul

5,603
6
34
57

score 0 · Accepted Answer · answered Jun 30 '14 at 06:30

And if you want to show it to pass it client you can create specific method that will return an image and use this url in src for imagebox:

public ActionResult GetAvatar(int id) {
    using (var dbContainer = new MainDBContainer()) {
        return File(dbContainer.UserSet.First(p => p.Id == id).Image.Image,"image/png");
    }
}

Or you can use Base64 encoding.

Retrieving a image from database to asp.net page using c#

2 Answers2