图片保存到数据库和从数据库读取图片并显示
[[wiki]wiki[/wiki]][/wiki]public void imgToDB(string [wiki]SQL[/wiki]) { //参数sql中要求保存的imge变量名称为@images //调用方法如：imgToDB("update UserPhoto set
Photo=@images
where UserNo='" temp "'"); FileStream fs = File.OpenRead(t_photo.Text); byte[] imageb = new byte[fs.Length]; fs.Read(imageb, 0, imageb.Length); fs.Close(); SqlCommand com3 = new SqlCommand (sql,con); com3.Parameters.Add("@images", SqlDb[wiki]type[/wiki].Image).Val[wiki]UE[/wiki] = imageb; if (com3.Connection.State == ConnectionState.Closed) com3.Connection.Open(); try { com3.ExecuteNonQuery(); } catch { } finally { com3.Connection.Close(); } }
[wiki]数据库[/wiki]
中读出图片并显示在picturebox中：
方法一：private void ShowImage(string sql) { //调用方法如：ShowImage("select Photo from UserPhoto where UserNo='" userno "'"); SqlCommand cmd = new SqlCommand(sql, conn); conn.Open(); byte[] b= (byte[])cmd.ExecuteScalar(); if (b.Length 〉 0) { MemoryStream stream = new MemoryStream(b, true); stream.Write(b, 0, b.Length); pictureBox1.Image = new Bitmap(stream); stream.Close(); } conn.Close(); }
方法二：当在dg中选中某行时： private void dg_MouseUp([wiki]object[/wiki] sender, MouseEventArgs e) { //整行选择 if (e.Button == System.[wiki]windows[/wiki].Forms.MouseButtons.Left) {//用户编篬wiki]牛[/wiki]彰员穑矸葜ず牛幔г海邓Ｇ棵牛琜wiki]电话[/wiki]，照片 //显示相片 object imgobj=dg[10, dg.CurrentRow.Index].Value; if (imgobj != null && !Convert.IsDBNull(imgobj)) { byte[] imgb = (byte[])imgobj; MemoryStream memStream = new MemoryStream(imgb); try { Bitmap myimge = new Bitmap(memStream); this.pictureBox1.Image = myimge; } catch { DB.msgbox("从数据库读取相片失败！"); } } else pictureBox1.Image = null; } }
http://www.cnblogs.com/tuyile006/archive/2007/01/08/614718.html
