private void GetPicture()
{
if (DrugCode != "" && DrugCode != null)
{
if (!Convert.IsDBNull(db.GetPIVAsDBforObject("select DrugPicture from DDrug where DrugCode='" + DrugCode + "'")))
{
byte[] b = (byte[])db.GetPIVAsDBforObject("select DrugPicture from DDrug where DrugCode='" + DrugCode + "'");
MemoryStream stream = new MemoryStream(b, true);
stream.Write(b, 0, b.Length);
pictureBox1.Image = new Bitmap(stream);
stream.Close();
}
else
{
pictureBox1.Image = global::PivasDDrug.Properties.Resources.NoPicture;
}
}
}