ORACLE中存取4000字节以上大文本类型可以用此数据类型,其在C#中的读写方法如下:7 x' M2 w2 ]& s$ a1 l/ F. n
注意需要引用 System.Data.OracleClient
- g: H0 b2 z- U" U7 { 然后添加命名空间:using System.Data.OracleClient* h3 N" ^# f5 k9 u8 s5 r2 ^
ORALCE建库脚本:9 l( K2 A& x0 z, Z
CREATE TABLE TEST$ ?, o- I5 G, w3 K2 S0 v; o0 ^
(
5 s( t- L8 \. _0 D. e AGREEMENT_ID CHAR(3) NOT NULL,8 N" O7 z& H6 h! T7 ^8 I) Y
AGREEMENT_CONTENT LONG NULL K z4 ?/ s1 N0 [0 Q
)
. y4 {5 c7 ~: K. @, t 插入数据:4 X% N4 e5 x3 E' f
protected void Button1_Click(object sender, EventArgs e)
' a4 {" T( A; r1 H. A9 ` {
; s% E% g* y4 @ {$ I OracleConnection conn = new OracleConnection(@"Password=XXXXXX;User ID=hk;Data Source=wealth;Persist Security Info=True");
) y5 _& B7 _# J4 \1 z3 [! K; f conn.Open();
( Z5 B" p3 k: x1 r9 s6 t+ _) Q$ u OracleCommand cmd = new OracleCommand("Select * From TEST", conn); A" b. [/ p9 e% x
string sql = "Insert Into TEST (AGREEMENT_ID, AGREEMENT_CONTENT) Values(:P_ID, :P_Value)";3 d3 L$ @' p. w* L1 a8 M0 e- J
cmd.CommandText = sql;& h& V& @$ |# d1 C1 x& m' n
cmd.Parameters.Add("P_ID", this.TextBox2.Text);9 l z F Y% }9 R+ `
cmd.Parameters.Add("P_Value", this.TextBox1.Text);
! Z/ u2 U; ~$ k( M3 { Y cmd.ExecuteNonQuery();
$ L% V7 b2 v. `2 V+ _ conn.Close();' S) N, ~/ \% Q6 L- T7 n
}* b. Z* P7 k; `* x' w
读取数据:
) g! ~5 R: ^/ \3 ?) Y9 W: `+ } d, f protected void Button2_Click(object sender, EventArgs e) X7 U- L) |6 G& }( m9 o
{
2 x. t6 N8 K7 `+ v) H( R OracleConnection conn = new OracleConnection(@"Password=XXXXXX;User ID=hk;Data Source=wealth;Persist Security Info=True");
( s1 \# K" A2 S5 d, z conn.Open();
( [, r# e3 l8 K5 H7 i% F: u/ j0 T& D! | string sql = "Select * From TEST where AGREEMENT_ID = :P_ID";
7 u7 \ b- Q, A6 z# Q, P: q OracleDataAdapter da = new OracleDataAdapter(sql, conn);3 h f9 R1 H$ U- U7 [
da.SelectCommand.Parameters.Add("P_ID", this.TextBox2.Text);; E0 W) @: L; _. S5 k, v2 t: ?
DataSet ds = new DataSet();
2 z' W, F5 k7 o0 [( f3 R; ?* A da.Fill(ds);
% Q; H4 o6 w) [, d H! x this.TextBox1.Text = ds.Tables[0].Rows.Count.ToString();
+ o; g, i: e: \" [+ A9 m! b/ G this.TextBox1.Text = ds.Tables[0].Rows[0]["AGREEMENT_CONTENT"].ToString();3 t% v5 E7 @( ]$ y( ]
conn.Close(); K( W2 [- _7 S1 N
} |