oracle中添加图片,C#向oracle数据库添加图片和读取图片(BOLB字段)

using System.Data.OracleClient;

using System.IO

//打开数据库

String connectionstring = "Data Source=apts_test;user id=aptstest;password=test"; OracleConnection con =new OracleConnection(connectionstring);

con.Open();

//向指定记录添加blob字段，例如图片

private void add_blob()

{

String sql = @"update testxx set image=:myimage where ID=:myid";//在testxx 表中有个字段叫image是blob类型的注意中的冒号，通过myid制定记录OracleCommand cmd = new OracleCommand(sql, con);

cmd.Parameters.Add(new OracleParameter("myimage", OracleType.Blob));//给这个两个参数赋值myimage和myid

cmd.Parameters.Add(new OracleParameter("myid", OracleType.VarChar)); cmd.Parameters["myid"].Value = "1";

//给image字段赋值字节数组

FileStream fs = File.OpenRead("D:/ 2.jpg");

byte[] imagebyte = new byte[fs.Length];

fs.Read(imagebyte, 0, (int)fs.Length);

cmd.Parameters["myimage"].Value = imagebyte;

try

{

int result = cmd.ExecuteNonQuery();

if (result < 1)

System.Console.WriteLine("success");

else

System.Console.WriteLine("error");

}

catch (Exception e1)

{ }

}

//读取指定记录的blob字段，例如图片

String sql = @"select * from testxx where ID='1' "; OracleCommand cmd = new OracleCommand(sql, con);

OracleDataReader rs = cmd.ExecuteReader();

while (rs.Read())//

{

byte[] File = (byte[])rs["image"];

Image photo = null;

using (MemoryStream ms = new MemoryStream(File))

{