假设存图片的表为
image:
xh varchar2(5)
photo blobstring sXH = "12345"
OracleConnection conn = new OracleConnection("Password=test;User ID=test;Data Source=test");
string sSQL = "select photo from image where xh = '"+sXH+"'";
OracleDataAdapter adt = new OracleDataAdapter(sSQL,conn);
DataSet ds = new DataSet();
adt.Fill(ds);
//写临时文件
Byte[] FileByteArray;
object aaa = ds.Tables[0].Rows[0]["photo"];
FileByteArray = (Byte[])aaa;
string sPath = @"C:\result.jpg";
FileStream fs = new FileStream(sPath,FileMode.OpenOrCreate,FileAccess.Write,FileShare.None);
fs.Write(FileByteArray,0,FileByteArray.Length);
fs.Flush();
fs.Close();
Image.ImageUrl = sPath;
image:
xh varchar2(5)
photo blobstring sXH = "12345"
OracleConnection conn = new OracleConnection("Password=test;User ID=test;Data Source=test");
string sSQL = "select photo from image where xh = '"+sXH+"'";
OracleDataAdapter adt = new OracleDataAdapter(sSQL,conn);
DataSet ds = new DataSet();
adt.Fill(ds);
//写临时文件
Byte[] FileByteArray;
object aaa = ds.Tables[0].Rows[0]["photo"];
FileByteArray = (Byte[])aaa;
string sPath = @"C:\result.jpg";
FileStream fs = new FileStream(sPath,FileMode.OpenOrCreate,FileAccess.Write,FileShare.None);
fs.Write(FileByteArray,0,FileByteArray.Length);
fs.Flush();
fs.Close();
Image.ImageUrl = sPath;
解决方案 »
- C#开发c/s模式的程序,怎样算是网络版?
- 无法将类型“EC.Public.EntityFun.En_Ec_Result”隐式转换为“Top.Api.Domain.FenxiaoProduct”
- 正则表达式,替换指定字符(无规则)
- 关于在visual studio 2005中单步调试stored procedure的问题
- datatable里面可以自动进行运算吗
- 求大虾们帮帮忙 如何在RichTextBox中进行鼠标定位?
- 执行SSIS包,显示进度条?
- 如何取得当前登录域的帐号?急。。。(100分)
- ==========控件问题
- 急啊!!一个关于DataGrid的索引的问题
- C#程序在WIN XP sp2下的打印问题
- treeview 判断节点状态
conn.Open();
SqlCommand cmd=new SqlCommand("insert into fuser values ('1a','1b',@i)",conn);
byte[] ib=new Byte[60000];
FileStream fs=new FileStream(@"D:\windows temp\temp\1.jpg",FileMode.Open ,FileAccess.Read );
fs.Read(ib,0,60000);
cmd.Parameters.Add("@i",SqlDbType.Image,(int)fs.Length);
cmd.Parameters["@i"].Value=ib;
cmd.ExecuteNonQuery();
conn.Close();-------------------------------------------------------
//从数据库读图片到pictureboxSqlConnection conn=new SqlConnection(@"data source=chenyuming2004\VSdotNET;uid=sa;pwd=cym;database=lhf");
conn.Open();
SqlCommand cmd=new SqlCommand("select 照片 from fuser where password='1b'",conn);
SqlDataReader reader=cmd.ExecuteReader();
reader.Read();
MemoryStream buf=new MemoryStream((byte[])reader[0]);
Image image=Image.FromStream(buf,true);
pictureBox1.Image=image;
Response.ContentType = "Application/octet-stream"
Response.Clear()
Response.AddHeader("Content-Disposition", " filename=" + Session("sFileName"))
Response.BinaryWrite(Session("Buffer"))
Response.End()要打开的页面上一BUTTON点击
commSelect.Connection.Open()
readData = commSelect.ExecuteReader
readData.Read()Buffer = readData("FILEDATA")dgdConn.Close()Session("Buffer") = Buffer
Session("sFileName") = sFileName
message = "<script>window.open('/66.aspx' ,target='_blank');" _
& "</script>"If (Not IsClientScriptBlockRegistered("message")) Then
RegisterClientScriptBlock("message", message)
End If