62,243
社区成员




//利用传参数
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();