在Access中存取图片

连接数据库           

string source = @"Provider=Microsoft.Jet.OLEDB.4.0;
                Data Source=C:/Documents and Settings/tester/Desktop/db.mdb;Persist Security Info=False";
OleDbConnection conn = new OleDbConnection(source);
conn.Open();

 存图片到数据库中

            FileStream fs = new FileStream(@"C:/Documents and Settings/All Users/Documents/My Pictures/Sample Pictures/Blue hills.jpg",
                FileMode.Open);
            BinaryReader br = new BinaryReader(fs);
            byte[] aaa = new byte[fs.Length];
            br.Read(aaa, 0, (int)fs.Length);
          
            string operate = "insert into student(name, photo) values(@aaa,@bbb);";
            OleDbCommand cmd = new OleDbCommand(operate, conn);
            cmd.Parameters.AddWithValue("@aaa","ddd");
            cmd.Parameters.AddWithValue("@bbb", aaa);
            br.Close();
            fs.Close();
            cmd.ExecuteNonQuery();

取出图片

            string operate = "Select photo from student where name = 'ddd'";
            OleDbCommand cmd = new OleDbCommand(operate, conn);
                byte[] b = (byte[])cmd.ExecuteScalar();
                MemoryStream ms = new MemoryStream(b, true);
                ms.Write(b, 0, b.Length);
                Bitmap bitmap = new Bitmap(ms);
                this.pictureBox1.Image = (Image)bitmap;