//end callback
protected static void adapter_RowUpdating(
object sender, SqlRowUpdatingEventArgs args)
{
if (args.StatementType == StatementType.Update)
{
}
}
/// <summary>
/// The procedure is called when row in the child table is updating to the database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
/// <Author>Jatinder Singh</Author>
/// <Date Created>3-Oct-2007</Date>
private void _SqlDataAdapterObject_RowUpdating(object sender, SqlRowUpdatingEventArgs e)
{
try
{
if (e.StatementType == StatementType.Insert)
{
if (newID != 0)
{
e.Row["EventId"] = newID;
}
}
//else if (e.Row["RecordDeleted"] == DBNull.Value || Convert.ToString(e.Row["RecordDeleted"]) == "N")
//{
// _ClaimLineStatus = (int)SqlHelper.ExecuteScalar(e.Command.Transaction, CommandType.Text, "Exec ssp_PAGetClaimLinesStatus " + e.Row["ClaimLineID"]);
// if (_ClaimLineStatus != (int)e.Row["Status"])
// _ClaimLineStatus = 1;
//}
}
catch (Exception ex)
{
//sqlTransactionDx.Rollback();
//if (ex.Data["CustomExceptionInformation"] == null)
// ex.Data["CustomExceptionInformation"] = "###Source Function Name - _SqlDataAdapterObject_RowUpdating(), ParameterCount - 2, First Parameter- " + sender.ToString() + ", Second Parameter- " + e.ToString() + "###";
throw (ex);
}
}
private void DisplayEventArgs(SqlRowUpdatingEventArgs args)
{
listBox1.Items.Add("OnRowUpdating event");
if (args.Status != UpdateStatus.Continue)
{
listBox1.Items.Add("RowStatus = " + args.Status.ToString());
}
}
private static void PrintEventArgs(SqlRowUpdatingEventArgs args)
{
Console.WriteLine("OnRowUpdating");
Console.WriteLine(" event args: (" +
" command=" + args.Command +
" commandType=" + args.StatementType +
" status=" + args.Status + ")");
}
private static void adapter_RowUpdating(object sender, SqlRowUpdatingEventArgs e)
{
Console.WriteLine(Convert.ToString(e.Row["IdComprobante"]));
foreach (SqlParameter param in e.Command.Parameters)
{
Console.WriteLine("Pasrametro " + param.ParameterName + ": " + Convert.ToString(param.Value));
}
}
private void WriteRowUpdating(string title, SqlRowUpdatingEventArgs e)
{
Console.WriteLine(title);
Console.WriteLine("Status: {0}", e.Status);
Console.WriteLine("StatementType: {0}", e.StatementType);
WriteCommand("Command", e.Command);
Console.WriteLine("");
}
private void sqlDataAdapter1_RowUpdating(object sender, SqlRowUpdatingEventArgs e)
{
NorthwindDataSet.CustomersRow CustRow = (NorthwindDataSet.CustomersRow)e.Row;
DialogResult response = MessageBox.Show("Continue updating " + CustRow.CustomerID.ToString() + "?", "Continue Update?", MessageBoxButtons.YesNo);
if (response == DialogResult.No)
{
e.Status = UpdateStatus.SkipCurrentRow;
}
}
protected static void OnRowUpdating(object sender, SqlRowUpdatingEventArgs args)
{
if (args.StatementType == StatementType.Delete)
{
// Saves the removing rows with additional information in a file.
System.IO.TextWriter tw = System.IO.File.AppendText("Deletes.log");
tw.WriteLine(
"{0}: Customer {1} Deleted.", DateTime.Now,
args.Row["CustomerID", DataRowVersion.Original]);
tw.Close();
}
}
protected static void OnRowUpdating(object sender, SqlRowUpdatingEventArgs args)
{
if (args.StatementType == StatementType.Delete)
{
}
else if (args.StatementType == StatementType.Insert)
{
}
else if (args.StatementType == StatementType.Update)
{
}
}
// define the event handlers
public static void RowUpdatingEventHandler(
object sender,
SqlRowUpdatingEventArgs mySRUEA
)
{
Console.WriteLine("\nIn RowUpdatingEventHandler()");
if ((mySRUEA.StatementType == StatementType.Insert) &&
((string)mySRUEA.Row["CustomerID"] == "J5COM1"))
{
Console.WriteLine("Skipping current row");
mySRUEA.Status = UpdateStatus.SkipCurrentRow;
}
}
private static void adapter_RowUpdating(object sender, SqlRowUpdatingEventArgs e)
{
foreach (SqlParameter param in e.Command.Parameters)
{
if (param.ParameterName == "@FechaUltimaCompra")
{
if (e.Row["FechaUltimaCompra"].Equals(DateTime.MinValue))
{
e.Command.Parameters["@FechaUltimaCompra"].Value = System.DBNull.Value;
}
}
}
}
/*
* The following is a workaround for a bug that is appearing
*/
private void adapter_RowUpdating(object sender, SqlRowUpdatingEventArgs e)
{
if (e.Command != null)
{
if (e.Command.Connection == null || string.IsNullOrWhiteSpace(e.Command.Connection.ConnectionString))
{
if (this.workingConnection != null)
{
e.Command.Connection = this.workingConnection;
}
}
}
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void _RowUpdating(object sender, SqlRowUpdatingEventArgs e)
{
if (e.Row.RowState == DataRowState.Added)
{
SqlDataAdapter _adpater = (SqlDataAdapter)sender;
_adpater.InsertCommand.CommandText = _bldDeltaAddSQL(e.Row);
}
else if (e.Row.RowState == DataRowState.Modified)
{
SqlDataAdapter _adpater = (SqlDataAdapter)sender;
_adpater.UpdateCommand.CommandText = _bldDeltaUpdSQL(e.Row);
}
}
private void DaEmp_RowUpdating(object sender, SqlRowUpdatingEventArgs e)
{
// validate if new salary is greater than 1000
if (e.StatementType == StatementType.Update)
{
decimal newSalary = Convert.ToDecimal(e.Row["Salary", DataRowVersion.Current]);
decimal oldSalary = Convert.ToDecimal(e.Row["Salary", DataRowVersion.Original]);
if (newSalary - oldSalary > 1000)
{
e.Status = UpdateStatus.SkipCurrentRow;
MessageBox.Show("Validation failed...");
e.Row.RejectChanges();
}
}
}
private void da_RowUpdating(object sender, SqlRowUpdatingEventArgs e)
{
// https://flylib.com/books/en/1.105.1/performing_batch_updates_with_a_dataadapter.html
// Get the command for the current row update.
if (e.Command == null)
{
return;
}
StringBuilder sqlText = new StringBuilder(e.Command.CommandText.ToString());
// Replace the parameters with values.
for (int i = e.Command.Parameters.Count - 1; i >= 0; i--)
{
SqlParameter parm = e.Command.Parameters[i];
if (parm.Value == DBNull.Value)
{
sqlText.Replace(parm.ParameterName, "null");
continue;
}
if (parm.SqlDbType == SqlDbType.NVarChar || parm.SqlDbType == SqlDbType.NText || parm.SqlDbType == SqlDbType.UniqueIdentifier)
{
// Quotes around the nvarchar and ntype fields
sqlText.Replace(parm.ParameterName, "'" + parm.Value.ToString( ) + "'");
continue;
}
if (parm.SqlDbType == SqlDbType.DateTime || parm.SqlDbType == SqlDbType.DateTime2)
{
// format datetime
sqlText.Replace(parm.ParameterName, String.Format("'{0:yyyy-MM-ddTHH:mm:ss}'", parm.Value));
continue;
}
sqlText.Replace(parm.ParameterName, parm.Value.ToString( ));
}
// Add the row command to the aggregate update command.
_sb.Append(sqlText.ToString( ) + ";");
// Skip the DataAdapter update of the row.
e.Status = UpdateStatus.SkipCurrentRow;
}
//'-------OnRowUpdating -----------------------------
private static void OnRowUpdating(object sender, SqlRowUpdatingEventArgs args)
{
try
{
if (args.StatementType == StatementType.Delete)
{
System.IO.TextWriter tw = System.IO.File.AppendText("Delete.log");
tw.Close();
}
}
catch (Exception ex)
{
LibraryMOD.ShowErrorMessage(ex);
}
finally
{
}
}
/// <summary>
/// 日期类型需要转换
/// </summary>
protected void OnAdapterRowUpdating(object sender, SqlRowUpdatingEventArgs e)
{
foreach (SqlParameter p in e.Command.Parameters)
{
if (p.SqlDbType != SqlDbType.DateTime)
{
continue;
}
if (string.IsNullOrEmpty(p.Value.ToString()))
{
p.Value = DBNull.Value; continue;
}
if (DateTime.Parse(p.Value.ToString()).ToString("yyyyMMdd") == DateTime.MinValue.ToString("yyyyMMdd"))
{
p.Value = DBNull.Value; continue;
}
}
}
private void sqlDa_RowUpdating(object sender, SqlRowUpdatingEventArgs 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;
}
}
private void MSSQL_RowUpdating(object sender, SqlRowUpdatingEventArgs e)
{
if (e.StatementType == StatementType.Insert)
{
//DataColumnCollection _columns = e.Row.Table.Columns;
//foreach (DataColumn dc in _columns)
//{
// if (dc.AutoIncrement)
// {
// e.Command.CommandText = e.Command.CommandText + ";SELECT @GZFramework_ID = SCOPE_IDENTITY()";
// e.Command.Parameters.Add("@GZFramework_ID", SqlDbType.Int);
// e.Command.Parameters["@GZFramework_ID"].Direction = ParameterDirection.Output;
// break;
// }
//}
if (e.Row.Table.Columns.Contains(IDENTITYCOLUMNNAME))
{
e.Command.CommandText = e.Command.CommandText + ";SELECT @GZFramework_ID = SCOPE_IDENTITY()";
e.Command.Parameters.Add("@GZFramework_ID", SqlDbType.Int);
e.Command.Parameters["@GZFramework_ID"].Direction = ParameterDirection.Output;
}
}
}
// Event Handler for RowUpdating event
private void OnRowUpdating(object sender, SqlRowUpdatingEventArgs e)
{
DisplayEventArgs(e);
}
/// <summary>
/// Handles the RowUpdating event
/// </summary>
/// <param name="obj">The object that published the event</param>
/// <param name="e">The SqlRowUpdatingEventArgs</param>
protected void RowUpdating(object obj, SqlRowUpdatingEventArgs e)
{
base.RowUpdating(obj, e);
}
void sqlDataAdapter_RowUpdating(object sender, SqlRowUpdatingEventArgs e)
{
e.Status = UpdateStatus.Continue;
}
/// <summary>
/// Extends BeginInvoke so that when a state object is not needed, null does not need to be passed.
/// <example>
/// sqlrowupdatingeventhandler.BeginInvoke(sender, e, callback);
/// </example>
/// </summary>
public static IAsyncResult BeginInvoke(this SqlRowUpdatingEventHandler sqlrowupdatingeventhandler, Object sender, SqlRowUpdatingEventArgs e, AsyncCallback callback)
{
if (sqlrowupdatingeventhandler == null)
{
throw new ArgumentNullException("sqlrowupdatingeventhandler");
}
return(sqlrowupdatingeventhandler.BeginInvoke(sender, e, callback, null));
}
private void SqlRowUpdating(object sender, SqlRowUpdatingEventArgs ruevent)
{
RowUpdating(sender, ruevent);
}
// <Snippet1>
// handler for RowUpdating event
private static void OnRowUpdating(object sender, SqlRowUpdatingEventArgs e)
{
PrintEventArgs(e);
}
private void SqlHandler2(object sender, SqlRowUpdatingEventArgs e)
{
WriteRowUpdating("Handler 2:", e);
}
static void da_RowUpdating(object sender, SqlRowUpdatingEventArgs e)
{
e.Status = UpdateStatus.Continue;
}
private void OnRowUpdating(object sender, SqlRowUpdatingEventArgs e)
{
//PrintEventArgs(e);
return;
}
private static void adapter_RowUpdating(object sender, SqlRowUpdatingEventArgs e)
{
}
