如题
解决方案 »
- (急急急)为何在PL/SQL Developer建立的表到Oracle Enterprise Manager相应的用户下看不到啊???
- 把带有blob数据类型的表导出csv
- 求教一句sql来转换表格输出样式
- 帮忙解释下oracle执行计划的含义
- 请问oracle的事务是用什么关键字来标示开始的?
- oracle 怎么将字符型数据转换成整型数据?请教!!
- 期待你的加入。ORACLE QQ 联盟。现在正在自学ORACLE 9i,希望能更好的和大家交流。
- 中文乱码
- what's the mean of this mistake?
- 请教各位大神一个统计的sql语句,感谢
- !! 在库之间导表问题,急急 !!
- 在oracle存储过程中实现分区怎么写啊,想利用for循环实现
2、然后用insert或者update 该字段,值为empty_blob()
3、用UPDATEBLOB 更新字段=图片文件(在PB中先设一个BLOB类型的变量来读图片)
.写入BLOB string file_name = "D:\\20080523.jpg";
string conn_str = "Provider=OraOLEDB.Oracle.1;Password=agoodjob;Persist Security Info=True;User ID=ams;Data Source=ims;Extended Properties=";//Provider必須用OraOLEDB.Oracle.1
OleDbConnection cn = new OleDbConnection(conn_str);
cn.Open(); OleDbCommand cmd = new OleDbCommand("UPDATE BLOB SET PHOTO = ? ",cn);
cmd.Parameters.Add("PHOTO",OleDbType.Binary);
FileStream fs = new FileStream(file_name, FileMode.OpenOrCreate, FileAccess.Read);
byte[] MyData= new byte[fs.Length];
fs.Read(MyData, 0, System.Convert.ToInt32(fs.Length));
fs.Close(); cmd.Parameters["PHOTO"].Value = MyData;
try
{
int result = cmd.ExecuteNonQuery();
if(result<1)
{
OleDbCommand cmd1 = new OleDbCommand(" INSERT INTO BLOB (PHOTO) VALUES ( ? )",cn);
cmd1.Parameters.Add("PHOTO",OleDbType.Binary);
cmd1.Parameters["PHOTO"].Value = MyData;
result = cmd1.ExecuteNonQuery();
}
}
catch(Exception e1)
{
Page.RegisterStartupScript("","<script language='javascript'>alert('"+e1.Message+"')</script>");
}
finally
{
cn.Close();
}2.读取BLOB string conn_str = "Provider=OraOLEDB.Oracle.1;Password=agoodjob;Persist Security Info=True;User ID=ams;Data Source=ims;Extended Properties=";//Provider必須用OraOLEDB.Oracle.1
OleDbDataAdapter da = new OleDbDataAdapter();
DataSet ds = new DataSet();
OleDbConnection conn = new OleDbConnection(conn_str);
OleDbCommand cmd = new OleDbCommand("SELECT PHOTO FROM WEB_DB.USERS WHERE USER_ID = 1", conn);
da.SelectCommand = cmd;
cmd.Connection.Open();
da.Fill(ds); byte[] img = new byte[0];
DataRow dr;
dr = ds.Tables[0].Rows[0]; if (!ds.Tables[0].Rows[0]["PHOTO"].ToString().Equals(""))
{
img = (byte[])dr["PHOTO"];
} Response.ContentType= "image/*";
Response.BinaryWrite (img); conn.Close();