转载:C#读取clob

转载的.....C#读取Clob数据并转换为字符串：

using System.Data.OracleClient;
using System.IO;
using System.Text;

         int  actual  =   0 ;

         // this.FreeTextBox1.Text = "<FONT color=#ffc0cb>this is as test</FONT>";
        OracleConnection conn  =   new  OracleConnection( " Data Source=INFOPLAT;User ID=infomanager;Password=admin; " );
        OracleCommand cmd  =   new  OracleCommand();

        cmd.Connection  =  conn;
        String strSql  =   " SELECT 相关链接 FROM xxtable where SN='88' " ;

        cmd.CommandText  =  strSql;

        cmd.CommandType  =  CommandType.Text;

         try
         ... {
            conn.Open();

            OracleDataReader reader = cmd.ExecuteReader();

            while (reader.Read())
            ...{

                OracleLob myOracleClob = reader.GetOracleLob(0);

                StreamReader streamreader = new StreamReader(myOracleClob, Encoding.Unicode);
                char[] cbuffer = new char[100];
                while ((actual = streamreader.Read(cbuffer, 0, cbuffer.Length)) > 0)
                ...{
                    String test = new string(cbuffer, 0, actual);
                    FreeTextBox1.Text = test;
                }
                


                break;
            }

        }
         catch  (Exception ex)
         ... {

        }
         finally
         ... {
            // 释放占有资源
            conn.Close();
        }