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
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
上面的代码是不是没有从DC_REPORT_SUM中的第一条记录开始导入??如果是,应该怎样写??
改为采用类似UpdateCommand.ExecuteNonQuery()之类的。