首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > .NET > C# >

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

2012-04-25 
dataadapter.update()中使用事务的问题?private void initTable()//初始化表格!{OracleConnection oracn

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

热点排行