c#winform读取oracle中blob字段的图片并且显示到pictureBox里保存进库.docVIP

private?void?button2_Click(object?sender,?EventArgs?e) ?? { ?? ????OracleConnection?conn?=?dbc.getConnection();//获得conn连接 ?? ????try?? ????{ ?? ????????conn.Open(); ?? ????????OracleCommand?cmd?=?conn.CreateCommand(); ?? ????????cmd.CommandText?=?SELECT?zp?FROM?kk.kkbj?WHERE?xh?=?2345?;//查询获得图片流 ?? ?? ????????OracleDataReader?reader?=?cmd.ExecuteReader();//创建一个OracleDateReader对象? ?? ????????reader.Read(); ?? ?? ????????MemoryStream?ms?=?new?MemoryStream((byte[])reader[zp]); ?? ?? ????????Image?image?=?Image.FromStream(ms,?true); ?? ?? ????????reader.Close(); ?? ????????conn.Close(); ?? ?? ????????pictureBox1.Image?=?image; ?? ????} ?? ????catch?(Exception?ee) ?? ????{ ?? ????????MessageBox.Show(ee.Message.ToString()); ?? ????} ?? ?? }?? private void button2_Click(object sender, EventArgs e) { OracleConnection conn = dbc.getConnection();//获得conn连接 try { conn.Open(); OracleCommand cmd = conn.CreateCommand(); cmd.CommandText = SELECT zp FROM kk.kkbj WHERE xh = 2345 ;//查询获得图片流 OracleDataReader reader = cmd.ExecuteReader();//创建一个OracleDateReader对象 reader.Read(); MemoryStream ms = new MemoryStream((byte[])reader[zp]); Image image = Image.FromStream(ms, true); reader.Close(); conn.Close(); pictureBox1.Image = image; } catch (Exception ee) { MessageBox.Show(ee.Message.ToString()); } } 下边是上传和存入数据库有和winform(转) 本文总结如何在.Net Winform和.Net webform()中将图片存入sqlserver中并读取显示的方法 ??? 1，使用将图片上传并存入SqlServer中，然后从SqlServer中读取并显示出来 ??? 一，上传并存入SqlServer ??? 数据库结构 create table test { ???? id identity(1,1), ???? FImage image } ??? 相关的存储过程 Create proc UpdateImage ( ???? @UpdateImage Image ) As Insert Into test(FImage) values(@UpdateImage) GO ??? 在UpPhoto.aspx文件中添加如下: C#代码 ? input?id=UpPhoto?name=UpPhoto?runat=server?type=file ?? asp:Button?id=btnAdd?name=btnAdd?runat=server?Text=上传/asp:Button?? input id=UpPhoto name=UpPhoto runat=server type=file asp:Button id=btnAdd name=btnAdd runat=server Text=上传/asp:Button ??? 然后在后置代码文件UpPhoto.aspx.cs添加