日期:2014-05-18 浏览次数:20781 次
public Byte[] getphoto(string photopath) { string str = photopath; FileStream file = new FileStream(str, FileMode.Open, FileAccess.Read); Byte[] bytBLOBData = new Byte[file.Length]; file.Read(bytBLOBData, 0, bytBLOBData.Length); file.Close(); return bytBLOBData; }//这是定义函数.. 然后..就是将转换成二进制码的图片插入数据库中..下面是简单的也是重要的sql语句.. if (this.pictureBox1.Image != null) { sql1 = sql1 + ",Photo"; sql2 = sql2 + ",bytBLOBData"; Byte[] bytBLOBData = getphoto(openFileDialog1.FileName); cmd.Parameters.Add(new OleDbParameter("jpeg", OleDbType.Binary, bytBLOBData.Length, ParameterDirection.Input, true, 0, 0, null, DataRowVersion.Default, bytBLOBData)); } 接下来..是读取... string sql = "select photo from studentinfo where studentid = " + this.Tag.ToString(); OleDbCommand cmd = new OleDbCommand(sql, connection1); if (Convert.DBNull != cmd.ExecuteScalar()) pictureBox1.Image = Image.FromStream(new MemoryStream((Byte[])cmd.ExecuteScalar()));//读取长二进制为图片..