日期:2014-05-18 浏览次数:21047 次
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(); 
            }