Access如何保存存图片

Question

RT
保存图到OLE对像中,要怎么写呀...
搞不定了....
急...

Answer 1

OleDbCommand cmd = new OleDbCommand();
            cmd.Connection = conn;
            FileStream fs = new FileStream(openFileDialog1.FileName, FileMode.Open, FileAccess.Read);
            byte[] content = new byte[fs.Length];
            fs.Read(content, 0, content.Length);
            fs.Close(); 
            
            cmd.CommandText = "insert into ladder (ladderpic) values(@img)";
            cmd.Parameters.Add("@img",content);
            if (cmd.ExecuteNonQuery() == 1)
                MessageBox.Show("insert into database success.") ;
            else
                MessageBox.Show("insert into database failure")
;            fs.Close();
            fs.Dispose();
          //  br.Close();
            cmd.Dispose();

Answer 2

OleDbCommand cmd = new OleDbCommand("select top 1 ladderpic from ladder order by nindex desc", conn);
            OleDbDataReader reader = cmd.ExecuteReader();
            if (reader.HasRows)
            {
                reader.Read(); //               BinaryReader br = new BinaryReader(reader["ladderpic"].ToString());
                MemoryStream ms = new MemoryStream((byte[])reader["ladderpic"]);
                Image image = Image.FromStream(ms, true);
                pictureBox1.Image = image;
                                reader.Close();

Answer 3

楼上正解,只是我现在遇到个问题
路径问题
http://topic.csdn.net/u/20071126/14/818edd19-24d9-43c5-99a2-2e1326d9c2b5.html

Answer 4

new OleDbParameter("@Photo",info.Photo)
保存时我这样定义了参数，info.Photo是byte[]类型．在读取时：
 object obj=ds.Tables[0].Rows[0]["photo"];
                if (obj.GetType() != typeof(DBNull))
                {
                    info.Photo=(byte[])obj;
                }
                else
                {
                    info.Photo = new byte[0];
                }在显示时：if (m_EmpInfo.Photo.Length > 0)
            {
                try
                {
                    System.IO.MemoryStream sm = new System.IO.MemoryStream(m_EmpInfo.Photo);
                    picPhoto.Image =Image.FromStream(sm);
                }
                catch (Exception ex)
                {
                    MessageBox.Show("图片加载失败");
                }
            }可是不行．我错在哪里．．．

Answer 5

是的...实在不行也只好保存图片名称了.....
www.soft000.com/person.rar
可我想知道哪出问题了.....帮看一下下...