问题描述
在winform程序中(C#语言),需要将一张图片存入数据库中,Oracle中字段类型为BLOB,请问哪位大侠做过,给个示例,谢谢!QQ:36519258E-mail:dongwei_sy@163.com急用,不胜感激!
解决方案
解决方案二:
DimstrConnAsStringDimobjConnAsOracleConnectionDimobjCommAsOracleCommandPrivateSubForm1_Load(ByValsenderAsSystem.Object,ByValeAsSystem.EventArgs)HandlesMyBase.LoadstrConn="UserId=scott;Password=tiger;DataSource=oracle"EndSubPublicSubInsertDeptLOGO(ByValintDeptNOAsInteger,ByValbytsLogoAsByte())DimstrSqlAsString="INSERTINTODEPT_LOGOT(DEPTNO,LOGO)VALUES(:PI_LOGO,:PI_DEPTNO)"TryobjConn=NewOracleConnection(strConn)objComm=NewOracleCommand(strSql,objConn)objComm.Parameters.Add("PI_LOGO",OracleType.Blob).Value=bytsLogoobjComm.Parameters.Add("PI_DEPTNO",OracleType.Number).Value=intDeptNOobjConn.Open()objComm.ExecuteNonQuery()CatchexAsExceptionMessageBox.Show(ex.Message)FinallyIfNotobjConnIsNothingThenobjConn.Close()EndIfEndTryEndSub