SqlTransaction trans = objConn.BeginTransaction(IsolationLevel.ReadCommitted);

SqlTransaction trans = objConn.BeginTransaction(IsolationLevel.ReadCommitted);

while (loop) {
     obj.ExecuteNonQuery();
}

try {
     e.Success = true;
     trans.Commit();
}
catch (Exception ex)
{
     e.Success = false;
     e.ErrorMessage = ex.Message;
     trans.Rollback();
}