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);