C#.net向oracle的blob欄位插入檔案

新鮮出爐的代碼

        private Boolean ImportGatherFile(string BlobFileFolder, string Xqdm, string Xqmc)
        {
            try
            {
                System.IO.FileStream fs = null;

                string[] blobFiles = Directory.GetFiles(BlobFileFolder);
                if (blobFiles.Length == 0)
                    return false;
                for (int i = 0; i < blobFiles.Length; i++)
                {
                    //檔案流
                    string pPath = blobFiles[i];
                    fs = new System.IO.FileStream(pPath, FileMode.Open,FileAccess.Read );
                    Byte[] blob = new Byte[fs.Length];
                    fs.Read(blob, 0, blob.Length);
                    fs.Close();
                    //最大ID
                    int intMaxOID = GetMaxOID("Tablea", "F_OID");
                    //擷取當前年代
                    string strYear = DateTime.Now.Year.ToString().Substring(0, 4);
                    //檔案名稱
                    string pFileName;
                    pFileName = pPath.Substring(pPath.LastIndexOf("//")+1);

                    OracleParameter param = null;
                    OracleCommand cmd = null;
                    cmd = mPropConnection.CreateCommand(); //mPropConnection是OracleConnection類型變數
                    cmd.CommandText = "insert into Tablea(F_OID,F_XZQHDM,F_XZQHMC,F_FILENAME,F_FILE,F_YEAR) VALUES("+intMaxOID +",'" + Xqdm + "','" + Xqmc + "','"+pFileName+"',:Doc,'"+strYear+"')";
                    param = new OracleParameter("Doc", OracleType.Blob, blob.Length, ParameterDirection.Input, false, 0, 0, null, DataRowVersion.Current, blob);
                    cmd.Parameters.Add(param);
                    cmd.ExecuteNonQuery();
                }
                return true;
               
            }
            catch (Exception ex)
            {
                return false;
            }
        }

應該注意的問題

1.FileStream讀取檔案的代碼;

2.命令變數(cmd )的參數";Doc"在oracle中用:在sql資料庫中應該用@;

3.命令參數變數(param )中,參數只用"Doc"不加冒號了,至於sql中是否應該用@暫時未測試,晚上看的代碼好像需要加

4.命令參數變數(param )的類型,OracleType.Blob表示插入的類型.試過用oledb串連來完成此功能,只可惜沒有找到合適的插入類型.