c#中clob转换为string

Question

怎么将clob转换为 string

Answer 1

参考代码：
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();
        }c#操作clob  
using System;namespace InsertingCLOB
{
    public class clsOracle
    {     
        private System.Data.OracleClient.OracleConnection connOracle;
        private System.Data.OracleClient.OracleDataReader rstOracle;
        private System.Data.OracleClient.OracleCommand sqlCommandOracle;
        private System.Data.OracleClient.OracleTransaction txn; 
        private System.Data.OracleClient.OracleLob clob;            
        public clsOracle()    
        {
   string p_conn_db= "Data Source=" + OracleIP + ";User ID=" + OracleUserName + ";PASSWORD=" + OraclePassword + ";";    
            connOracle = new System.Data.OracleClient.OracleConnection(p_conn_db);    
            connOracle.Open();
        }        
public void InsertRecord(string SQLStatement)
{ 
   if (SQLStatement.Length>0)
   {
    if(connOracle.State.ToString().Equals("Open"))
    { 
     sqlCommandOracle = new System.Data.OracleClient.OracleCommand(SQLStatement,connOracle);
     sqlCommandOracle.ExecuteScalar(); 
    }
   }
}
public void InsertCLOB(string SQLStatement, string str)    
    {                     
        if(SQLStatement.Length>0)                     
        {                             
            if(connOracle.State.ToString().Equals("Open")) 
            {                        
                byte[] new = System.Text.Encoding.Unicode.GetBytes(str); 
                sqlCommandOracle=newSystem.Data.OracleClient.OracleCommand(SQLStatement,connOracle);                             
                rstOracle = sqlCommandOracle.ExecuteReader(); 
                rstOracle.Read();                             
                txn = connOracle.BeginTransaction();                 
                clob = rstOracle.GetOracleLob(0);                      
                clob.Write(new, 0, new.Length);                        
                
                txn.Commit();                     
            }                             
        }          
    }
     public void CloseDatabase()         
    {         connOracle.Close(); 
         connOracle.Dispose();       
     }           
private void btnSave_Click(object sender, System.EventArgs e)
{
clsOracle db=new clsOracle();  // example for primary key 
string field_id = "1";   
// insert 2 characters for addresing 
string field_temp = "XX";string sql = "Insert into table_nm s('" + field_id + "', '" + field_temp + "')"; 
db.InsertRecord(sql);sql="select news_text from table_nm +
"WHERE field_nm'" + field_id + "' FOR UPDATE";
    
db.InsertCLOB(sql, txtCLOBData.Text.ToString()); 
db.CloseDatabase();
}