I have a SqlDataAdapter SqlRowUpdatedEventHandlerevent fired when a row is updated:
------------------------
m_daEvents.RowUpdated += new SqlRowUpdatedEventHandler(m_daEvents_RowUpdated);
m_daEvents.Update(m_dsOEEdb , "Events");
-----------------------------------------------
In the event handler I want to get information regarding the deleted row. However, I get a DeletedRowInaccessibleException when I tried to read the row information
--------------------------------------------------------------.
void m_daEvents_RowUpdated(object sender, SqlRowUpdatedEventArgs e)
{
if (e.StatementType == StatementType.Delete)
m_log = String.Format(m_cstrDeleteRow, e.Row[eEventColumnName.RecrdID.ToString()].ToString());
}
Is there a way to access the row information for the deleted row in the event handler?
Thanks in advance