以二進制形式通過AppendChunk()方法存到資料庫裡,再通過Image類的FromStream()方法将圖檔顯示到PictureBox控件中.
AppendChunk()方法:
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into cpic values(@車牌号,@車圖)");
SqlCommand cmd = new SqlCommand(strSql.ToString(), conn);
cmd.Parameters.Add("@車牌号", SqlDbType.Text).Value = cph;
cmd.Parameters.Add("@車圖", SqlDbType.Binary).Value = pic;
Image類的FromStream()方法:
byte[] pic = (byte[])dt.Rows[*][*];
//MessageBox.Show(dt.Rows[*][*].ToString());
MemoryStream ms = new MemoryStream(pic);
this.pictureBox1.Image = Image.FromStream(ms);