Error after DeleteRow event - Cannot perform this operation on a row not in a table

Glayaar — Thu, 03 Jun 2010 23:34:10 GMT

Here is the DeleteRow event handler for manually bound data set, I am using OleDBDataAdapter in order to fill the dataset:

void WebGrid1_DeleteRow(object sender, ISNet.WebUI.WebGrid.RowEventArgs e)
{
    DataSet ds = (DataSet)WebGrid1.DataSource;
    ((DataRowView)e.Row.DataRow).Row.Delete();
    da.Update(ds);
    e.ReturnValue = false;
}

You will need to manually call the delete function for the deleted row and using data adapter to persist the change to the database. You will also need to set the ReturnValue to false for such scenario in order to avoid any further process done by WebGrid to the deleted row.

Error after DeleteRow event - Cannot perform this operation on a row not in a table

mdearman@libera.com — Thu, 03 Jun 2010 17:21:12 GMT

I have a grid manually bound to a DataSet and am handling the DeleteRow event with custom code.

I noticed the grid does not automatically set the underlying DataRow object to the Deleted state.
The row currently has the RowState of Unchanged.
I need to call the DataRow.Delete method on this row so that my data adapter can see that the row was deleted properly.

However, during the DeleteRow process I call the AcceptChanges method so that the DataSet is committed properly. This makes the row Detached.

Immediately after leaving the DeleteRow event, the WebGrid throws an internal error "Cannot perform an operation on a row not in the table".

What is the proper order/methods to call to properly delete a DataRow in the underlying data source and have it delete the WebGridRow without error in the grid. The above methods used to work in WebGrid 3.5 but now doesn't in WebGrid 7.

Thanks,

Mike

Intersoft Community - WebGrid Enterprise - Error after DeleteRow event - Cannot perform this operation on a row not in a table

Error after DeleteRow event - Cannot perform this operation on a row not in a table

Error after DeleteRow event - Cannot perform this operation on a row not in a table