SQL server 中存储图片

privatevoidButton1_Click(objectsender,System.EventArgse)


{


if(this.File1.Value!=null){


//获取文件的完整路径


stringpath=this.File1.PostedFile.FileName;


//获取文件名


stringfilename=System.IO.Path.GetFileName(path);


Response.Write(path);


Response.Write(filename);


//获取文件的长度


filelength=File1.PostedFile.ContentLength;　


Byte[]length=newByte[filelength];


Response.Write(filelength);


Streaminstream=File1.PostedFile.InputStream;


instream.Read(length,0,filelength);


SqlConnectionconn=newSqlConnection("server=9422B27F00C346F;uid=sa;pwd=sa;database=Addpic");


stringaddpic="insertintopicvalues(@picture)";


SqlCommandcom=newSqlCommand(addpic,conn);


com.Parameters.Add(newSqlParameter("@picture",SqlDbType.Binary,filelength));


com.Parameters["@picture"].Value=length;


conn.Open();


com.ExecuteNonQuery();


Response.Write("chenggong");


Response.OutputStream.Write(length,0,filelength);


//Response.ContentType="image/jpg";


conn.Close();


}


}





privatevoidButton2_Click(objectsender,System.EventArgse)


{


SqlConnectionconn=newSqlConnection("server=;uid=sa;pwd=sa;database=Addpic");


stringduqu="select*frompic";


SqlCommandcom=newSqlCommand(duqu,conn);


conn.Open();


SqlDataReaderdr=com.ExecuteReader();


if(dr.Read()){


byte[]duqutupian=newbyte[0];


duqutupian=(byte[])dr["picName"];


//Response.End();


MemoryStreamstr=newMemoryStream(duqutupian);


System.Drawing.Imageimg=System.Drawing.Image.FromStream(str);


img.Save(Response.OutputStream,System.Drawing.Imaging.ImageFormat.Jpeg);


}


//pictureBox1.Image=Image.FromStream(stmBLOBData);


conn.Close();


}