How can i retrieve the image stored in binary format from database

Question

I am storing the image in a database and using c# as the front end.

I am storing the image by converting into binary format.

How can I retrieve the image stored in binary format from database?

possible duplicate of MVC How to display a byte array image from model — dav_i
– dav_i, Commented Jun 9, 2014 at 11:48

Ramunas · Accepted Answer · 2014-06-09 12:08:22Z

1

Maybe this will help:

OdbcConnection con = new OdbcConnection(ConnectString);
con.Open();
OdbcCommand checkcommand = new OdbcCommand("SELECT contents FROM MyTable WHERE MyClause",  con);
OdbcDataReader checkreader = checkcommand.ExecuteReader();
byte[] array = null;
if (checkreader.Read())
    array = (byte[])checkreader.GetValue(0);
else
{
   //Error
   return false;
}

File.WriteAllBytes("C:\\MyImage.jpeg", array);

answered Jun 9, 2014 at 12:08

Ramunas

1,1951 gold badge13 silver badges20 bronze badges

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

Collectives™ on Stack Overflow

How can i retrieve the image stored in binary format from database

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