Convert Varbinary To upload Image MVC asp.net

Question

Hy master I have some problem when I convert Image varbinary(MAX) I have a procedure like this

Create Procedure SelectBarang   
as     
Begin    
    Select * from Barang;    
End

and i have class model like this

public class ShopDB
{
    string cs = ConfigurationManager.ConnectionStrings["ShopEntities"].ConnectionString;

    public List<Barang> ListAll()
    {
        List<Barang> lst = new List<Barang>();
        SqlConnection con = new SqlConnection(cs);
        //using(SqlConnection con=new SqlConnection(cs))
        {
            con.Open();
            SqlCommand com = new SqlCommand("SelectBarang", con);
            com.CommandType = CommandType.StoredProcedure;
            SqlDataReader rdr = com.ExecuteReader();
            while (rdr.Read())
            {
                lst.Add(new Barang
                {
                    IdBarang = Convert.ToInt32(rdr["IdBarang"]),
                    NamaBarang = rdr["NamaBarang"].ToString(),
                    Harga = Convert.ToInt32(rdr["Harga"]),
                    CategoriId = Convert.ToInt32(rdr["CategoriId"]),
                    GambarBarang = Convert  ??                            
                });
            }
            return lst;
        }
    }
}

How I can change varbinary to image for Add my data?

Possible duplicate of Read Image from SQL Server VarBinary(Max) — NightOwl888
– NightOwl888, Commented May 30, 2017 at 3:36
Hi you can take as byte array and convert to image document.getElementById("ItemPreview").src = "data:image/png;base64," + YourByte; — Nayas Subramanian
– Nayas Subramanian, Commented May 30, 2017 at 4:00
@JujurSitanggang - You may not have intentionally copied the other question, and that is understandable. But the purpose of StackOverflow is to try to provide a canonical question and answer for a given question. It is your responsibility to make sure the question has not been previously asked and adequately answered on StackOverflow before asking it again. — NightOwl888
– NightOwl888, Commented May 30, 2017 at 4:43

Nayas Subramanian · Accepted Answer · 2017-05-30 04:17:56Z

1

Hi you can do something like

you can read data using:

 byte[] myImage = (byte[])reader["MyImageColumn"];

Then use this in mvc view

@{
 var base64 = Convert.ToBase64String(Model.ByteArray);
 var imgSrc = String.Format("data:image/gif;base64,{0}", base64);
}

edited May 30, 2017 at 4:17

answered May 30, 2017 at 4:08

Nayas Subramanian

2,38723 silver badges32 bronze badges

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

Collectives™ on Stack Overflow

Convert Varbinary To upload Image MVC asp.net

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related