为了显示数据库图片,一般需要读出并存储为文件显示。
代码如下:
代码如下:
protected
void
btnReadin_Click(
object
sender, EventArgs e)
{
AbsDB conn = DBConn.GetDBConn();
String strSql = "select * from DB_Images where 编号=1";
OracleDataReader reader = conn.ExecuteReader(CommandType.Text,strSql,null);
if (reader.Read())
{
byte[] mBlob = (byte[])reader["图像"];
System.IO.MemoryStream ms = new System.IO.MemoryStream(mBlob);
System.Drawing.Image img = System.Drawing.Image.FromStream(ms);
img.Save(Request.PhysicalApplicationPath + "Images/100.jpg", System.Drawing.Imaging.ImageFormat.Jpeg);
}
}
{
AbsDB conn = DBConn.GetDBConn();
String strSql = "select * from DB_Images where 编号=1";
OracleDataReader reader = conn.ExecuteReader(CommandType.Text,strSql,null);
if (reader.Read())
{
byte[] mBlob = (byte[])reader["图像"];
System.IO.MemoryStream ms = new System.IO.MemoryStream(mBlob);
System.Drawing.Image img = System.Drawing.Image.FromStream(ms);
img.Save(Request.PhysicalApplicationPath + "Images/100.jpg", System.Drawing.Imaging.ImageFormat.Jpeg);
}
}