Retrieve and display image from database using ASP.Net MVC

Question

I want to retrieve an image from database and then send it to view and display it as thumbnail. Here is my code but It has some error and I can't return the image properly. I'm using ASP.Net MVC and aspx pages.

Controller :

public ActionResult showImg(int id)
{
   var imageData = from m in db.Products
                   where m.ShopId == 3
                   select Image.FromStream(new MemoryStream(m.Product_img.ToArray()));

   return new FileStreamResult(new System.IO.MemoryStream(imageData), "image/jpeg");
}

View :

<img src='<%= Url.Action("showImg", "image", new { id = ViewData["imageID"] } ) %>' />

Have you ruled out any database issue, just trying to return a hardcoded filename instead of a memory stream? — Nick
– Nick, Commented Nov 2, 2012 at 10:10
No it is just a test. I won't use hardcode in real situation. — Doctor
– Doctor, Commented Nov 2, 2012 at 10:13
I know you will not want to hardcode it - but are you sure that it is not a database connection issue? And is your query returning exactly what you want? — Nick
– Nick, Commented Nov 2, 2012 at 10:16
Yes my friend, I have already inserted an image to the table successfully, but now I want to retrieve it. The imageData filled with System.Drawing.Image but FileStreamResult wants to return (byte[],string). Thats it. — Doctor
– Doctor, Commented Nov 2, 2012 at 10:26

Nick · Accepted Answer · 2012-11-02 13:13:36Z

5

It looks like you do not need to recreate the Image object in your linq statement, just return the stream and pass it your FileStreamResult:

var image = (from m in db.Products
             where m.ShopId == 3
             select m.Product_img).FirstOrDefault();

var stream = new MemoryStream(image.ToArray());

return new FileStreamResult(stream, "image/jpeg");

edited Nov 2, 2012 at 13:13

answered Nov 2, 2012 at 10:30

Nick

6,6485 gold badges48 silver badges64 bronze badges

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

3 Comments

Doctor Over a year ago

Cannot convert System.Linq.IQueryable<System.IO.MemoryStrem> to System.IO.Stream

Doctor Over a year ago

Only parameterless constructors and initializers are supported in LINQ to Entities.

Nick Over a year ago

Have updated the answer again, now performing MemoryStream construction outside of the linq statement.

Doctor · Accepted Answer · 2012-11-02 13:22:24Z

0

Thanks a lot Nick. Your code is now correct. I wrote it in this way :

    var stream = (from m in db.Products where m.ShopId == 3 select m.Product_img).FirstOrDefault();

            return File(stream, "image/jpeg");

answered Nov 2, 2012 at 13:22

Doctor

1681 gold badge3 silver badges14 bronze badges

Collectives™ on Stack Overflow

Retrieve and display image from database using ASP.Net MVC

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related