C#读取 image类型

[fhuibo]

怎么实现从SQLSERVER 2000中的 image类型 读出图片并保存到计算机为 .jpeg或.jpg 或.bmp的形式

[mmens]

楼上抢先了。呵呵。。。

[fhuibo]

Eddie005(♂) №.零零伍 (♂)
的System.Drawing.Image img = System.Drawing.Image.FromStream(str);
报错，
System.ArgumentException: 使用了无效参数，
请问兄弟应怎样转化参数

[yistudio]

参考一下http://yistudio.cnblogs.com

[kaixin110]

msdn.com

[Knight94]

Some changed based on Eddie005(♂) №.零零伍 (♂)

System.IO.MemoryStream str = new System.IO.MemoryStream(bytes, true);
str.Read( bytes, 0, bytes.Length );
System.Drawing.Image img = System.Drawing.Image.FromStream(str);

[cjnet]

參考這兩個函數：
//ImageToByte(Image img)
public static byte[] ImageToByte(Image img)
{
byte[] byt = null;
ImageConverter imgCvt = new ImageConverter();
object obj = imgCvt.ConvertTo(img, typeof(byte[]));
byt = (byte[])obj;
return byt;
}

//ByteToImage(byte[] byt),先用DataReader在數據庫中讀取byte[]
public static Image ByteToImage(byte[] bytImage)
{
Image img = null;
if (bytImage.Length == 0)
{
return img;
}
else
{
ImageConverter imgCvt = new ImageConverter();

object obj = imgCvt.ConvertFrom(bytImage);
img = (Image)obj;
return img;
}
}

[Eddie005]

System.Data.SqlClient.SqlConnection cnn = new System.Data.SqlClient.SqlConnection(".....");
System.Data.SqlClient.SqlCommand cm = new System.Data.SqlClient.SqlCommand("Select theImage from table1 where id=1",cnn);
System.Data.SqlClient.SqlDataReader dr = cm.ExecuteReader();
if(dr.Read())
{
byte[] bytes = (byte[])dr[0];
System.IO.MemoryStream str = new System.IO.MemoryStream(bytes);
System.Drawing.Image img = System.Drawing.Image.FromStream(str);
img.Save("test.jpg");
}
cnn.Close();

[SolidGL]

see see

[marvelstack]

数据库中操作图片
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