通过DataTable更新数据

        DbConnection _conn = conn();
        //要往这个表里添加记录
        OracleDataAdapter dpt = new OracleDataAdapter("select c,b,a from syscopy.test where 1<>1 ", (OracleConnection)_conn.Connectobject);
(OracleConnection)_conn.Connectobject);
        OracleCommandBuilder builder = new OracleCommandBuilder(dpt);
        DataTable dt = new DataTable();     
       dpt.FillSchema(dt,SchemaType.Mapped);


        //从另一个表里取数据
        DataSet ds1 = new DataSet();
        OracleDataAdapter dpt1 = new OracleDataAdapter("select c,b,a from syscopy.test1 where a in('6','7') ",(OracleConnection)_conn.Connectobject);
        dpt1.Fill(ds1, "table1");
       
        //Adding
        DataRow row = dt.NewRow();
        row.ItemArray = ds1.Tables["table1"].Rows[0].ItemArray;
        dt.Rows.Add(row);
        DataRow row1 = dt.NewRow();
        row1.ItemArray = ds1.Tables["table1"].Rows[1].ItemArray;
        dt.Rows.Add(row1);    

  　 //Update和AcceptChanges
        try
        {
            dpt.Update(dt);//只能更新
            dt.AcceptChanges();//dt.HasErrors
        }
        catch (OracleException e)
        { Console.Out.Write(e.ToString()); }

       //清一下dt,重新添充，看数据库里的记录增加了没
        dt.Clear();
        dpt.SelectCommand = new OracleCommand("select * from syscopy.test",(OracleConnection)_conn.Connectobject);
        dpt.Fill(dt);
        Console.WriteLine("table count:" + dt.Rows.Count);
        Console.Read();