private System.Drawing.Image obtenerImagen(int iImageID )
{
SqlConnection cn=new SqlConnection("server=ServidorBD;database=BaseDeDatos;Uid=Usuario ;pwd= Password");
string strCmdText = "GetImageBinary";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = strCmdText;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = cn;
SqlParameter sqlparamItemID = new SqlParameter("@ItemId",SqlDbType.Int);
sqlparamItemID.Value = iImageID;
cmd.Parameters.Add(sqlparamItemID);
MemoryStream ms = new MemoryStream();
cn.Open();
byte [] img = (byte [])cmd.ExecuteScalar();
cn.Close();
if (img == null )
{
MessageBox.Show ("Imagen no encontrada en la base de datos");
}
ms.Write(img, 0 ,img.GetUpperBound(0) + 1);
System.Drawing.Image imgImagen=System.Drawing.Image.FromStream(ms);
ms.Close();
return imgImagen;
}