学步园

public void imgToDB(string sql)<br /> { //参数sql中要求保存的imge变量名称为@images<br /> //调用方法如：imgToDB("update UserPhoto set Photo=@images where UserNo='" + temp + "'");<br /> FileStream fs = File.OpenRead(t_photo.Text);<br /> byte[] imageb = new byte[fs.Length];<br /> fs.Read(imageb, 0, imageb.Length);<br /> fs.Close();<br /> SqlCommand com3 = new SqlCommand (sql,con);<br /> com3.Parameters.Add("@images", SqlDbType.Image).Value = imageb;<br /> if (com3.Connection.State == ConnectionState.Closed)<br /> com3.Connection.Open();<br /> try<br /> {<br /> com3.ExecuteNonQuery();<br /> }<br /> catch<br /> { }<br /> finally<br /> { com3.Connection.Close(); }<br /> }<br />
数据库中读出图片并显示在picturebox中：

方法一：
private void ShowImage(string sql)<br /> {<br /> //调用方法如：ShowImage("select Photo from UserPhoto where UserNo='" + userno +"'");<br /> SqlCommand cmd = new SqlCommand(sql, conn);<br /> conn.Open();<br /> byte[] b= (byte[])cmd.ExecuteScalar();<br /> if (b.Length 〉 0)<br /> {<br /> MemoryStream stream = new MemoryStream(b, true);<br /> stream.Write(b, 0, b.Length);<br /> pictureBox1.Image = new Bitmap(stream);<br /> stream.Close();<br /> }<br /> conn.Close();<br /> }

方法二：当在dg中选中某行时：
  private void dg_MouseUp(object sender, MouseEventArgs e)<br /> {<br /> //整行选择<br /> if (e.Button == System.Windows.Forms.MouseButtons.Left)<br /> {//用户编号，姓名，性别，身份证号，籍贯，学院，系所，校区，部门，电话，照片<br /> //显示相片<br /> object imgobj=dg[10, dg.CurrentRow.Index].Value;<br /> if (imgobj != null && !Convert.IsDBNull(imgobj))<br /> {<br /> byte[] imgb = (byte[])imgobj;<br /> MemoryStream memStream = new MemoryStream(imgb);<br /> try<br /> {<br /> Bitmap myimge = new Bitmap(memStream);<br /> this.pictureBox1.Image = myimge;<br /> }<br /> catch<br /> {<br /> DB.msgbox("从数据库读取相片失败！");<br /> }<br /> }<br /> else<br /> pictureBox1.Image = null;<br /> }<br /> }