dataadapter.update()中使用事务的问题?
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();也不行!

为什么?



[解决办法]
OracleDataAdapter orada = new OracleDataAdapter("select assemble_id,class_id,class_pid,memo,autoid from element_assemble_child where 1=2", oracn);

[解决办法]

C# code

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();            }