private void odbcDataAdapter1_RowUpdated(object sender, OdbcRowUpdatedEventArgs e) { object[] items = e.Row.ItemArray; string itemString = ">" + items[7] + "x" + items[1] + "\"" + items[2] + "\"(Aritkelnummer" + items[0] + "),Größe:" + items[3] + ",Farbe:" + items[4] + ",Einzelpreis:" + items[5] + "EURO"; if (e.Status.Equals(UpdateStatus.ErrorsOccurred)) { e.Status = UpdateStatus.SkipCurrentRow; Console.WriteLine("Update für diese Zeile nicht ausgeführt:\n" + itemString); message += "\n"; message += itemString; } else { OdbcCommand odbccmd = getInsertCommand(e.Row); //.CommandText, odbcConnection1); //odbccmd.ExecuteNonQuery(); Console.WriteLine("Update für diese Zeile ausgefürt:\n" + itemString); Console.WriteLine("Insert-Anweisung:\n\t" + odbccmd.CommandText + "\n"); try { var T = odbccmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.GetType() + Environment.NewLine + ex.Message); } } }
private void odbcDataAdapter1_RowUpdated(object sender, OdbcRowUpdatedEventArgs e) { Console.WriteLine("SQL-Anweisung = " + e.Command.CommandText); Console.WriteLine("Statementtyp = " + e.StatementType); Console.WriteLine("Updating-Status = " + e.Status); //Console.WriteLine(e.Row.Table); //Console.WriteLine(e.Errors.HelpLink); //Console.WriteLine(e.Errors.HResult); //Console.WriteLine(e.Errors.InnerException); //Console.WriteLine(e.Errors.Message); //Console.WriteLine(e.Errors.Source); //Console.WriteLine(e.Errors.StackTrace); //Console.WriteLine(e.Errors.TargetSite); object[] items = e.Row.ItemArray; StringBuilder sb = new StringBuilder(); for (int i = 0; i < items.Length; i++) { sb.Append(items[i]); sb.Append(""); } if (e.Status.Equals(UpdateStatus.ErrorsOccurred)) { e.Status = UpdateStatus.SkipCurrentRow; //Console.WriteLine("Update für diese Zeile nicht ausgeführt:\n\t" + sb.ToString()); } else { //Console.WriteLine("Update für diese Zeile ausgeführt:\n\t" + sb.ToString()); } }
/// <devdoc> /// Listens for the RowUpdate event on a dataadapter to support UpdateBehavior.Continue /// </devdoc> private void OnOdbcRowUpdated(object sender, OdbcRowUpdatedEventArgs rowThatCouldNotBeWritten) { if (rowThatCouldNotBeWritten.RecordsAffected == 0) { if (rowThatCouldNotBeWritten.Errors != null) { rowThatCouldNotBeWritten.Row.RowError = SR.ExceptionMessageUpdateDataSetRowFailure; rowThatCouldNotBeWritten.Status = UpdateStatus.SkipCurrentRow; } } }
/// <summary> /// 处理 DataAdapter 实例的数据更新错误处理方式。 /// </summary> private void OnRowUpdated(object sender, OdbcRowUpdatedEventArgs args) { if (args.RecordsAffected == 0) { if (args.Errors != null) { args.Row.RowError = args.Errors.Message; args.Status = UpdateStatus.SkipCurrentRow; } } }
/// <summary> /// Handles the RowUpdated event /// </summary> /// <param name="obj">The object that published the event</param> /// <param name="e">The OdbcRowUpdatedEventArgs</param> protected void RowUpdated(object obj, OdbcRowUpdatedEventArgs e) { base.RowUpdated(obj, e); }
/// <summary> /// Extends BeginInvoke so that when a state object is not needed, null does not need to be passed. /// <example> /// odbcrowupdatedeventhandler.BeginInvoke(sender, e, callback); /// </example> /// </summary> public static IAsyncResult BeginInvoke(this OdbcRowUpdatedEventHandler odbcrowupdatedeventhandler, Object sender, OdbcRowUpdatedEventArgs e, AsyncCallback callback) { if (odbcrowupdatedeventhandler == null) { throw new ArgumentNullException("odbcrowupdatedeventhandler"); } return(odbcrowupdatedeventhandler.BeginInvoke(sender, e, callback, null)); }