Unusual DataRow error

Administrator

I use: ... myDataTable.EndLoadData(); myDataTable.AcceptChanges(); foreach(DataRow dr in myDataTable.Rows) { string buf=dr["pole"].ToString()+"Jinks"; // works OK dr["pole"]=buf; // IndexOutOfRangeException "There is no row at position ..." int np= myDataTable.Columns["pole"].Ordinal; // works OK dr.ItemArray[np]=buf; // doesn't write to row, row status=Unchanged } Error is not in every field and in every row. Thesame is if buf is a number(double, decimal). May be someone know how to fight with it? Help, please.

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

thed0ct0r23y ago
myDataTable.EndLoadData(); myDataTable.AcceptChanges(); foreach(DataRow dr in myDataTable.Rows) { string buf=dr["pole"].ToString() buf+="Jinks"; int np= myDataTable.Columns["pole"].Ordinal; // works OK dr.ItemArray[np]=buf; }
+1
pgpno23y ago
Objects should not be modifed in foreach loops. lookup more help on MSDN about foreach. The above could have worked if you used int rowCount = myDataTable.Rows.Count; for(int i=0;i
+1
Andrzej Wegierski23y ago
Solved. See http://www.codeproject.com/script/comments/forums.asp?forumid=1649&Page=2&userid=56906&mode=all&select=407524&df=100&app=50&fr=9423#xx407524xx
+1
Administrator23y ago
My "simple calculations" are executed by "complicated" dynamically compiled class created with: CompilerResults cpl=icc.CompileAssemblyFromSource(options,source); but errors are without compilations too ...
+1
Administrator23y ago
My DataTable is dynamically created in first loop (about four hundred fields). In second and third loop it's loaded (about one hundred fields) from another tables. Fourth loop contains only simple calculations (additions, multiplications etc. - all fields) - errors are only in this loop. I tried to use/not to use Begin/EndLoad() and AcceptText() - without results. If I use Begin/EndEdit() error is during EndEdit() - while buffer is written I think. Thanks.
+1
Administrator23y ago
I understand. May it happen that you in some way alter the DataTable inside the loop, i.e. delete or add some rows? Mike
+1
Administrator23y ago
Yes, it's very unusual. I fight with this error during few days. There are some foreach loops in this class and only one doesn't work. Thesame errors are in another classes - with many foreach loops. In some cases loops are very simple, as in example and in some cases - very complicated - I use dynamic creating and compiling of classes in my loop.
+1
Administrator23y ago
It just does not make sense. Are you sure it`s Index out of range exception, and it fires at that point? Did you give us all the code inside Foreach? Mike
+1
Administrator23y ago
Who know this errror? Answer, please.
+1