DataTable.Select - There is no Row at position X -- Exception

microsoft.public.dotnet.framework.adonet

2 May 2006 10:29 PM

Leandro Koiti

Hello, I'm facing this problem for a long time from now...

I have a datatable that after a set number of rows gets all rows deleted
(and archived into a xml) but to not have a clash with id's I set the start
index from the datatable to the last id written in the xml plus 1, no
problem...

BUT... after a lot of deletes and inserts, when I run a .Select statement
into a DataTable I get this error "There is no row at position X" where X is
a number that really doesn't exist... but I simply run a select statement,
not a foreach nor nothing... it's nonsense to look for a data that doesn't
exist...

e.g.: if my table is limited to 200 entries, after a few selects, deletes
and inserts, it starts to return an error at some random position (not sure
if is random but absolutely is not the same row) for example, BUT, sometimes,
it says that there's no row in a position that has a row... I already
debugged and in a few situations, this exception was thrown on the row 10,
for example, but looking at position 10 of the datatable I could find data
AND ACCESS IT...

Does anyone knows something about it? Is some kind of bug...? Am I missing
something?!

Thanks in advance