我有一个数组:short[] current = new short[2500];
现在想以BLOB类型将这个数组存入数据库,求解!

解决方案 »

  1.   

    http://www.developer.com/net/asp/article.php/10917_3761486_1/Working-with-Binary-Large-Objects-BLOBs-Using-SQL-Server-and-ADONET.htm
      

  2.   

    对了,说明一下,我是要存到ORACLE 10G里
      

  3.   

    将BLOB转化成base64字符,再将base64位字符转化unocde值存入到short数组中
      

  4.   


    string connString = "server=oratest;User ID=kttest;Password=test";
               using(conn = new OracleConnection(connString))
               {
                   try
                   {
                       conn.Open();
                       OracleCommand cmd = conn.CreateCommand();                   OracleTransaction transaction = cmd.Connection.BeginTransaction();
                       cmd.Transaction = transaction;                   cmd.CommandText = "select " + blob + " from " + tableName + " where " + id + " = " + idData + " FOR UPDATE";
                       OracleDataReader reader = cmd.ExecuteReader();
                       using(reader)
                       {
                           reader.Read();
                           OracleLob tempLob    = reader.GetOracleLob(0);                       //写
                           FileStream fs = new FileStream(fileName,FileMode.Open);
                           tempLob.BeginBatch(OracleLobOpenMode.ReadWrite);
                           int length = 10485760;
                           byte[] Buffer = new byte[length];
                           int i;
                           while((i = fs.Read(Buffer,0,length)) > 0)
                           {
                               tempLob.Write(Buffer,0,i);
                           }
                           fs.Close();
                           tempLob.EndBatch();
                           cmd.Parameters.Clear();
                       }                   transaction.Commit();
                   }
                   catch(Exception ex)
                   {
                       throw ex;
                   }
                   finally
                   {
                       conn.Close();
                   }
               }
    希望对你有帮助