用Web或WINFROM把数据库中的图片读出来（图片类型是image）

 //WEB部分

string str =ConfigurationSettings.AppSettings["connString"].ToString();
SqlConnection con = new SqlConnection(str);
string sql= "select personimage,personImagetype from person where personEmail='"+Session["email"]+"'";
SqlCommand cmd= new SqlCommand(sql,con);
con.Open();
SqlDataReader dr=cmd.ExecuteReader();
Byte[] PictureData =null;   
while(dr.Read())
{   
PictureData =(Byte[])dr[0];
Response.ContentType=dr[1].ToString();
}      
this.EnableViewState=false;
Response.AppendHeader("contect-length",PictureData.Length.ToString());
Response.BinaryWrite(PictureData);
Response.End();

//上部分的代码写了一个show.asp页面里，

//在调用的页面里加载一个image控件就可以了，

//调用代码为：this.Image1.ImageUrl="show.aspx";

//WINFROM部分

string strCon="data source=aaaa;initial catalog=school;uid=sa;pwd=";
   SqlConnection con = new SqlConnection(strCon);
   con.Open();
   string sql="select personimage from person where personID="+this.textBox1.Text+"";
   SqlCommand cmd=new SqlCommand(sql,con);
   SqlDataReader dr=cmd.ExecuteReader();
   if(dr.HasRows)
   {
    dr.Read();
    byte[] img=(byte[])dr["personimage"];
    MemoryStream ms=new MemoryStream();
    ms.Write(img,0,img.Length);
    this.pictureBox1.Image=Image.FromStream(ms);
    ms.Close();
   }
   dr.Close();