转载: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();
        }