C#向oracle插入文章

1
2
3
4
5
6
7
8
9
10
//利用传参数

OracleConnection Con = new System.Data.OracleClient.OracleConnection(strCon);Con.Open();  

//自己用时,替换自己的sql语句                

string cmdText="insert into xmgl_wd(pk_wdbh,wdmc,lbbh,wdnr,wdfjdz,wdsj,istj) values (XMGL_WD_SEQ.Nextval,'"+wdmc+"','"+lbbh+"',:pb,'"+wdfjdz+"',"+str_add_wdsj+",'"+istj+"')";

OracleCommand cmd = new OracleCommand(cmdText,Con);

OracleParameter op = new OracleParameter("pb",OracleType.Clob);

op.Value = wdnr;

cmd.Parameters.Add(op);

cmd.ExecuteNonQuery();

Con.Close();

1
2
3
4
5
6
7
OracleConnection Con = ysdb.m_oracleCon;

msql = string.Format("update TB_BJ_ARTICLE SET ACONTENT = ':pb' WHERE ID = '{0}'", ysdataRow["ID"]);

OracleCommand cmd = new OracleCommand(msql, Con);

OracleParameter op = new OracleParameter("pb", OracleDbType.Clob);

op.Value = ACONTENT;

cmd.Parameters.Add(op);

cmd.ExecuteNonQuery();