保存图象到Sql Server，并且读取显示

现有图象数据表

CREATE TABLE [ENTR_Image] (
    [EIGuid] [nvarchar] ( 50 ) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF__ENTR_Imag__EIGui__2C3F4C1F] DEFAULT (newid()),
    [EImage] [image] NOT NULL CONSTRAINT [DF__ENTR_Imag__EImag__2D337058] DEFAULT ( '' ),
    [VImage] [image] NOT NULL CONSTRAINT [DF__ENTR_Imag__VImag__2E279491] DEFAULT ( '' ),
    [OperationTime] [datetime] NOT NULL CONSTRAINT [DF__ENTR_Imag__Opera__2F1BB8CA] DEFAULT (getdate()),
     PRIMARY KEY  CLUSTERED 
    (
        [EIGuid]
    )  ON [PRIMARY] 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

需要把指定的图片添加到数据库里面
打开图片到picturebox里面

private   void  button1_Click( object  sender, System.EventArgs e)
         {
            OpenFileDialog oFileDialog1 = new OpenFileDialog();
            oFileDialog1.InitialDirectory = "c:\\" ;
            oFileDialog1.Filter ="Image Files(*.BMP;*.JPG;*.GIF)|*.BMP;*.JPG;*.GIF|All files (*.*)|*.*";
            oFileDialog1.FilterIndex = 1 ;
            oFileDialog1.RestoreDirectory = true ;
            if(oFileDialog1.ShowDialog() == DialogResult.OK)
            {
                if(oFileDialog1.FileName != null)
                {
                    if (pictureBox1.Image!=null)
                    {
                        //MessageBox.Show("OK");
                        label4.Text=oFileDialog1.FileName; 
                        pictureBox2.Image=Image.FromFile(oFileDialog1.FileName);
                        return;
                    }
                    label3.Text=oFileDialog1.FileName; 
                    //textBox1.Text=oFileDialog1.FileName; 
                    pictureBox1.Image=Image.FromFile(oFileDialog1.FileName);
                
                }
            }
        }

保存图象到数据表

private   void  button2_Click( object  sender, System.EventArgs e)
         {
            //保存
            string filename =label3.Text;
            byte [] content = ImageToStream(filename);
            
            string filename1 =label4.Text;
            byte [] content1 = ImageToStream(filename1);

            StoreImage(content,content1);
        }

其中用到如下方法：把指定文件名的图片转化为二进制流byte[]

 

private byte []  ImageToStream(string fileName)
        {
            Bitmap image  =  new Bitmap(fileName) ;
            MemoryStream stream  =  new MemoryStream() ;
            image.Save(stream ,  System.Drawing.Imaging.ImageFormat.Bmp) ;
            return stream.ToArray() ;
        }

保存byte[]到数据表

private void StoreImage(byte []  content , byte []  connect1)
        {
//            if (MainForm.conn.State.Equals(ConnectionState.Closed)) 
//                MainForm.conn.Open() ;
            string str_Conn = " server=SERVER-DBT;database=LogERP;uid=logerp;pwd=logerpok;Max Pool Size=20000; " ;
            
            try
            {
                SqlConnection sqlconn = new SqlConnection(str_Conn) ;
                sqlconn.Open() ;
               
                SqlCommand insert  =  new SqlCommand( " Insert into ENTR_Image(EImage,VImage) values (@EImage,@VImage) " ) ;
                insert.Connection = sqlconn ;
                SqlParameter imageParameter  =  
                    insert.Parameters.Add( " @EImage " ,  SqlDbType.Binary) ;
                imageParameter.Value  =  content ;
                imageParameter.Size   =  content.Length ;

                SqlParameter imageParameter1  =  
                    insert.Parameters.Add( " @VImage " ,  SqlDbType.Binary) ;
                imageParameter1.Value  =  connect1 ;
                imageParameter1.Size   =  connect1.Length ;
                

                int i = insert.ExecuteNonQuery() ;                 
                sqlconn.Close() ;
                MessageBox.Show(i.ToString()) ;

            }
            catch(Exception ex)
            {
                MessageBox.Show(ex.Message.ToString()) ;
                MessageBox.Show(ex.StackTrace.ToString ()) ;  
            }
            finally
            {
//                MainForm.conn.Close() ;
            }
        } 

新增以后，根据guid查询图像

