ORACLE中存取4000字节以上大文本类型可以用此数据类型,其在C#中的读写方法如下:$ |; }- c7 B z2 } Z& I) R8 r
注意需要引用 System.Data.OracleClient2 a; ?0 S8 N$ b' C+ A! S, a
然后添加命名空间:using System.Data.OracleClient
+ s: V. X8 s6 _: u" f5 D ORALCE建库脚本:
* s7 U% e3 F1 Q0 `9 [ CREATE TABLE TEST
7 Q% c% q9 }8 Z" L2 X4 q (
3 l, ^2 I- t6 [7 O! H9 ]4 _ AGREEMENT_ID CHAR(3) NOT NULL,
( M; o. j9 A1 S; J! O! l; P AGREEMENT_CONTENT LONG NULL
2 Y* C/ ]% k: w6 d )8 S" S4 {9 U5 [( q: F! L
插入数据:, J% R+ d0 C5 l' }- Y6 P( S9 X
protected void Button1_Click(object sender, EventArgs e)
" y) d; E. V0 S2 M C4 N! I: b$ } {9 y: v% N: W% H. f6 O. n
OracleConnection conn = new OracleConnection(@"Password=XXXXXX;User ID=hk;Data Source=wealth;Persist Security Info=True");
# L. r1 J& m0 h2 V conn.Open();( I! p4 l9 |+ Z: T! y, n
OracleCommand cmd = new OracleCommand("Select * From TEST", conn);
; F6 n2 p1 H( k# P2 b, _& V6 e string sql = "Insert Into TEST (AGREEMENT_ID, AGREEMENT_CONTENT) Values(:P_ID, :P_Value)";$ ]" _1 t: N" g' x
cmd.CommandText = sql;' s, @# T7 h. h9 o0 g
cmd.Parameters.Add("P_ID", this.TextBox2.Text);* `. i4 l3 @7 @. E4 A
cmd.Parameters.Add("P_Value", this.TextBox1.Text);# i' G8 y0 e6 N l
cmd.ExecuteNonQuery();+ O1 O1 T# h8 T1 e. y C5 }
conn.Close();
# I( a3 _1 V% ?' q }
1 ~% m4 \$ z6 d J" Q/ H 读取数据:( ?% t% K' ~$ V4 q H- p2 a: ^
protected void Button2_Click(object sender, EventArgs e)7 g1 `/ I" p3 p m$ k
{5 L1 F- \7 v# i8 ~- a
OracleConnection conn = new OracleConnection(@"Password=XXXXXX;User ID=hk;Data Source=wealth;Persist Security Info=True");/ u# W$ g; _* M# Y/ P
conn.Open();7 K- t" E+ _8 g* C6 K! k4 i J/ Y
string sql = "Select * From TEST where AGREEMENT_ID = :P_ID";
9 P. I1 T9 s- F# ` OracleDataAdapter da = new OracleDataAdapter(sql, conn);
' L+ M$ F2 Q$ } da.SelectCommand.Parameters.Add("P_ID", this.TextBox2.Text);$ w: Z5 [$ a8 B# `
DataSet ds = new DataSet(); V3 C4 s. F2 K3 T2 h3 R3 Y
da.Fill(ds);5 R1 H) R1 _7 H) m! a
this.TextBox1.Text = ds.Tables[0].Rows.Count.ToString();8 T1 ~* h' M. t
this.TextBox1.Text = ds.Tables[0].Rows[0]["AGREEMENT_CONTENT"].ToString();; Y0 \+ G0 O- O0 O# H- ~ a
conn.Close();
5 y1 `; y7 O8 V& o7 J- X) P } |