string filenamepath = "e:\\001.jpg";
FileStream fs = new FileStream(filenamepath, FileMode.Open);
int length = (int)fs.Length;
byte[] obj = new byte[length];
fs.Read(obj, 0, length);
DataAccessInterface.ExecuteNonQuery("update TR_EQUIP set IMAGE='"+obj+"' where EQUIPCODE='001'", "");数据库中是blob类型
为什么提示更新不了
FileStream fs = new FileStream(filenamepath, FileMode.Open);
int length = (int)fs.Length;
byte[] obj = new byte[length];
fs.Read(obj, 0, length);
DataAccessInterface.ExecuteNonQuery("update TR_EQUIP set IMAGE='"+obj+"' where EQUIPCODE='001'", "");数据库中是blob类型
为什么提示更新不了
2.cmd需要使用参数形式:
cmd.CommandText = "update TR_EQUIP set IMAGE=? where EQUIPCODE='001'"
cmd.Parrameters.Add("@Image",OleDbDataType.Binary);
cmd.Parrameters[0].value=obj;不知道你的orm是否支持parametters