将图片以流的形式保存到数据库(Image)以及从数据库中取出显示

最新推荐文章于 2021-10-08 23:59:24 发布

weixin_30536513

最新推荐文章于 2021-10-08 23:59:24 发布

阅读量463

点赞数

文章标签：数据库 java golang

原文链接：http://www.cnblogs.com/skyrickie/articles/1392030.html

版权

将图片以流的形式保存到数据库(Image)以及从数据库中取出显示
try
            {
                 string imagepath = @" D:\backImage\black.jpg " ;
                FileStream fs = new FileStream(imagepath, FileMode.Open);
                BinaryReader br = new BinaryReader(fs);
                 byte [] myimages = br.ReadBytes(Convert.ToInt32(fs.Length));
                 // string conn_Str = @"server=.;database=pubs;user=sa;pwd=sasa";
                 string conn_Str = @" Data Source=DF15D10F40A945C\SQLEXPRESS;Initial catalog =pubs;user=sa;pwd=sasa " ;
                 using (SqlConnection sqlcon = new SqlConnection(conn_Str))
                {
                    sqlcon.Open();
                     string insertsql = " insert into table1 values(1,@image) " ;
                     using (SqlCommand sqlcom = new SqlCommand(insertsql, sqlcon))
                    {
                        SqlParameter sqlparameter = new SqlParameter( " @image " , SqlDbType.Image);
                        sqlparameter.Value = myimages;
                        sqlcom.Parameters.Add(sqlparameter);
                        sqlcom.ExecuteNonQuery();
                    }
                     string selectsql = " select * from table1 " ;
                     using (SqlCommand sqlcom = new SqlCommand(selectsql, sqlcon))
                    {
                        SqlDataReader sqldr = sqlcom.ExecuteReader();
                        sqldr.Read();
                         byte [] images = ( byte [])sqldr[ " myimage " ];
                        Stream stream = new MemoryStream(images);
                        pictureBox2.Image = System.Drawing.Image.FromStream(stream);
                    }
                }
            }
             catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }

转载于:https://www.cnblogs.com/skyrickie/articles/1392030.html