private void RowUpdating(object sender, NpgsqlRowUpdatingEventArgs e)
{
if (e.Command != null)
{
if (e.StatementType == System.Data.StatementType.Insert)
{
e.Command.CommandText = gsbMSInsertCommandText.ToString();
}
else if (e.StatementType == System.Data.StatementType.Update)
{
foreach (string Kolon in gsbMSKolonAdlari.ToString().Split(','))
{
e.Command.CommandText = e.Command.CommandText.Replace(" " + Kolon + " ", " \"" + Kolon + "\" ").Replace("(" + Kolon + " ", "(\"" + Kolon + "\" ");
}
if (gLoglansinMi)
{
LogSQLOlustur(e.Row, "U");
}
}
else if (e.StatementType == System.Data.StatementType.Delete)
{
e.Command.CommandText = gsbMSDeleteCommandText.ToString();
}
}
}
void myDataAdapter_RowUpdating(object sender, NpgsqlRowUpdatingEventArgs e)
{
Logger.WriteLine("Debug ");
Logger.WriteLine(e.Command.CommandText);
//NpgsqlCommand cmd = e.Command as NpgsqlCommand;
for (int i = 0; i < e.Command.Parameters.Count; i++)
{
NpgsqlParameter p = e.Command.Parameters[i] as NpgsqlParameter;
Logger.WriteLine("param " + i + ":" + p.Value);
Logger.WriteLine("SourceColumn", p.SourceColumn);
// Logger.WriteLine("param " + i + ":" + p.NpgsqlValue+" ( NpgsqlValue )");
}
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void _RowUpdating(object sender, NpgsqlRowUpdatingEventArgs e)
{
if (e.Row.RowState == DataRowState.Added)
{
NpgsqlDataAdapter _adpater = (NpgsqlDataAdapter)sender;
_adpater.InsertCommand.CommandText = _bldDeltaAddSQL(e.Row);
}
else if (e.Row.RowState == DataRowState.Modified)
{
NpgsqlDataAdapter _adpater = (NpgsqlDataAdapter)sender;
_adpater.UpdateCommand.CommandText = _bldDeltaUpdSQL(e.Row);
}
}
/// <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, NpgsqlRowUpdatingEventArgs e)
{
base.RowUpdating(obj, e);
}
/// <summary>
/// Adds an event handler for the <see cref="NpgsqlDataAdapter.RowUpdating"/> event.
/// </summary>
/// <param name="sender">The sender</param>
/// <param name="e">A <see cref="NpgsqlRowUpdatingEventArgs"/> instance containing information about the event.</param>
private void RowUpdatingHandler(object sender, NpgsqlRowUpdatingEventArgs e)
{
base.RowUpdatingHandler(e);
}