private string str_Guid ;
        public string str_ImageGuid
        {
            set
            {
                str_Guid = value ;
            }
        }

 private void ReadImage()
        {
            string str_Conn = " server=172.17.100.132;database=Northwind;uid=sa;pwd=19791225;Max Pool Size=20000; " ;
            try
            {
                //根据GUID读取图片
                SqlConnection sqlconn = new SqlConnection(str_Conn) ;
                sqlconn.Open() ;
                string str_Sql = " select EImage from ENTR_Image where EIGuid=' " +str_Guid+ " ' " ;
                SqlCommand cmd = new SqlCommand(str_Sql) ;
                cmd.Connection = sqlconn ;
                byte  []  content  =  (byte []  )cmd.ExecuteScalar() ;
                try
                {
                    MemoryStream stream  =  new MemoryStream(content) ;
                    pictureBox1.Image =  Image.FromStream(stream) ;  
                }
                catch
                {

                }


                str_Sql = " select VImage from ENTR_Image where EIGuid=' " +str_Guid+ " ' " ;
                cmd = new SqlCommand(str_Sql) ;
                cmd.Connection = sqlconn ;
                content  =  (byte []  )cmd.ExecuteScalar() ;
                try
                {
                    MemoryStream stream  =  new MemoryStream(content) ;
                    pictureBox2.Image =  Image.FromStream(stream) ;  
                }
                catch
                {
                }
                sqlconn.Close() ;
                
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message.ToString()) ;
                MessageBox.Show(ex.StackTrace.ToString ()) ;  
            }
        }

byte[]的初始化

byte [] byt = {} ;
            ClassEnt_rsDrawing.Browser = byt;

现在如果转换过来
把sql里面的image字段的内容读入文件
代码如下：

  /**/ /**/ /**/ /// <summary>
        /// 根据2进制数组获得文件
        /// </summary>
        /// <param name="byt">2进制数据</param>
        /// <param name="str_Filename">目标文件</param>
         private   void  GetFileFromDataBase( byte [] byt, string  str_Filename)
         {
            //MemoryStream stream = new MemoryStream(byt);
            FileStream fs_stream=new FileStream(str_Filename,FileMode.CreateNew);
            BinaryWriter writefile = new BinaryWriter(fs_stream);
            writefile.Write(byt);
            writefile.Close();            
        }

辅助代码，保存对话框

   /**/ /**/ /**/ /// <summary>
        /// 另存为 保存文件对话框
        /// </summary>
        /// <returns></returns>
         private   string  fun_savefilename()
         {
            string savefilename="";
            SaveFileDialog saveFileDialog1 = new SaveFileDialog(); 
            saveFileDialog1.Filter = "jpg files (*.jpg)|*.jpg|All files (*.*)|*.*"  ;
            
            saveFileDialog1.FilterIndex = 1 ;
            saveFileDialog1.RestoreDirectory = true ;
            
            if(saveFileDialog1.ShowDialog() == DialogResult.OK)
            {
                savefilename=saveFileDialog1.FileName;                 
            }
            return savefilename;
        }

把数据库里的image读取到byte[]里，代码
这里browser是image类型

public   byte [] GetImage( string  str_Guid)
         {
            byte[] byt={};
            StringBuilder strSql=new StringBuilder();
            strSql.Append("select Browser from rsDrawing ");
            if(str_Guid.Trim()!="")
            {
                strSql.Append(" where Guid='"+str_Guid+"'");
            }
            byt=DataBase.GetByteImage(strSql.ToString());            
            return byt;
        }



     /**/ /**/ /**/ /// <summary>
        /// 根据Sql(完整)语句，获得Byte[]图片信息
        /// </summary>
        /// <param name="str_Sql">SQL语句</param>
        /// <returns>二进制流</returns>
         public   static   byte [] GetByteImage( string  str_Sql)
         {            
            string connectionString = System.Configuration.ConfigurationSettings.AppSettings["ConnStr"].ToString();
            byte [] content={};
            SqlConnection sqlconn=new SqlConnection(connectionString);
            sqlconn.Open();            
            SqlCommand cmd=new SqlCommand(str_Sql);
            cmd.Connection=sqlconn;
            content = (byte[] )cmd.ExecuteScalar();
            sqlconn.Close();
            return content;
        }

显示 byte[]到form里面

  /**/ /**/ /**/ /// <summary>
        /// 显示图象到窗体
        /// </summary>
        /// <param name="byt_Image"></param>
         private   void  ImageLoad( byte [] byt_Image)
         {
            DevExpress.XtraEditors.PictureEdit pb = new DevExpress.XtraEditors.PictureEdit();
            Form f= new Form();
            f.Controls.Add(pb);
            f.MinimizeBox = false;
            f.MaximizeBox=false;
            pb.Dock=DockStyle.Fill;
            pb.Properties.SizeMode = DevExpress.XtraEditors.Controls.PictureSizeMode.Stretch ;
            f.StartPosition = FormStartPosition.CenterScreen;
            pb.Properties.PictureStoreMode = DevExpress.XtraEditors.Controls.PictureStoreMode.ByteArray;
            pb.EditValue = byt_Image;
            f.Show();
        }

转载于:https://www.cnblogs.com/aaliujing/archive/2006/12/18/595773.html