CLOB与BLOB存储

CLOB:

 public static string Update_Clob(string strTable, string strFieldName, string strWhere, string strText)
        {
            try
            {
                string strCon = SlnFactoryJ.OracleConnectionPool.GetConnectionString();
                OracleConnection Con = new System.Data.OracleClient.OracleConnection(strCon);
                Con.Open();

                string cmdText = " update " + strTable + " set " + strFieldName + " =   :pb  " + strWhere;
                OracleCommand cmd = new OracleCommand(cmdText, Con);
                OracleParameter op = new OracleParameter("pb", OracleType.Clob);
                op.Value = strText;
                cmd.Parameters.Add(op);
                cmd.ExecuteNonQuery();
                Con.Close();
            }
            catch (Exception ex)
            {
                return ex.Message;
            }
            return "";
        }

BLOB:
   private string SaveByte(string strTableName, string strFiledName, string strWhere, byte[] bytFileUpload, int intFileLength)
        {
            string strCon = SlnFactoryJ.OracleConnectionPool.GetConnectionString();
            string cmdText = "Update " + strTableName + " set " + strFiledName + "=? " + strWhere;
            OleDbConnection connection = new OleDbConnection("Provider=OraOLEDB.Oracle;" +strCon );
            try
            {
                connection.Open();
                OleDbCommand command = new OleDbCommand(cmdText, connection);
                command.Parameters.Add(strFiledName, OleDbType.VarBinary, intFileLength, strFiledName).Value = bytFileUpload;
                command.ExecuteNonQuery();
                connection.Close();
            }
            catch (Exception exception)
            {
                return exception.Message;
            }
            return "";
        }

转载于:https://www.cnblogs.com/j6043157/archive/2009/08/19/1549858.html