请问{孟子e章},SqlDataAdapter.upDate的事务处理问题??
SqlDataAdapter MyDataAdapter;
MyDataAdapter=new SqlDataAdapter (SqlStr,CommConnection);
SqlCommandBuilder MyBuilder=new SqlCommandBuilder(MyDataAdapter) ;
DataSet MyDataSet2=new DataSet ();
//开始事务处理
SqlTransaction MyTrans1;
MyTrans1=CommConnection.BeginTransaction ();
try
{
MyTrans1=MyDataAdapter2.InsertCommand.Transaction ; //
MyDataAdapter.Fill (MyDataSet,"tmptable");
.......
MyDataAdapter.Update (MyDataSet);
MyTrans1.Commit ();
}
catch
{
MyTrans1.Rollback();
}
执行到 MyTrans1=MyDataAdapter2.InsertCommand.Transaction ;时出错,
提示" 未将对象引用设置到对象的实例";
请问如何解决?
****************************
SqlDataAdapter.upDate的事务处理与SqlCommand的事务处理有何区别?