How to retrieve image from database to picturebox in C#

First retrieve image from database using Query

 

 

public MemoryStream memorystream; 

 

public byte[] View_Sign(string filename)

{

string QueryViewSign = "Select image from " + SqlDatabaseName + ".." + mTableNameSignMaster + " where filename='" + filename + "' order by edate desc";

con = new SqlConnection(constr);

con.Open();

SqlCommand cmd = new SqlCommand(QueryViewSign, con);

SqlDataReader dr = cmd.ExecuteReader();

dr.Read();

if (dr.HasRows)

{

Signature = ((byte[])dr[0]);

}

if (Signature != null)

{

memorystream = new MemoryStream(Signature);

}

return Signature;

}

 

then after retrieve file from database 

 

Follow this link 

 

https://www.aspsnippets.com/Articles/Save-and-Retrieve-BLOB-Images-from-MySql-Database-in-ASPNet-C-and-VBNet.aspx

 

You can convert the BLOB to Normal Displaying Image 

Sir im new with the C# language im using BLOB data type  this is the result when i successfully saved the image from picturebox