备注：dt 为将要导入的数据 ，tablename 将要导入的表名

voidCZDataSource(DataTabledt,stringtablename)        {varsql =string.Format("select * from {0} ", tablename);using(OracleConnection con=newOracleConnection(DBHelp.dbConnectionString))            {                con.Open();                OracleTransaction tran = con.BeginTransaction();                OracleCommand cmd =newOracleCommand(sql, con);                OracleDataAdapter adapter =newOracleDataAdapter(cmd);                           cmd.Transaction = tran;try{DataTabledss =newDataTable();                    adapter.Fill(dss);                                      dss.Merge(dt);    // 数据合并                                adapter.UpdateBatchSize = 600;                    OracleCommandBuilder cb =newOracleCommandBuilder(adapter);DataTabledssfb = dss.GetChanges();if(dssfb !=null)                    {                        adapter.Update(dssfb); // 这里更新表的副本但是提示为null                     }else{                        adapter.Update(dss);                    }                    dss.AcceptChanges();                    tran.Commit();  My.ClientScript.Alert(this, "同步数据成功！");}catch(Exceptionex)                {                    tran.Rollback();   My.ClientScript.Alert(this, "同步数据失败！"+ex.Message.ToString());con.Close();                }            }         }