System.Data.DataTable.RejectChanges C# (CSharp) Метод

RejectChanges() публичный Метод

Rolls back all changes that have been made to the table since it was loaded, or the last time was called.
public RejectChanges ( ) : void
Результат void
        public void RejectChanges()
        {
            long logScopeId = DataCommonEventSource.Log.EnterScope("<ds.DataTable.RejectChanges|API> {0}", ObjectID);
            try
            {
                DataRow[] oldRows = new DataRow[Rows.Count];
                Rows.CopyTo(oldRows, 0);

                for (int i = 0; i < oldRows.Length; i++)
                {
                    RollbackRow(oldRows[i]);
                }
            }
            finally
            {
                DataCommonEventSource.Log.ExitScope(logScopeId);
            }
        }

Usage Example

 public static void GrabarArticulosAgrupar(DataTable tblStock, DataTable tblArticulos, ref int? codigoError)
 {
     MySqlTransaction tr = null;
     try
     {
         MySqlConnection SqlConnection1 = DALBase.GetConnection();
         tr = SqlConnection1.BeginTransaction();
         DAL.ArticulosDAL.BorrarArticulosAgrupar(tblArticulos, SqlConnection1, tr);
         DAL.StockDAL.Update(tblStock, SqlConnection1, tr);
         tr.Commit();
         SqlConnection1.Close();
     }
     catch (MySqlException ex)
     {
         switch (ex.Number)
         {
             case 1042: //Unable to connect to any of the specified MySQL hosts.
                 tblStock.RejectChanges();
                 tblArticulos.RejectChanges();
                 codigoError = 1042;
                 break;
             case 0: // Procedure or function cannot be found in database
                 tblStock.RejectChanges();
                 tblArticulos.RejectChanges();
                 codigoError = ex.Number;
                 break;
             default:
                 tblStock.RejectChanges();
                 tblArticulos.RejectChanges();
                 if (tr != null)
                 {
                     tr.Rollback();
                 }
                 codigoError = ex.Number;
                 break;
         }
     }
     catch (TimeoutException)
     {
         codigoError = 8953; // El número 8953 lo asigné al azar
     }
     catch (NullReferenceException)
     {
         codigoError = 8954; // El número 8954 lo asigné al azar
     }
     catch (Exception)
     {
         codigoError = 8955; // El número 8955 lo asigné al azar
     }
 }
All Usage Examples Of System.Data.DataTable::RejectChanges
DataTable