public void registrarAprobacionCuc(System.Data.DataTable dtParticipes) { AprobacionCUCDA da = new AprobacionCUCDA(); SqlConnection cn = GetConnection(); cn.Open(); SqlTransaction trans = cn.BeginTransaction(IsolationLevel.ReadUncommitted); try { foreach (DataRow dr in dtParticipes.Rows) { if (dr["ESTADO"] == "MOD") { da.ActualizarAprobacionParticipe(dr, codigoUsuario, cn, trans); } } trans.Commit(); } catch (Exception ex) { trans.Rollback(); throw ex; } finally { cn.Close(); cn.Dispose(); } }