private static void PrintEventArgs(OracleRowUpdatedEventArgs args) { Console.WriteLine("OnRowUpdated"); Console.WriteLine(" event args: (" + " command=" + args.Command + " commandType=" + args.StatementType + " recordsAffected=" + args.RecordsAffected + " status=" + args.Status + ")"); }
private void OnOracleRowUpdated(object sender, OracleRowUpdatedEventArgs args) { if (args.RecordsAffected != 0 || args.Errors == null) { return; } args.Row.RowError = Resources.ExceptionMessageUpdateDataSetRowFailure; args.Status = UpdateStatus.SkipCurrentRow; }
/// <devdoc> /// Listens for the RowUpdate event on a data adapter to support UpdateBehavior.Continue /// </devdoc> private void OnOracleRowUpdated(object sender, OracleRowUpdatedEventArgs args) { if (args.RecordsAffected == 0) { if (args.Errors != null) { args.Row.RowError = SR.ExceptionMessageUpdateDataSetRowFailure; args.Status = UpdateStatus.SkipCurrentRow; } } }
/// <devdoc> /// Listens for the RowUpdate event on a data adapter to support UpdateBehavior.Continue /// </devdoc> private void OnOracleRowUpdated(object sender, OracleRowUpdatedEventArgs args) { if (args.RecordsAffected == 0) { if (args.Errors != null) { args.Row.RowError = "Failed to update row"; args.Status = UpdateStatus.SkipCurrentRow; } } }
private void myRowUpdatedHandler(object sender, OracleRowUpdatedEventArgs e) { Console.WriteLine("********************on row updated *******************"); // If this is an insert, then skip this row. if (e.StatementType == StatementType.Insert) { Console.WriteLine("********************on row updated : insert*******************"); // e.Status = UpdateStatus.SkipCurrentRow; // objDataAdapter.InsertCommand.Parameters["employee_id"].Value = (new OracleCommand("select EMPLOYEES_SEQ.nextVal from Dual ", dbConn).ExecuteScalar()); } }
/// <summary> /// 处理 DataAdapter 实例的数据更新错误处理方式。 /// </summary> private void OnRowUpdated(object sender, OracleRowUpdatedEventArgs args) { if (args.RecordsAffected == 0) { if (args.Errors != null) { args.Row.RowError = args.Errors.Message; args.Status = UpdateStatus.SkipCurrentRow; } } }
//为一个支持UpdateBehavior.Continue的DataAdapter对象监听RowUpdate事件 private void OnOracleRowUpdated(object sender, OracleRowUpdatedEventArgs args) { if (args.RecordsAffected == 0) { if (args.Errors != null) { args.Row.RowError = Resources.Data.RowUpdateFailed; args.Status = UpdateStatus.SkipCurrentRow; } } }
void OnRowUpdated(object sender, OracleRowUpdatedEventArgs e) { if (e.StatementType == StatementType.Insert) { CSpvAcces_Accesc2 accesAccesc2 = new CSpvAcces_Accesc2(e.Row); OracleCommand cmd = e.Command.Connection.CreateCommand(); cmd.Transaction = e.Command.Transaction; CSpvLienAccesAlarme accesAccesc = accesAccesc2.Acces_Accesc; if (accesAccesc.Surveiller == false && accesAccesc.SpvAlarmgeree != null) { cmd.CommandText = "Begin SetMaskAdmAccess (" + accesAccesc.Id + ",2); end;"; cmd.ExecuteScalar(); } } }
/// ///////////////////////////////////////////////////////////////// void m_adapter_RowUpdated(object sender, OracleRowUpdatedEventArgs e) { switch (e.StatementType) { case StatementType.Delete: break; case StatementType.Insert: MAJApresInsert(e.Row); break; case StatementType.Update: MAJApresUpdate(e.Row); break; case StatementType.Select: case StatementType.Batch: default: MAJApresSelect(e.Row); break; } if (RowUpdated != null) { RowUpdated(this, e); } }
void OnRowUpdated(object sender, OracleRowUpdatedEventArgs e) { if (e.StatementType == StatementType.Insert || e.StatementType == StatementType.Update) { C2iOracleDataAdapter adapter = sender as C2iOracleDataAdapter; CSpvEquip equipement = new CSpvEquip(e.Row); bool bSuperviser = equipement.ASuperviser; if (e.StatementType == StatementType.Insert || e.Row[CSpvEquip.c_champEQUIP_TOSURV] != e.Row[CSpvEquip.c_champEQUIP_TOSURV, DataRowVersion.Original]) { int nValeurMasquage = bSuperviser ? 0 : 2; OracleCommand cmd = e.Command.Connection.CreateCommand(); cmd.Transaction = e.Command.Transaction; cmd.CommandText = "Begin SetMaskAdmEquip(" + equipement.Id + "," + nValeurMasquage + "); end;"; cmd.ExecuteScalar(); } } }
private void oleDBda_RowUpdated(object sender, OracleRowUpdatedEventArgs e) { Exception exp = null; switch (e.StatementType) { case StatementType.Insert: try { BeginCase("RowInsert"); Compare(drInsert, e.Row); } catch (Exception ex) { exp = ex; } finally { EndCase(exp); exp = null; } EventCounter++; break; case StatementType.Delete: try { BeginCase("RowDelete"); Compare(drDelete, e.Row); } catch (Exception ex) { exp = ex; } finally { EndCase(exp); exp = null; } EventCounter++; break; case StatementType.Update: try { BeginCase("RowUpdate"); Compare(drUpdate, e.Row); } catch (Exception ex) { exp = ex; } finally { EndCase(exp); exp = null; } EventCounter++; break; } }
//Handler for RowUpdated event. private static void OnRowUpdated(object sender, OracleRowUpdatedEventArgs e) { PrintEventArgs(e); }
protected static void OnRowUpdated(object sender, OracleRowUpdatedEventArgs e) { DataRow r = e.Row; }
/// <summary> /// Handles the RowUpdated event /// </summary> /// <param name="obj">The object that published the event</param> /// <param name="e">The OracleRowUpdatedEventArgs</param> protected void RowUpdated(object obj, OracleRowUpdatedEventArgs e) { base.RowUpdated(obj, e); }
/// <devdoc> /// Listens for the RowUpdate event on a data adapter to support UpdateBehavior.Continue /// </devdoc> private void OnSybaseRowUpdated(object sender, OracleRowUpdatedEventArgs args) { if (args.RecordsAffected == 0) { if (args.Errors != null) { args.Row.RowError = SR.ExceptionMessageUpdateDataSetRowFailure; args.Status = UpdateStatus.SkipCurrentRow; } } }
/// <summary> /// 忽略空的更新 /// </summary> /// <param name="sender">引发事件的对象</param> /// <param name="args">事件参数</param> protected static void OnRowUpdated(object sender, OracleRowUpdatedEventArgs args) { if (args.Errors!=null) if(args.Errors is DBConcurrencyException) args.Status=UpdateStatus.SkipCurrentRow; }
/// <summary> /// Called when a dataset row is updated. /// </summary> /// <param name="sender">The sender.</param> /// <param name="args">The <see cref="Oracle.DataAccess.Client.OracleRowUpdatedEventArgs"/> instance containing the event data.</param> /// <remarks> /// Listens for the RowUpdate event on a data adapter to support UpdateBehavior.Continue /// </remarks> private void OnOracleRowUpdated(object sender, OracleRowUpdatedEventArgs args) { if(args.RecordsAffected == 0) { if(args.Errors != null) { args.Row.RowError = "행을 갱신하는데 실패했습니다."; args.Status = UpdateStatus.SkipCurrentRow; } } }