C#读写图片文件到Access数据库中

Access数据库连接字符串 const string conStr = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\MyAccessFile\MyPicte.accdb;Persist Security Info=False"; string pic = string.Empty; //保存图片转化字符串 //选择图片并写入数据库中 private void button1_Click(object sender, EventArgs e) { //打开文件对话框选择图片文件 OpenFileDialog openfile = new OpenFileDialog(); openfile.Title = "请选择图片"; openfile.Filter="图片(*.jpg;*.bmp;*.png)|*.jpeg;*.jpg;*.bmp;*.png|AllFiles(*.*)|*.*"; if (DialogResult.OK != openfile.ShowDialog()) return; try { //显示图片到PictureBox控件中 Bitmap bmp = new Bitmap(openfile.FileName); pictureBox1.Image = bmp; pictureBox1.SizeMode = PictureBoxSizeMode.Zoom; //把图片转化成二进制，最后转成字符串 MemoryStream ms = new MemoryStream(); bmp.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg); byte[] arr = new byte[ms.Length]; ms.Position = 0; ms.Read(arr, 0, (int)ms.Length); ms.Close(); pic = Convert.ToBase64String(arr); //把Byte字节数组转成字符串 //pic = ImageToString(openfile.FileName);//自己写的图片转字符串的函数封装 //写入数据库中 OleDbConnection conn = new OleDbConnection(conStr); string sql = $"insert into mTable (pictName,pictText) values (‘{openfile.FileName}‘,‘{pic}‘)"; OleDbCommand cmd = new OleDbCommand(sql, conn); conn.Open(); int res = cmd.ExecuteNonQuery(); if (res > 0) { MessageBox.Show("图片保存成功！"); } conn.Close(); conn.Dispose(); } catch (Exception) { throw; } }

2。从数据库中读取图片文件

//从数据库中读取图片，并显示在PictureBoc控件中
        private void button2_Click(object sender, EventArgs e)
        {
            int id = 6;//要读取的图片在数据库中的编号，因为是测试就手动修改要读取的编号
            try
            {
                OleDbConnection conn = new OleDbConnection(conStr);
                string sql = $"select pictText from mTable where ID={id}";
                OleDbCommand cmd = new OleDbCommand(sql, conn);
                conn.Open();
                OleDbDataAdapter oda = new OleDbDataAdapter(cmd);
                DataTable dt = new DataTable();
                oda.Fill(dt);
                conn.Close();
                conn.Dispose();

                if(dt.Rows.Count>0)
                {
                    pic = dt.Rows[0][0].ToString();
                    if (!string.IsNullOrEmpty(pic))
                    {
                        //把string转成字节数组
                        byte[] imageBytes = Convert.FromBase64String(pic);
                        //把字节读取到内存
                        MemoryStream memoryStream = new MemoryStream(imageBytes, 0, imageBytes.Length);
                        memoryStream.Write(imageBytes, 0, imageBytes.Length);

                        //字节数组转成Image对象
                        Image image = Image.FromStream(memoryStream);

                        //Image image = StringToImage(pic);

                        //显示图片到控件中
                        this.pictureBox2.SizeMode = PictureBoxSizeMode.Zoom;
                        this.pictureBox2.Image = image;
                    }
                }
            }
            catch (Exception)
            {

                throw;
            }
        }

学习成果展示：

 

 

好了今天就学到这了。

 

C#读写图片文件到Access数据库中

标签：orm   ros   insert   gre   rom   byte   isp   sage   span