dataadapter.update()中使用事务的问题?

Question

 private void initTable()  //初始化表格!
        {
            OracleConnection oracn = new OracleConnection(_connString);
            orada = new OracleDataAdapter("select assemble_id,class_id,class_pid,memo,autoid from element_assemble_child where 1=2", oracn);
            oracb = new OracleCommandBuilder(orada);
            orada.Fill(ds);
            this.dataGridView1.DataSource = ds.Tables[0];
        }private void Save()  //保存表格
        {
            OracleConnection oracn =new  OracleConnection(_connString);
            OracleCommand oracmd = new OracleCommand();
            oracmd.Connection = oracn;
            oracn.Open();
            OracleTransaction oratran = oracn.BeginTransaction();
            oracmd.Transaction = oratran;
            orada.UpdateCommand.Transaction = oratran;            orada.InsertCommand.Transaction = oratran;
            orada.DeleteCommand.Transaction = oratran;
            try            {
               
                oracmd.CommandText = "insert into element_assemble(assemble_id,assemble_name,memo) values('" + tbx_id.Text + "','" + tbx_name.Text + "'" +
                    ",'" + memo.Text + "')";
                
                oracmd.ExecuteNonQuery();              
              
                orada.Update(ds.Tables[0]);
                oratran.Commit();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
                oratran.Rollback();
            }
}为什么会报错呢?在红色字体处报错!提示没有将对象实例化!
难道updatecommand还要手工指定吗?
在红色字体上方添加orada.UpdateCommand = oracb.GetUpdateCommand();
            orada.InsertCommand = oracb.GetInsertCommand();
            orada.DeleteCommand = oracb.GetInsertCommand();也不行!为什么?

Answer 1

OracleDataAdapter orada = new OracleDataAdapter("select assemble_id,class_id,class_pid,memo,autoid from element_assemble_child where 1=2", oracn); 

Answer 2

OracleConnection oracn = new OracleConnection(_connString);
            OracleCommand oracmd = new OracleCommand();
            oracmd.Connection = oracn;
            oracn.Open();
            OracleTransaction oratran = oracn.BeginTransaction();
            oracmd.Transaction = oratran;
            orada.Connection = oracn;
            orada.Command = oracmd;
            //orada.UpdateCommand.Transaction = oratran;            orada.InsertCommand.Transaction = oratran; 
            //orada.DeleteCommand.Transaction = oratran;             try
            {                oracmd.CommandText = "insert into element_assemble(assemble_id,assemble_name,memo) values('" + tbx_id.Text + "','" + tbx_name.Text + "'" +
                    ",'" + memo.Text + "')";                //这个地方怎么进行了两次插入操作？？？？
                oracmd.ExecuteNonQuery();                orada.Update(ds.Tables[0]);
                oratran.Commit();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
                oratran.Rollback();
            } 

Answer 3

一个是主表一个是子表!
不一样的!
一个是element_assemble,一个是element_assemble_child

Answer 4

sdfffffffffffffffffff

Answer 5

sfdddddddddddddddddd1234567
123r567890-