把文件插入到数据库中出错
byte[] bs;
FileStream fs = new FileStream(@"e:\BLOCK.blk",FileMode.Open, FileAccess.Read);
bs = new byte[fs.Length];
fs.Read(bs,0,bs.Length);
OracleConnection conn = new OracleConnection("Data Source=ALLAN;User Id=LY;Password=usoft;Integrated Security=no;");
conn.Open();
OracleCommand command = new OracleCommand("INSERT INTO 油气勘查登记(区域坐标) VALUES(@区域坐标)",conn);
OracleParameter paramData = new OracleParameter("@区域坐标",OracleType.Clob);
paramData.Value = bs;
command.Parameters.Add(paramData);
command.ExecuteNonQuery();
fs.Close();
conn.Close();
基本思想就是,读取本地的一个文件,然后把他插入到数据库中,可是报错
“对象必须实现IConvertible”