string strCon = "Data Source=.;Initial Catalog=northwind;User ID=sa;Password=esa";
string strSql = " select top 1 picture from Categories";
SqlDataAdapter da = new SqlDataAdapter(strSql, strCon);
DataTable dt = new DataTable();
da.Fill(dt);
byte[] img=(byte[])dt.Rows[0][0];
if (img.Length >0)
{ MemoryStream ms = new MemoryStream();
ms.Write(img, 0, img.Length);
Image m_SourceImage = Image.FromStream(ms);
pictureBox1.Image = m_SourceImage;
}
请大侠指正!
string strSql = " select top 1 picture from Categories";
SqlDataAdapter da = new SqlDataAdapter(strSql, strCon);
DataTable dt = new DataTable();
da.Fill(dt);
byte[] img=(byte[])dt.Rows[0][0];
if (img.Length >0)
{ MemoryStream ms = new MemoryStream();
ms.Write(img, 0, img.Length);
Image m_SourceImage = Image.FromStream(ms);
pictureBox1.Image = m_SourceImage;
}
请大侠指正!
this.pictureBox1.Image = image;
MemoryStream ms = new MemoryStream(img.length);
ms.Seek(0, SeekOrigin.Begin);
ms.Write(img,0,img.length);
Image _img = imc.ConvertFrom(null, null, o) as Image;
if (_img!=null)
{
pictureBox1.Image = _img
}
byteBLOBData = (Byte[])(dt.Rows[0][0]);
MemoryStream stmBLOBData = new MemoryStream(byteBLOBData);
pictureBox1.Image= Image.FromStream(stmBLOBData);