SqlTransaction myTrans = SqlConn.BeginTransaction(); HeaderCmd = poh.InsertCommand; HeaderCmd.Transaction = myTrans; if(poh.UpdateInsertdata(HeaderCmd, Header)) { DetailsCmd = pod.InsertCommand; DetailsCmd.Transaction = myTrans; if(pod.UpdateInsertData(DetailsCmd, Details)) GoodTrans= true; } if(GoodTrans) myTrans,Commit(); else myTrans.Rollback();Both of these command share the same transaction.
The ROLLBACK TRANSACTIOn request has no corresponding BEGIN TRANSACTION.Anyone have a clue?