How to Display Picture From Database to Picture Box Control

Here I've given a very simple code snippet with you can display image from database.


private void DisplayPictureFromDB()
{

SqlConnection cnMyPro = new SqlConnection();

 

string qryMyPro = "SELECT Description FROM ProductInfo";

if (cnMyPro.State != ConnectionState.Open)

cnMyPro.Open();

SqlCommand cmdMyPro = new SqlCommand(qryMyPro, cnMyPro);

SqlDataReader sdrMyPro =cmdMyPro.ExecuteReader();

sdrMyPro.Read();

if (sdrMyPro.HasRows)

{

byte[] MyImage = (byte[])(sdrMyPro[2]);

if (MyImage == null)

picDescription.Image = null;

else

{

MemoryStream msMyPro = new MemoryStream(MyImage);

picDescription.Image =Image.FromStream(msMyPro);

 

}

}

}