插入图片:
using (MySqlConnection con = new MySqlConnection(strCon))
{
using (MySqlCommand cmd = con.CreateCommand())
{
cmd.CommandText = "insert into tb_worker values('318','朱攀11','软工','研 发',@headimag,'1223')";
con.Open();
cmd.Parameters.Add("@headimag", SqlDbType.Image);
MemoryStream ms = new MemoryStream();
Image.FromFile("P1060297.jpg").Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg);
cmd.Parameters["@headimag"].Value = ms.GetBuffer();
ms.Close();
int res = cmd.ExecuteNonQuery();
Console.WriteLine("成功插入了" + res + "条");
}
}
取图片:
using (MySqlConnection con = new MySqlConnection(strCon))
{
using (MySqlCommand cmd = con.CreateCommand())
{
con.Open();
cmd.CommandText = "select * from tb_worker where Epc='" + s + "'";
DataTable dt = new DataTable();
MySqlDataAdapter sda = new MySqlDataAdapter(cmd);
int fill = sda.Fill(dt);
if (dt.Rows[0].ItemArray[4] != DBNull.Value)
{
byte[] buffer = (byte[])dt.Rows[0].ItemArray[4];
MemoryStream ms = new MemoryStream(buffer);
pictureBox1.Image = Image.FromStream(ms);
}
帮忙看看有什么问题啊?