gridview显示图片的实例代码

protected void Button1_Click(object sender, EventArgs e)

{

   //图片路径

   string strPath = "~/photo/03.JPG";

   string strPhotoPath = Server.MapPath(strPath);

   //读取图片

   FileStream fs = new System.IO.FileStream(strPhotoPath, FileMode.Open, FileAccess.Read);

   BinaryReader br = new BinaryReader(fs);

   byte[] photo = br.ReadBytes((int)fs.Length);

   br.Close();

   fs.Close();

   //存入

   SqlConnection myCOnn= new SqlConnection("Data Source=127.0.0.1;Initial Catalog=TestDB;User ID=sa;Password=sa");

   string strComm = " INSERT INTO personPhoto(personName, personPhotoPath, personPhoto) ";

   strComm += " VALUES('wangwu', '" + strPath + "', @photoBinary )";

   SqlCommand myComm = new SqlCommand(strComm, myConn);

   myComm.Parameters.Add("@photoBinary", SqlDbType.Binary,photo.Length);

   myComm.Parameters["@photoBinary"].Value = http://www.cnblogs.com/wycoo/archive/2012/02/07/photo;

   myConn.Open();

   myComm.ExecuteNonQuery();

   myConn.Close();

}

SqlConnection myCOnn= new SqlConnection("Data Source=127.0.0.1;Initial Catalog=TestDB;User ID=sa;Password=sa");

string strComm = " SELECT personPhoto FROM personPhoto WHERE persOnName='wangwu' ";

SqlCommand myComm = new SqlCommand(strComm, myConn);

myConn.Open();

SqlDataReader dr = myComm.ExecuteReader();

while (dr.Read())

{

   byte[] photo = (byte[])dr["personPhoto"];

   this.Response.BinaryWrite(photo);

}

dr.Close();

myConn.Close();

SqlDataAdapter myda = new SqlDataAdapter(" SELECT personPhoto FROM personPhoto WHERE persOnName='wangwu' ", myConn);

DataSet myds = new DataSet();

myConn.Open();

myda.Fill(myds);

myConn.Close();

byte[] photo = (byte[])myds.Tables[0].Rows[0]["personPhoto"];

this.Response.BinaryWrite(photo);

SqlDataAdapter myda = new SqlDataAdapter(" SELECT personPhoto FROM personPhoto WHERE persOnName='wangwu' ", myConn);

DataSet myds = new DataSet();

myConn.Open();

myda.Fill(myds);

myConn.Close();

byte[] photo = (byte[])myds.Tables[0].Rows[0]["personPhoto"];

//图片路径

string strPath = "~/photo/wangwu.JPG";

string strPhotoPath = Server.MapPath(strPath);

//保存图片文件

BinaryWriter bw = new BinaryWriter(File.Open(strPhotoPath,FileMode.OpenOrCreate));

bw.Write(photo);

bw.Close();

//4.GridView中ImageField以URL方式显示图片

----------------------------

   HeaderText="图片">