将文件（word，excel等）存入oracle的一个字段

 string title = "1112"; //文件标题
        int filelength = fileup.PostedFile.ContentLength; //获取HtmlInputFile控件中上载文件的长度
        byte[] uploadbuffer = new byte[filelength]; //设置缓存
       Stream filestream = fileup.PostedFile.InputStream;
      
        filestream.Read(uploadbuffer, 0, filelength);     
    
        string strSQL = "insert into exceltodb (fileid,DOC,FILETYPE) values (:fileid,:doc,:filetype)";
  //fileid 为varchar2,doc为blob,filetype为varchar2
        OracleConnection oconn = new OracleConnection(db.pcsConnectionString);
        oconn.Open();
        OracleCommand ocmd = new OracleCommand(strSQL,oconn);
    
        ocmd.Parameters.Add("fileid",OracleType.VarChar);
        ocmd.Parameters.Add("doc", OracleType.Blob);
        ocmd.Parameters.Add("filetype", OracleType.VarChar);
        ocmd.Parameters[0].Value = title;
        ocmd.Parameters[1].Value = uploadbuffer;
        ocmd.Parameters[2].Value = "application/ms-excel";
        ocmd.ExecuteNonQuery();
        oconn.Close();
 另oledb连接字符串 OleDbConnection objConnection = new OleDbConnection("Provider=MSDAORA;Data Source=dbsrv;user id=uid;password=psw;persist security info=false;");
根据csdn上相关文章改写
下面继续研究如何读出来，有结果了post在下一篇

转载于:https://www.cnblogs.com/yeskele/archive/2006/03/13/349219.html