Unusual DataRow error

Question

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.

thed0ct0r · Answer

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; }

pgpno · Answer

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<rowCount;i++) { dr = myDataTable.Rows[i]; ... dr[pole] = buf ..... }

Andrzej Wegierski · Answer

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

Administrator · Answer

My simple calculations are executed by complicated dynamically compiled class created with: CompilerResults cpl=icc.CompileAssemblyFromSource(optionssource); but errors are without compilations too ...

Administrator · Answer

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.

Administrator · Answer

I understand. May it happen that you in some way alter the DataTable inside the loop i.e. delete or add some rows? Mike

Administrator · Answer

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.

Administrator · Answer

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

Administrator · Answer

Who know this errror? Answer please.