调试易

this.oracleConnection1.Open();
this.oracleDataAdapter1.Fill(dataSet11,"DC_REPORT_SUM");
this.oracleConnection2.Open();
this.oracleDataAdapter2.Fill(dataSet11,"L2_DC_REPORT_SUM");for (int i = 0 ; i < this.dataSet11.Tables["DC_REPORT_SUM"].Rows.Count ; i++)
{
    DataRow r = this.dataSet11.Tables["L2_DC_REPORT_SUM"].NewRow();
    r["COILNO"] = this.dataSet11.Tables["DC_REPORT_SUM"].Rows[i]["COILNO"];
    r["SRTNO"] = this.dataSet11.Tables["DC_REPORT_SUM"].Rows[i]["SRTNO"];
    this.dataSet11.Tables["L2_DC_REPORT_SUM"].Rows.Add(r);
}this.oracleDataAdapter2.Update(dataSet11,"L2_DC_REPORT_SUM");  //出错：ora-00001违反唯一约束条件 
this.oracleConnection2.Close();
this.oracleConnection1.Close();
   我要将DC_REPORT_SUM的数据全部导入L2_DC_REPORT_SUM中，DC_REPORT_SUM的数据有上万条，L2_DC_REPORT_SUM与DC_REPORT_SUM的字段COILNO为UNIQUE，COILNO在L2_DC_REPORT_SUM中还为PRIMARY KEY，但执行到this.oracleDataAdapter2.Update(dataSet11,"L2_DC_REPORT_SUM"); 出错：ora-00001违反唯一约束条件 ，但导入成功1094条数据，dataSet11中的表都没有设置KEY