ado.net

[minwen9704135]

(WINFORM)如何从数据库里读取图象(IMAGE)并加载到图象框里?请高手指教

[namhyuk]

大概的...

select IMAGE from TABLE where ID=***;

byte[] byt = null;
SqlDataReader reader = cmd.ExecuteReader();
while(reader.Read())
{
byt[] = (byte[])reader(0);
}

System.IO.MemoryStream ms = new System.IO.MemoryStream(byt);

Bitmap bt = new Bitmap(ms);

pictureBox1.BackgroundImage = bt;

也就是把读出来的图像记录字段先转成byte[],再传进MemoryStream对象的构造函数,再把MemroyStream对象引用作为Bitmap构造函数参数这样子。

[marvelstack]

转为byte类型后存入Image字段。
byte[] imagebytes=null;
FileStream fs=new FileStream(Image_path,FileMode.Open);
BinaryReader br=new BinaryReader(fs);
imagebytes=br.ReadBytes(br.Length);
SqlParameter parInput22=cmd.Parameters.Add("@员工图片",SqlDbType.Image);
parInput22.Direction=ParameterDirection.Input;
cmd.Parameters["@员工图片"].Value=imagebytes;
cmd.ExecuteNonQuery();


数据库中操作图片
How To Read and Write BLOB Data by Using ADO.NET with Visual C# .NET
http://support.microsoft.com/default.aspx?scid=kb;EN-US;309158


DataGrid显示图片(物理路径式和Stream流式)和添加图片到数据库
http://singlepine.cnblogs.com/articles/288027.html

[huangguangdou]

save