C#读取写入图片到数据库(精华).doc

using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;using System.IO;using System.Net;namespace Final public partial class FrmUpLoadPicture : Form string picturePath = string.Empty; /声明一个变量，记录图片路径 public FrmUpLoadPicture() InitializeComponent(); /打开图片路径 private void btnOpen_Click(object sender, EventArgs e) OpenPath(); private void btnUpLoad_Click_1(object sender, EventArgs e) int i = -1; string UpLoadsql = update teacher set picture = picture where teacherId = T003; i = UpLoadPicture(UpLoadsql); if (i 0) MessageBox.Show(头像添加成功。); private void btnDnowLoad_Click_1(object sender, EventArgs e) string DnowLoadsql = select picture from teacher where teacherId = T003; pictureBox2.Image = DnowLoadPicture(DnowLoadsql); / / 打开图片所在位置 / public void OpenPath() OpenFileDialog Openfile = new OpenFileDialog(); Openfile.Filter = *jpg|*.JPG|*.GIF|*.GIF|*.BMP|*.BMP; if (Openfile.ShowDialog() = DialogResult.OK) try pictureBox1.Image = System.Drawing.Image.FromFile(Openfile.FileName); picturePath = Openfile.FileName.ToString(); catch (Exception ex) MessageBox.Show(ex.Message.ToString(), 错误, MessageBoxButtons.OK, MessageBoxIcon.Error); / / 读取数据库中的图片 / public Image DnowLoadPicture(string sql) Image haha = null; MemoryStream ms = null; try SqlCommand comm = new SqlCommand(sql, DB.conn); DB.conn.Open(); SqlDataReader dr = comm.ExecuteReader(); if (dr.HasRows) while (dr.Read() ms = new MemoryStream(byte)dr.GetValue(0); dr.Close(); comm.Clone(); haha = Image.FromStream(ms, true); catch (Exception ex) MessageBox.Show(读取数据失败。 + ex.Message); finally DB.conn.Close(); return haha; / / /上传图片至数据库 / public int UpLoadPicture(string sql) int i = -1; Byte bytBLOBData = null; try FileStream file = new FileStream(picturePath, FileMode.Open, FileAccess.Read); bytBLOBData = new Bytefile.Length; file.Read(bytBLOBData, 0, bytBLOBData.Length); file.Close(); SqlCommand comm = new SqlCommand(sql, DB.conn); comm.Parameters.Add(new SqlParameter(picture, bytBLOBData); DB.conn.Open(); i = comm.E