存:
SqlCommand commd = new SqlCommand("update tr_person set signa = @signa where pid = @pid");
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Database"].ToString());
conn.Open();
commd.Connection = conn;
commd.Parameters.Add("@signa", SqlDbType.Image).Value = signa;
commd.Parameters.Add("@pid", SqlDbType.Int).Value = pid;
try
{
commd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show("更新人员签名失败:" + ex.Message);
}
取:
byte[] _bytes = (byte[])_U_Query.Rows[0]["signa"];
MemoryStream ms = new MemoryStream(_bytes);
Bitmap bmp = new Bitmap(ms);
pictureBox1.Image = bmp;
ms.Close();