Access之图片读取,存储

Access之图片读取,存储

图片存储

  

 

            FileStream fs = new  FileStream( " logo14.bmp " ,FileMode.Open);
             byte [] myImage = new   byte [fs.Length];
            fs.Read(myImage, 0 ,myImage.Length);
            fs.Close();


             string  strConn = " Provider=Microsoft.Jet.OLEDB.4.0;Data Source=FingerMarkData.mdb " ;
            OleDbConnection myConn = new  OleDbConnection(strConn);
            OleDbCommand myComm = new  OleDbCommand();
        
            myComm.CommandText = " insert into T_FingerMarkInfo (id,[image]) values (1,@image) " ;
            myComm.Connection = myConn;
            myComm.Parameters.Add( " @image " ,OleDbType.Binary);
            myComm.Parameters[ " @image " ].Value = myImage;
            myConn.Open();
             try
             {
                myComm.ExecuteNonQuery();
            }
             catch (Exception e1)
             {
                Console.Write(e1.ToString());
            }
             finally
             {
                myConn.Close();
            }

 

图片读取

            string  sql = " select * from T_FingerMarkInfo where id=1 " ;
             string  strConn = " Provider=Microsoft.Jet.OLEDB.4.0;Data Source=FingerMarkData.mdb " ;
            OleDbConnection pubsConn = new  OleDbConnection(strConn);
            
            OleDbCommand logoCMD = new  OleDbCommand(sql,pubsConn);
                 
             byte [] outbyte  =   new   byte [ 10000 ]; 

            pubsConn.Open(); 
            OleDbDataReader myReader  =  logoCMD.ExecuteReader(); 

             while (myReader.Read()) 
             { 
                long retval = myReader.GetBytes(1, 0, outbyte, 0, 10000); 
            }
            myReader.Close(); 
            pubsConn.Close();
            MemoryStream stmBLOBData  =   new  MemoryStream(outbyte);
            pictureBox1.Image =  Image.FromStream(stmBLOBData);