photoPictureBox.BackgroundImage = imgPhoto;
photoStream.Close();
} } }
catch (Exception ex)
{
this.infoPanel1.ShowInfo(InfoPanel.TipType.ERROR, "读文件出错:" + ex.Message);
} } }
mysql数据库没有用过,我用得是微软sql server,但是SQL语言是通用的。看了你的代码,有几个疑问:
1、string insertStr = "insert into test(photo) values(?photo)";
你这个test难道只有photo一个字段或其他字段都允许为空?如果不是,你肯定还要加上其他字段的值,对吧?
2、MySqlParameter paraPhoto = new MySqlParameter("?photo", MySqlDbType.MediumBlob);
你确认mysql的参数语法使用“?”吗?图片字段是MySqlDbType.MediumBlob?
这是我在sql server的的做法,仅供参考:
img = Image.FromFile(@"c:\test.jpg");
MemoryStream ms = new MemoryStream();
img.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg);
byte[] myData = ms.ToArray();
SqlConnection cn = new SqlConnection("Data Source=(local);Initial Catalog=utscadadb;Integrated Security=SSPI; User Id=sa;Password=ut2001;");
SqlCommand cmd = new SqlCommand("Update Table1 Set data = (@data) where id =3", cn);
cmd.Parameters.Add("@data ", SqlDbType.Image).Value = myData;
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();