oracle怎么截取long类型,ORACLE中存取LONG类型字段的方法

ORACLE中存取LONG类型字段的方法以下文字资料是由(历史新知网www.lishixinzhi.com)小编为大家搜集整理后发布的内容，让我们赶快一起来看一下吧！

ORACLE中存取 字节以上大文本类型可以用此数据类型 其在C#中的读写方法如下

注意需要引用 System Data OracleClient

然后添加命名空间 using System Data OracleClient

ORALCE建库脚本

CREATE TABLE TEST

(

AGREEMENT_ID CHAR( ) NOT NULL

AGREEMENT_CONTENT LONG NULL

)

插入数据

protected void Button _Click(object sender EventArgs e)

{

OracleConnection conn = new OracleConnection(@ Password=XXXXXX;User ID=;Data Source=wealth;Persist Security Info=True );

conn Open();

OracleCommand cmd = new OracleCommand( Select * From TEST conn);

string sql = Insert Into TEST (AGREEMENT_ID AGREEMENT_CONTENT) Values(:P_ID :P_Value) ;

cmd CommandText = sql;

cmd Parameters Add( P_ID this TextBox Text);

cmd Parameters Add( P_Value this TextBox Text);

cmd ExecuteNonQuery();

conn Close();

}

读取数据

protected void Button _Click(object sender EventArgs e)

{

OracleConnection conn = new OracleConnection(@ Password=XXXXXX;User ID=;Data Source=wealth;Persist Security Info=True );

conn Open();

string sql = Select * From TEST where AGREEMENT_ID = :P_ID ;

OracleDataAdapter da = new OracleDataAdapter(sql conn);

da SelectCommand Parameters Add( P_ID this TextBox Text);

DataSet ds = new DataSet();

da Fill(ds);

this TextBox Text = ds Tables[ ] Rows Count ToString();

this TextBox Text = ds Tables[ ] Rows[ ][ AGREEMENT_CONTENT ] ToString();

conn Close(); lishixinzhi/Article/program/Oracle/201311/18871

分页：123