110,534
社区成员
发帖
与我相关
我的任务
分享
/// <summary>
/// 读取图片
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static OracleDataReader getdr(string id)
{
string sql = "select Content from AccessoryInfo where AccessoryInfoID = '" + id + "'";
OracleConnection con = new OracleConnection(ConfigurationManager.AppSettings["ConnectionString"]);
con.Open();
OracleDataReader dr;
try
{
OracleCommand cmd = new OracleCommand(sql, con);
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
return dr;
}
catch (Exception ex)
{
ST.Common.WebUtil.LogUtil.Log(ex.Message);
return null;
}
}
OracleDataReader dr = ImageUtil.getdr(id);
if (dr != null && dr.Read())
{
if (dr["Content"] != DBNull.Value)
{
byte[] bytearr = (byte[])dr["Content"];//用byte数组取值
//do..
}
}
dr.Close();