Access内保存图像Test

private void button1_Click(object sender, System.EventArgs e)
{
OleDbConnection mycnn=new OleDbConnection("provider=Microsoft.jet.oledb.4.0;data source=f:\dazhu.mdb");
mycnn.Open();

OleDbCommand mycmd=new OleDbCommand("update info set picture=@a",mycnn );  
  
FileStream mystream=new FileStream("f:\\1.jpg",FileMode.Open,FileAccess.Read);  
long len=mystream.Length;  
  
mycmd.Parameters.Add("@a",OleDbType.Binary,(int)len,"picture");  
mycmd.Parameters["@a"].Direction=System.Data.ParameterDirection.Input;  
  
byte []box=new byte[len];  
  
  
mystream.Read(box,0,(int)len);  
  
mycmd.Parameters["@a"].Value=box;  
  
//更新  
mycmd.ExecuteNonQuery();  
MessageBox.Show("ok");  
mystream.Close();  
mycnn.Close();  
}