private void button1_Click(object sender, EventArgs e){ string path = this.textBox1.Text; byte[] imgBytesIn = SaveImage(path); ShowImgByByte(imgBytesIn); //Parameters.Add("@Photo", SqlDbType.Binary).Value = imgBytesIn;}//將圖片以二進制流public byte[] SaveImage(String path){ FileStream fs = new FileStream(path, FileMode.Open, FileAccess.Read); //將圖片以文件流的形式進行保存 BinaryReader br = new BinaryReader(fs); byte[] imgBytesIn = br.ReadBytes((int)fs.Length); //將流讀入到字節數組中 return imgBytesIn;}//現實二進制流代表的圖片public void ShowImgByByte(byte[] imgBytesIn){ MemoryStream ms = new MemoryStream(imgBytesIn); pictureBox1.Image = Image.FromStream(ms);}

#region 將圖片從數據庫中讀取/// <summary>/// 將圖片從數據庫中讀取/// </summary>/// <param name="xs_ID">要讀取圖片的學號</param>/// <param name="ph">pictureBox1控件名</param>public void get_photo(string xs_ID, PictureBox ph)//將圖片從數據庫中讀取{ byte[] imagebytes = null; getcon(); SqlCommand con = new SqlCommand("select * from S_jiben where S_num='" + xs_ID + "'", link); SqlDataReader dr = con.ExecuteReader(); while (dr.Read()) {  imagebytes =(byte[])dr.GetValue(18); } dr.Close(); con_close(); MemoryStream ms = new MemoryStream(imagebytes); Bitmap bmpt = new Bitmap(ms); ph.Image = bmpt;}#endregion#regionpublic void SaveImage(string MID, OpenFileDialog openF)//將圖片以二進制存入數據庫中{ string strimg = openF.FileName.ToString(); //記錄圖片的所在路徑 FileStream fs = new FileStream(strimg, FileMode.Open, FileAccess.Read); //將圖片以文件流的形式進行保存 BinaryReader br = new BinaryReader(fs); byte[] imgBytesIn = br.ReadBytes((int)fs.Length); //將流讀入到字節數組中 getcon(); StringBuilder strSql = new StringBuilder(); strSql.Append("update S_jiben Set xs_photo=@Photo where S_num=" + MID); SqlCommand cmd = new SqlCommand(strSql.ToString(), link); cmd.Parameters.Add("@Photo", SqlDbType.Binary).Value = imgBytesIn; cmd.ExecuteNonQuery(); con_close();}#endregion