c# 操作oracle blob,C# 读取和写入oracle的blob字段的方法

C# 读取和写入oracle的blob字段的方法

//向数据库中写入

private void button1_Click(object sender, EventArgs e)

{

oracleConnection1.Open();

OracleCommand cmd = new OracleCommand("UPDATE TEST SET F2 =:blob where F1=:sn ", oracleConnection1);

cmd.Parameters.Add(new OracleParameter("blob",OracleType.Blob));

cmd.Parameters.Add(new OracleParameter("sn",OracleType.Int32));

FileInfo fi = new FileInfo("c:\\dos.doc");

FileStream fs = fi.OpenRead();

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

fs.Read(MyData, 0, System.Convert.ToInt32(fs.Length));

fs.Close();

cmd.Parameters["blob"].Value = MyData;

cmd.Parameters["sn"].Value = 1;

try

{

int result = cmd.ExecuteNonQuery();

if (result < 1)

&nbsp

相关文档：