加了以后最后的SQL语句跟踪出来是这样的:
insert into Ccme_Form_Allot(CFA_BaseId,CFA_ColumnId,CFA_Row,CFA_Col,CFA_Type,CFA_Obiect,CFA_Attrib,CFA_IsNull) values(10000069,10000053,1,1,'10','10','10','0');\r\n insert into Ccme_Form_Allot(CFA_BaseId,CFA_ColumnId,CFA_Row,CFA_Col,CFA_Type,CFA_Obiect,CFA_Attrib,CFA_IsNull) values(10000069,10000054,1,2,'10','10','10','0');\r\n insert into Ccme_Form_Allot(CFA_BaseId,CFA_ColumnId,CFA_Row,CFA_Col,CFA_Type,CFA_Obiect,CFA_Attrib,CFA_IsNull) values(10000069,10000055,2,1,'10','10','10','0');\r\n 然后就报错了
insert into Ccme_Form_Allot(CFA_BaseId,CFA_ColumnId,CFA_Row,CFA_Col,CFA_Type,CFA_Obiect,CFA_Attrib,CFA_IsNull) values(10000069,10000053,1,1,'10','10','10','0');\r\n insert into Ccme_Form_Allot(CFA_BaseId,CFA_ColumnId,CFA_Row,CFA_Col,CFA_Type,CFA_Obiect,CFA_Attrib,CFA_IsNull) values(10000069,10000054,1,2,'10','10','10','0');\r\n insert into Ccme_Form_Allot(CFA_BaseId,CFA_ColumnId,CFA_Row,CFA_Col,CFA_Type,CFA_Obiect,CFA_Attrib,CFA_IsNull) values(10000069,10000055,2,1,'10','10','10','0');\r\n 然后就报错了
解决方案 »
- C# 下读写INI的最简单方法
- 查询oracle数据库出现not all variables bound的问题
- region代码规范问题.
- 几个有关C#操作WORD的问题
- SQL查询问题,按要求GROUP BY以后,列出统计表。
- 存储过程--??? 上面那个地方错了!
- 求workflow设计器源码(C#,winform)
- DevExpress 中 XtraTabbedMdiManager 用法
- 菜鸟学习C#-Web应用程序入门经典
- C#能开发远程实时监控系统吗?和PLC通信。请各问大侠谈谈自己的看法,帮帮小弟。
- 如何创建一个字段,允许空字符串(不是允许为空,而是允许零长度的字符串)
- 祝大家中秋节快乐!能否帮我解决一下这个问题!
for(i=0;i<Str_Arr.Length;i++)
{
Str_Sql = Str_Sql + Str_Arr[i].ToString() + ";\r\n ";
}以后就出现了上面的情况
insert into temp(a,b) select '1','2' union all select '1','2' union all select '1','2'
问题在这。你看看程序传给 DBMS 的SQL字符串就明白了。楼主试一下,放一个richedit,把生成的str_sql放在里面,再把里面的sql执行,那样就没有 \n\r了。
{
try
{
OracleCommand oracleCmd = new OracleCommand();
OracleTransaction oracleTrans = null;
try
{
oracleConn.Open();
oracleTrans = oracleConn.BeginTransaction(IsolationLevel.Serializable );
oracleCmd.Connection = oracleConn;
oracleCmd.CommandType = CommandType.Text;
oracleCmd.Transaction = oracleTrans;
for (int i=0;i<oracleQuery.Length;i++)
{
oracleCmd.CommandText = oracleQuery[i];
oracleCmd.ExecuteNonQuery();
}
oracleTrans.Commit();
oracleTrans.Dispose();
oracleConn.Close();
oracleCmd.Dispose();
oracleTrans = null;
oracleCmd = null;
oracleConn = null;
}
catch(Exception ex)
{
if(oracleTrans != null)
oracleTrans.Rollback();
try
{
oracleTrans.Dispose();
oracleTrans = null;
}
catch
{
oracleTrans = null;
}
try
{
oracleConn.Close();
oracleConn = null;
}
catch
{
oracleConn = null;
}
try
{
oracleCmd.Dispose();
oracleCmd = null;
}
catch
{
oracleCmd = null;
}
throw ex;
}
}
catch(Exception ex)
{
throw ex;
}
}