C#将图片以二进制流形式存到数据库，并读取显示

张俊营监考官

于 2015-09-25 19:47:15 发布

阅读量9.5k

点赞数 5

分类专栏： C#

本文链接：https://blog.csdn.net/qingheshijiyuan/article/details/48737069

版权

C# 专栏收录该内容

290 篇文章 4 订阅

订阅专栏

        private void button1_Click(object sender, EventArgs e)
        {
            OpenFileDialog ofd = new OpenFileDialog();
            ofd.Filter = "图片文件|*.png;*.jpg";
           if(DialogResult.OK== ofd.ShowDialog())
           {
               imagecatalog = ofd.FileName;
               textBoxImageCatalog.Text = imagecatalog;
           }
        }

        private void button2_Click(object sender, EventArgs e)
        {
            FileStream fs =new FileStream(imagecatalog,FileMode.Open,FileAccess.Read);
            byte[] bytes =new byte[fs.Length];

            fs.Read(bytes,0,(int)fs.Length);

            string sql = "insert into pic values(" + textBoxImageID.Text + ",@image)";
            SqlParameter[] parameter = { new SqlParameter("@image", bytes) };

            int rows = DBUtil.BinaryDate(sql, parameter);
            MessageBox.Show(rows.ToString());

        }

        private void button3_Click(object sender, EventArgs e)
        {
            string sql = "select * from pic where id = " + textBoxID.Text;
            DataTable dt = DBUtil.GetData(sql);

            if(dt.Rows.Count>0)
            {
                byte[] bytes =(byte[])dt.Rows[0]["image"];

                MemoryStream ms = new MemoryStream(bytes);

                pictureBox1.Image = Image.FromStream(ms);
            }
        }