//Create Transaction object and use test to check sql result.
//If result is bad then use rollback method
//uses System.Data.Common
//Create connection

object DbConnection myConn = myDB.CreateConnection();

Using (myConn)
{
 myConn.Open();
 DbTransaction myTran = myConn.BeginTransaction();
 cmdInsert.Connection = myConn;
 cmdInsertt.Transaction = myTran;
 cmdInsert.ExecuteNonQuery();
 mastID = Convert.ToInt32(cmdInsert.Parameters["@RecordID"].Value);

 if (mastID > 0 )
 {
  myTran.Commit();
 }
 else
 {
  myTran.Rollback();
 }
}