How to retrieve an image from varbinary code?

Question

My database is SQL Server. In that one photo data column is there. That is varbinary datatype. How to retrieve the original image from that code. Please suggest any better way

Regards, Pradeep

This question must have been answered hundreds of times on the web already. It is duplicate. — usr
– usr, Commented Feb 7, 2013 at 13:25

Chris Gessler · Accepted Answer · 2013-02-07 13:23:21Z

1

VarBinary is binary - so cast the field in the resultset to byte[]

byte[] bytes = (byte[])dataReader["fieldname"];

Then use a MemoryStream to convert the bytes to Image

public Image BytesToImage(byte[] bytes)
{
     using(MemoryStream ms = new MemoryStream(bytes))
     {
         Image image = Image.FromStream(ms);
         return image;
     }
}

answered Feb 7, 2013 at 13:23

Chris Gessler

23.2k8 gold badges59 silver badges86 bronze badges

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

Collectives™ on Stack Overflow

How to retrieve an image from varbinary code?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related