System.Data.RowNotInTableException

Wednesday, November 3, 2004

I got this exception for the first time today:

Exception Type: System.Data.RowNotInTableException
Message: This row has been removed from a table and does not have any data. BeginEdit() will allow creation of new data in this row.
TargetSite: Int32 GetDefaultRecord()
HelpLink: NULL
Source: System.Data

After staring at it for a minute, I realized what I was doing.

Classic case of iterating through Rows collection and trying to call remove on a DataRow found, while still iterating the Collection.

Now, I temporarily store the DataRow and Remove it after iterating through all the Rows.

6 Comments

"Now, I temporarily store the DataRow and Remove it after iterating through all the Rows."

How did you do it?

adol - Thursday, November 25, 2004 8:20:00 PM

As you iterate through the rows collection and find a row you need to delete, store it in a collection (I uses an ArrayList). Once the iteration is complete, the for each datarow in the collection, remove it from your datatable.

Greg - Sunday, November 28, 2004 4:46:00 PM

have you tried walking the row collection backwards? that way your not changing the position of any rows that you have yet to 'touch'

Phil - Monday, November 29, 2004 4:06:00 PM

I encountered this error but I haven't used a DataTable. It's a weird case in my part.

Willy David Jr - Thursday, October 11, 2007 1:44:18 AM

I have resolved this problem.....
for solution contact me at nitesh_dobariya@yahoo.com
as it required lots of settings

nitesh dobariya - Monday, April 21, 2008 11:08:41 AM

Send your solution to my e-mail id vijaystar12@yahoo.com

T.Vijaya Kumar - Tuesday, October 26, 2010 11:41:53 AM

Comments have been disabled for this content.