C#图片存入数据库并读取显示在picturebox中

实现功能：把图片及人员信息存入数据库并可通过编号查找显示在picturebox中，同时实现照片及信息的更新。

数据库构建：PhotoID int 4；EmployeeNO Varchar 20；EmployeeName Varchar 50 ；PhotoContent image 16;Ramrk text 16 点击“选择图片”打开一个对话框，选择一个图片放到picturebox中预览private void button1_Click(object sender, EventArgs e){using (OpenFileDialog ofd = new OpenFileDialog()){ofd.Title = "请选择要插入的图片";ofd.Filter = "*jpg|*.JPG|*.GIF|*.GIF|*.BMP|*.BMP";ofd.CheckFileExists = true;ofd.CheckPathExists = true;ofd.Multiselect = false;if (ofd.ShowDialog(this) == DialogResult.OK){txtfile = ofd.FileName;this.pb.ImageLocation = ofd.FileName;}}}点击“按钮”，调用update方法，以实现信息及照片的存储和更改private void btSave_Click(object sender, EventArgs e){if (txtfile == ""){HrBll.AppFrame.BllPhoto.update(txtRemark.Text,txtEmpNO .Text);}else{Update(txtfile, txtRemark.Text, txtEmpNO.Text);}Empty();}Update方法的代码Private void Update(string fullpath,string remark,string empno){FileStream fs = new FileStream(fullpath, FileMode.Open);byte[] imagebytes = new byte[fs.Length];BinaryReader br = new BinaryReader(fs);imagebytes = br.ReadBytes(Convert.ToInt32(fs.Length));string SQLstr = string.Format("update T_Photo set PhotoContent=@photo,Remark=@remark where EmployeeNO=@empno");SqlCommand com = new SqlCommand(SQLstr, Common.DataAccess.GetConn());com.Parameters.Add("photo", SqlDbType.Image);com.Parameters["photo"].Value = imagebytes;com.Parameters.Add("empno",SqlDbType.Char);com.Parameters["empno"].Value = empno;com.Parameters.Add("remark", SqlDbType.Char);com.Parameters["remark"].Value = remark;com.ExecuteNonQuery();Common.DataAccess.GetConn().Close();MessageBox.Show("更新成功", MessageBoxButtons.OK, rmation);}点击“查找”按钮，调用Find和img方法实现查找信息，并把文本信息显示在textbox中，照片显示在picturebox中private void tbFind_Click(object sender, EventArgs e){if (cbItem.Text == ""){MessageBox.Show("请输入员工编号", "提示º?", MessageBoxButtons.OK, rmation);}else{string sql = string.Format("select count(*) from T_Photo where EmployeeNO='{0}'", cbItem.Text);SqlCommand cmd = new SqlCommand(sql, Common.DataAccess.GetConn());int i = (int)cmd.ExecuteScalar();if (i == 1){txtEmpNO.Text = "";txtName.Text = "";txtRemark.Text = "";pb.Image = null;dataGridView1.DataSource =.Find(cbItem.Text);txtEmpNO.Text =.Find(cbItem.Text).Rows[0][1].ToString();txtName.Text =.Find(cbItem.Text).Rows[0][2].ToString();txtRemark.Text =.Find(cbItem.Text).Rows[0][3].ToString();pb.Image =.img(txtEmpNO.Text, txtName.Text);}else{MessageBox.Show("此员工不存在", "提示º?", MessageBoxButtons.OK, rmation); }}}Find方法(即返回一个datatable)Private static DataTable Find(string s){return Common.DataAccess.GetDatatable("selectT_Photo.PhotoID,T_Photo.EmployeeNO,T_Employee.EmployeeName,"+ "T_Photo.Remark from T_Photo inner join T_Employee on T_Photo.EmployeeNO=T_Employee.EmployeeNO where T_Photo.EmployeeNO= " + s);}Img方法Private static Image img(string txtno,string txtname){string sql1 = string.Format("select PhotoContent from T_Photo where EmployeeNO='{0}'", txtno);SqlCommand cmd1 = new SqlCommand(sql1, Common.DataAccess.GetConn());SqlDataReader dr = cmd1.ExecuteReader();while (dr.Read()){if (dr["PhotoContent"]== System.DBNull.Value){string message = string.Format("没?有®D{0}的Ì?照?片?，ê?请?添¬¨ª加¨®",txtname);MessageBox.Show(message,"提¬¨¢示º?",MessageBoxButtons.OK,rmation);}else{MemoryStream ms = new MemoryStream((byte[])dr[0]);Image img = Image.FromStream(ms);return img;}}return null;}点击datagridview显示数据private void dataGridView1_Click(object sender, EventArgs e){txtEmpNO.Text = dataGridView1.Rows[dataGridView1.CurrentCell.RowIndex].Cells[1].Value.ToString();txtName.Text = dataGridView1.Rows[dataGridView1.CurrentCell.RowIndex].Cells[2].Value.ToString();txtRemark .Text =dataGridView1 .Rows [dataGridView1 .CurrentCell .RowIndex].Cells[3].Value.ToString(); pb.Image =img(txtEmpNO.Text, txtName.Text);button1.Enabled = true;btSave.Enabled = true;}。