RowNotInTableException on Delete Using SqlDataAdapter

[andrea96]

I am getting a RowNotInTableException with this error message when I attempt to delete a row from my database using a SqlDataAdapter.

This row has been removed from a table and does not have any data. BeginEdit() will allow creation of new data in this row.

My dataset is bound to a grid, and I delete the row by deleting a row on the grid.

Here is my code to build the DeleteCommand.

cmdComponents = New SqlCommand
With cmdComponents
    .Connection = cnnComponents
    .CommandType = CommandType.StoredProcedure
    .CommandText = "aih_clDeleteKitComponents"
    .Parameters.Add(New SqlParameter("@KitNo", SqlDbType.VarChar, 30, "kit_no"))
    .Parameters.Add(New SqlParameter("@SequenceId", SqlDbType.Int, 4, "sequence_id"))
End With
daComponents.DeleteCommand = cmdComponents

My stored procedure executes correctly in Query Analyzer.

I found something on the web that said this error could be caused by the delete command reading from the current dataset values instead of the original. So, I created a dataview of the dataset and can see that the original values are in the dataview just before the sqldataadapter.update is executed.

I'm running out of ideas, so any help would be appreciated.

Thanks,
Andrea

 

[andrea96]

I figured out my problem. I was handling the RowChanged event for the DataSet table in a form. The code in the handler was trying to access some of the row values, causing the exception. I added a statement to check for a Detached RowState in the handler, and that fixed the problem.