110,534
社区成员
发帖
与我相关
我的任务
分享
ConnString = GetConnString();
OracleConnection connection = new OracleConnection(ConnString);
connection.Open();
string sql = "insert into \"CLIDB\" (ID_,DEVCODE,KKMC,CDMC,KKBH) values (auto_ID.nextval,:DEVCODE,:KKMC,:CDMC,:KKBH)";
String sqlinsert = sql;
OracleCommand oracleCommand = getoracleCommand(sqlinsert, connection);
OracleParameter[] para =
{
new OracleParameter ("DEVCODE", OracleType.VarChar,125),
new OracleParameter (":KKMC", OracleType.VarChar ,255),
new OracleParameter ("CDMC", OracleType.VarChar,255),
new OracleParameter ("KKBH", OracleType.VarChar,20),
new OracleParameter ("FXLX", OracleType.VarChar,20)
};
para[0].Value = Info.devcode;
para[1].Value = Info.kkmc;
para[2].Value = Info.cdmc;
para[3].Value = Info.kkbh;
para[4].Value = Info.fxlx;
for (int i = 0; i < para.Length; i++)
{
oracleCommand.Parameters.Add(para[i]);
}
getoracleInsert(oracleCommand);
/// <summary>
/// 插入Oracle数据
/// </summary>
/// <param name="oracleCommand"></param>
private static bool intoScc = false;
public static void getoracleInsert(OracleCommand oracleCommand)
{
try
{
oracleCommand.ExecuteNonQuery();
intoScc = true;
}
catch (Exception ex)
{
intoScc = false;
String message = ex.Message;
WriteMessage("插入数据失败了!" + message);
}
}