winform 导入导出图片

最新推荐文章于 2024-11-03 23:27:26 发布

转载最新推荐文章于 2024-11-03 23:27:26 发布 · 273 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/lushixiong/p/4561159.html

文章标签：

#c# #数据库

本文介绍了一个使用C#进行图片文件的操作方法，包括从文件系统读取图片并显示在PictureBox中，将图片文件转化为二进制数据存入SQL Server数据库，以及从数据库中读取图片数据并再次显示。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

private void button1_Click(object sender, EventArgs e)
        {
            OpenFileDialog op = new OpenFileDialog();
            if (op.ShowDialog()==DialogResult.OK)
            {
                FileStream fs = new FileStream(op.FileName,FileMode.Open);
                Image img = System.Drawing.Bitmap.FromStream(fs);
                pictureBox1.Image = img;
                fs.Close();
            }
        }

        private void button2_Click(object sender, EventArgs e)
        {
            OpenFileDialog op = new OpenFileDialog();
            if (op.ShowDialog() == DialogResult.OK)
            {
                FileStream fs = new FileStream(op.FileName, FileMode.Open);
                BinaryReader dr = new BinaryReader(fs);
                byte[] by=new byte[fs.Length];
               by= dr.ReadBytes((int)fs.Length);
               SqlConnection conn = new SqlConnection("server=.;database=students_information;user=sa;pwd=123");
               conn.Open();
               SqlCommand cmd = conn.CreateCommand();
               cmd.CommandText = "insert into img(img) values(@img)";
               cmd.Parameters.Add(new SqlParameter("@img",by));
               cmd.ExecuteNonQuery();
               cmd.Dispose();
               conn.Close();
               MessageBox.Show("添加成功");
            }
        }

        private void button3_Click(object sender, EventArgs e)
        {
            byte[] by = null;
            SqlConnection conn = new SqlConnection("server=.;database=students_information;user=sa;pwd=123");
            conn.Open();
            SqlCommand cmd = conn.CreateCommand();
            cmd.CommandText = "select * from img";
            SqlDataReader dr = cmd.ExecuteReader();
            if (dr.Read())
            {
                by = (byte[])dr["img"];
            }
           
            conn.Close();

            MemoryStream ms = new MemoryStream(by);
            Image img = System.Drawing.Bitmap.FromStream(ms);
            pictureBox1.Image = img;
            ms.Close();

        }

转载于:https://www.cnblogs.com/lushixiong/p/4561159.html