日期:2014-05-18 浏览次数:21044 次
SqlConnection conn = new SqlConnection("server=.;database=dbImate;uid=sa;pwd=;");
conn.Open();
SqlCommand cmd = new SqlCommand("select * from [image]", conn);
SqlDataReader dr = cmd.ExecuteReader();
dr.Read();
MemoryStream ms = new MemoryStream((Byte[])dr["pic"]);
Bitmap image = new Bitmap(ms);
image.Save(Server.MapPath("~/1.jpg"));
this.Image1.ImageUrl = "1.jpg";
dr.Close();
conn.Close();
------解决方案--------------------
byte[] b = (byte[])cmd.ExecuteScalar();
if (b.Length > 0)
{
MemoryStream stream = new MemoryStream(b, true);
stream.Position = 0;//加上这句看看
pictureBox1.Image = new Bitmap(stream);
stream.Close();
}