retrieve back image from sql server database and display in MVC3

Question

i stored few images in database in binary format, now i want to display those images in my view,how can we convert those images from binary format to image format again?

this is my action menthod in my controller

           public ActionResult DislpayAllImage()
           {
            DataSet dsa = new DataSet();
            dsa = objImage.getAllImages();
            DataTable dt = new DataTable();
            dt = dsa.Tables[0];
            if (dt != null)
            {
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                Byte[] image = (Byte[])dt.Rows[i]["UsImage"];
                return File(image, "image/jpg");
             }
            }
        return View();



    }

this is my code in model

     public DataSet getUserImage(int Id)
     {
        DataSet ds = new DataSet();
        try
        {
            DbCommand db = dbcon.GetStoredProcCommand("GetImage");
            dbcon.AddInParameter(db, "@Id", DbType.Int16, Id);
            db.CommandType = CommandType.StoredProcedure;
            return ds = dbconstr.ExecuteDataSet(dbCmd);
        }
        catch(Exception ex)
        {
            return ds = null;
        }
    }

view

 @foreach( var image in ViewData.Images )
 {
  <img src="@Url.Action("DislpayImage", "Home",new { id = image.ImageID })" />
 }

how can i display my image in razor view,also is the above code fine?

Karthik Chintala · Accepted Answer · 2013-01-23 06:42:30Z

2

You need to call your Controller's Action(DislpayImage()) from the View like this:

<img src="<%= Url.Action("DislpayImage", "Controller") %>" alt="myimage" />

or

<img src="@Url.Action("DislpayImage", "Controller")" alt="myimage" />

Hope it helps you.

Edit

Just pass the id of the image you want to display to Controller action

public ActionResult DislpayImage(int id)
     {
        DataSet dsa = new DataSet();

        dsa = objImage.getUserImage(id);
        var imagedata = dsa.Tables[0].Columns["MyImage"];
        return File(imagedata, "image/jpg");

     }

Now pass the id of image which you want to display in your view, like this:

<img src="@Url.Action("DislpayImage", "Controller", new { id="2" })" alt="myimage" />

Now you will get the image with id as 2.

edited Jan 23, 2013 at 6:42

answered Jan 23, 2013 at 5:02

Karthik Chintala

5,5455 gold badges33 silver badges61 bronze badges

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

12 Comments

Karthik Chintala Over a year ago

If there is no image then myimage text will be displayed, your can remove that

colors bright Over a year ago

I'm getting error in this line return File(imagedata, "image/jpg"); as'the best overload method ....has some invalid arguments,

Karthik Chintala Over a year ago

try this byte[] imagedata instead of var imagedata

colors bright Over a year ago

here im getting the error as cannot implicitly convert system.data.datacolumn to byte[]

Karthik Chintala Over a year ago

so, try like this byte[] imagedata=(byte[])dsa.Tables[0].Columns["MyImage"];

|

Ariston Alcantara · Accepted Answer · 2013-01-23 04:29:45Z

<% foreach( var image in ViewData.Images ) { %> 
  <%= Html.Image( Url.Action( "Show", "Image", new { id = image.ImageID } ) ) %> 
<% } %>



 public class ImageController : Controller

    {

        public void Show(string id)

        {

           Image image = GetImage(id);


           Response.Buffer = True;
           Response.Clear();
           Response.ContentType = "image/gif";
           Response.BinaryWrite( image.Data );
           Response.End();

       }

    }

This response is just a copy of an answer from another forum. This is not my own. I'm pasting it here to help you and someone else in this forum with the same issue.

Here is the main link: http://forums.asp.net/post/2264885.aspx

Collectives™ on Stack Overflow

retrieve back image from sql server database and display in MVC3

2 Answers 2

12 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

12 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related